<!-- 一行 -->
<div class="form-group kstar-control">
<div class="kstar-control">
<label class="control-label col-sm-1">
<font color="red">*</font>核發代碼:
</label>
<div class="kdropdownDiv col-sm-2 ">
<input id="IssuingCode" class="form-control kdrowlist" title="核發代碼" data-bind="value: IssuingCode" onchange="$(this).val($(this).val().trim());" />
</div>
</div>
</div>
//獲取核發代碼下拉并設置
function GetIssuingCodeList() {
$("#IssuingCode").kendoDropDownList({
dataTextField: 'DropDownText',
dataValueField: 'DropDownValue',
index: 0,
dataSource: {
transport: {
read: {
type: 'post',
dataType: "json",
async: false,
url: "/IssuancePurchaseOrders/IssuancePurchaseOrders/GetIssuingCodeList"
}
}
},
change: function () {
var i = this.element[0].parentNode.parentNode.parentNode.rowIndex;
}
});
KStarForm.koContentModel.IssuingCode($("#IssuingCode").data("kendoDropDownList").value());
}
//kendo select的數據源格式
public class DropDownBasicData
{
public string DropDownId { get; set; }
public string DropDownValue { get; set; }
public string DropDownText { get; set; }
}
//獲取核發代碼下拉數據
public JsonResult GetIssuingCodeList()
{
string conaZaaSKStar = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SAPMaster"].ToString();
List<DropDownBasicData> result = new List<DropDownBasicData>();
SqlDataReader dr = null;
var sql = @"查找语句";
dr = SqlHelper.ExecuteReader(conaZaaSKStar, System.Data.CommandType.Text, sql, null);
while (dr.Read())
{
if (dr[0].ToString() != null && dr[0].ToString() != "")
{
result.Add(new DropDownBasicData { DropDownId = dr[0].ToString().Trim(), DropDownText = dr[0].ToString().Trim() + '_' + dr[1].ToString().Trim() + "_" + dr[2].ToString().Trim(), DropDownValue = dr[0].ToString().Trim() });
}
}
//去掉重复的数据
result = result.Distinct().ToList();
result.Insert(0, new DropDownBasicData { DropDownId = "--請選擇--", DropDownText = "--請選擇--", DropDownValue = "" });
return Json(result);
}