//返回基礎資料,供下拉列表框使用 //前端是以ID值存儲至數據庫 public static List <BaseDataModels> GetBaseInfoReturnList(string strTableName) { string strSql = ""; string strFieldName = ""; if (LanguageID == "0") { strFieldName = "name"; } else { strFieldName = "english_name"; } switch (strTableName) { case "bs_personnel": //跟單員 strTableName = "bs_sales"; strSql = string.Format(@"Select id,id +' ('+{0}+')' as name FROM {1} Where ISNULL(abbrev_id,'')='' and state<>'2' order by id", strFieldName, strTableName); break; case "bs_sales": //營業員 strSql = string.Format(@"Select id,id +' ('+{0}+')' as name FROM {1} Where ISNULL(abbrev_id,'')<>'' and state<>'2' order by id", strFieldName, strTableName); break; case "sy_bill_state": //單據狀態 strSql = string.Format(@"SELECT id,matter as name FROM sy_bill_state WHERE language_id='{0}'", LanguageID); break; case "bs_type_zd": //取色辦 strTableName = "bs_type"; strSql = string.Format(@"SELECT id,id +' ('+{0}+')' as name FROM {1} WHERE group_id='ZD' and state<>'2' order by id", strFieldName, strTableName); break; case "bs_vendor": //取採購供應商 strSql = string.Format(@"SELECT id,id +' ('+{0}+')' as name FROM {1} WHERE type<>'OP' and state<>'2' order by id", strFieldName, strTableName); break; default: //大多數的 strSql = string.Format(@"Select id,id +' ('+{0}+')'as name FROM {1} Where state<>'2' order by id", strFieldName, strTableName); break; } DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); List <BaseDataModels> lstBase = new List <BaseDataModels>(); for (int i = 0; i < dt.Rows.Count; i++) { BaseDataModels objModel = new BaseDataModels(); objModel.ID = dt.Rows[i]["id"].ToString(); objModel.Name = dt.Rows[i]["name"].ToString(); lstBase.Add(objModel); } return(lstBase); }
public static List <BaseDataModels> GetUnit(string kind) { string strSql = "Select ID,Name,english_name " + " FROM bs_unit Where kind='" + kind + "' Order By id"; DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); List <BaseDataModels> lsModel = new List <BaseDataModels>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; BaseDataModels mdj = new BaseDataModels(); mdj.ID = dr["id"].ToString(); mdj.Name = dr["name"].ToString(); lsModel.Add(mdj); } return(lsModel); }
public static List <BaseDataModels> GetLoc() { string strSql = "Select ID,Name,Engname,VieName " + " FROM bs_Loc Order By ID"; DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); List <BaseDataModels> lsModel = new List <BaseDataModels>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; BaseDataModels mdj = new BaseDataModels(); mdj.ID = dr["id"].ToString(); mdj.Name = dr["name"].ToString(); lsModel.Add(mdj); } return(lsModel); }
//public static DataTable GetUnitReturnDataTable() //{ // string strSql = "Select ID,Name,English_name,VieName " + // " FROM bs_Unit Order By ID"; // DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); // return dt; //} public static List <BaseDataModels> GetDocFlag(string DocType) { string strSql = "Select ID,Name,Engname,VieName " + " FROM bs_DocFlag " + " Where DocType='" + DocType + "'" + " Order By id"; DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); List <BaseDataModels> lsModel = new List <BaseDataModels>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; BaseDataModels mdj = new BaseDataModels(); mdj.ID = dr["ID"].ToString(); mdj.Name = dr["Name"].ToString(); lsModel.Add(mdj); } return(lsModel); //return dt; }
//返回基礎資料,供下拉列表框使用 //前端是以Name值存儲至數據庫 public static List <BaseDataModels> GetBaseInfoByNameReturnList(string strTableName) { string strSql = ""; switch (strTableName) { case "bs_company_accounts": //銀行賬號 strSql = string.Format("SELECT accounts as id FROM {0} WHERE state<> '2' order by abbreviate", strTableName); break; case "bs_customer": //洋行 strSql = "Select 'N/A' as id Union Select id FROM bs_customer Where state='1' and customer_group='2' order by id"; break; case "bs_unit": //數量單位 strSql = "Select id FROM bs_unit Where kind = '05' and state='0' order by id"; break; case "bs_unit_wt": //重量單位 strSql = "Select id FROM bs_unit Where kind = '03' and state='0' order by id"; break; case "bs_unit_all": //單位All strSql = "Select id FROM bs_unit Where state='0' order by kind DESC,id"; break; case "bs_type_1": //制單種類 case "bs_type_2": //做貨部門 case "bs_type_3": //營業員組別 string group_id = ""; switch (strTableName) { case "bs_type_1": group_id = "1"; break; case "bs_type_2": group_id = "2"; break; case "bs_type_3": group_id = "3"; break; } strSql = string.Format(@"SELECT id FROM bs_type WHERE group_id='{0}' and state<>'2' order by id", group_id); break; default: strSql = string.Format("Select english_name as id FROM {0} Where state<>'2' order by id", strTableName); break; } DataTable dt = SQLHelper.ExecuteSqlReturnDataTable(strSql); List <BaseDataModels> lstBase = new List <BaseDataModels>(); for (int i = 0; i < dt.Rows.Count; i++) { BaseDataModels objModel = new BaseDataModels(); objModel.ID = dt.Rows[i]["id"].ToString(); lstBase.Add(objModel); } return(lstBase); }