private void LoadDataToDropdownlist()
{
MsRequisitionTypeLinqDB rtLnq = new MsRequisitionTypeLinqDB();
string rtSql = "select distinct requisition_type_name name_value, requisition_type_name name_display";
rtSql += " from TS_FILE_SCAN_SUMMARY ";
rtSql += " order by name_display";
DataTable rtDt = rtLnq.GetListBySql(rtSql, null);
if (rtDt.Rows.Count > 0)
{
DataRow dr = rtDt.NewRow();
dr["name_value"] = "";
dr["name_display"] = "เลือก";
rtDt.Rows.InsertAt(dr, 0);
cbReqType.DataSource = rtDt;
cbReqType.ValueMember = "name_value";
cbReqType.DisplayMember = "name_display";
}
MsPatentTypeLinqDB ptLnq = new MsPatentTypeLinqDB();
DataTable ptDt = ptLnq.GetDataList("active_status='1'", "id", null);
if (ptDt.Rows.Count > 0)
{
DataRow dr = ptDt.NewRow();
dr["id"] = Convert.ToInt64(0);
dr["patent_type_name"] = "เลือก";
ptDt.Rows.InsertAt(dr, 0);
cbPatentType.DataSource = ptDt;
cbPatentType.ValueMember = "id";
cbPatentType.DisplayMember = "patent_type_name";
}
}
private void LoadDataToDropdownlist()
{
MsRequisitionTypeLinqDB rtLnq = new MsRequisitionTypeLinqDB();
string rtSql = "select id, epatent_type_name ";
rtSql += " from MS_REQUISITION_TYPE ";
rtSql += " where epatent_type_name is not null ";
rtSql += " and active_status=1";
rtSql += " order by epatent_type_name";
DataTable rtDt = rtLnq.GetListBySql(rtSql, null);
if (rtDt.Rows.Count > 0)
{
DataRow dr = rtDt.NewRow();
dr["id"] = "0";
dr["epatent_type_name"] = "เลือก";
rtDt.Rows.InsertAt(dr, 0);
cbReqType.DataSource = rtDt;
cbReqType.ValueMember = "id";
cbReqType.DisplayMember = "epatent_type_name";
}
}
