/// <summary> /// 获取某年所有假期其訊息 /// </summary> /// <param name>date</param> /// <returns></returns> public List <MODEL.doc_Buyer> GetlBuyerE(string yyyymm) { string sql = @" select CustomName,CustomBuyName,AimArea Destination from T_StyleCodeInfo where OrderDate >=@OrderDate and AimArea is not null Group by CustomName,CustomBuyName,AimArea except select CustomName,CustomBuyName,Destination from doc_Buyer "; SqlParameter p = new SqlParameter("@OrderDate", yyyymm); DataTable dt = SqlHelper.ExcuteTable(sql, p); List <MODEL.doc_Buyer> listbuyere = null; if (dt.Rows.Count > 0) { listbuyere = new List <MODEL.doc_Buyer>(); foreach (DataRow row in dt.Rows) { MODEL.doc_Buyer c = new MODEL.doc_Buyer(); LoadDataToList1(row, c); listbuyere.Add(c); } } return(listbuyere); }
/// 加载行数据到对象--集合 /// </summary> /// <param name="dr"></param> /// <param name="classes"></param> public void LoadDataToList1(DataRow dr, MODEL.doc_Buyer buyer) { buyer.CustomName = (string)SqlHelper.FromDbValue(dr["CustomName"]); string ds = (string)SqlHelper.FromDbValue(dr["Destination"]); buyer.Destination = ds.Trim(); buyer.CustomBuyName = (string)SqlHelper.FromDbValue(dr["CustomBuyName"]); }
/// 加载行数据到对象--集合 /// </summary> /// <param name="dr"></param> /// <param name="classes"></param> public void LoadDataToList(DataRow dr, MODEL.doc_Buyer buyer) { buyer.Guid = (Guid)SqlHelper.FromDbValue(dr["Guid"]); //GUiD buyer.CustomName = (string)SqlHelper.FromDbValue(dr["CustomName"]); buyer.CustomBuyOwner = (string)SqlHelper.FromDbValue(dr["CustomBuyOwner"]); buyer.CustomBuyName = (string)SqlHelper.FromDbValue(dr["CustomBuyName"]); buyer.CartonBarcodeNeed = (string)SqlHelper.FromDbValue(dr["CartonBarcodeNeed"]); buyer.Forwarder = (string)SqlHelper.FromDbValue(dr["Forwarder"]); buyer.Type = (string)SqlHelper.FromDbValue(dr["Type"]); buyer.State = (string)SqlHelper.FromDbValue(dr["State"]); buyer.Country = (string)SqlHelper.FromDbValue(dr["Country"]); buyer.CountryChinese = (string)SqlHelper.FromDbValue(dr["CountryChinese"]); buyer.Destination = (string)SqlHelper.FromDbValue(dr["Destination"]); }
/// <summary> /// 获取某年所有假期其訊息 /// </summary> /// <param name>date</param> /// <returns></returns> public List <MODEL.doc_Buyer> GetAllBuyer() { string sql = "select * from doc_Buyer order by CustomName,CustomBuyOwner,CustomBuyName,Destination "; DataTable dt = SqlHelper.ExcuteTable(sql); List <MODEL.doc_Buyer> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_Buyer>(); foreach (DataRow row in dt.Rows) { MODEL.doc_Buyer c = new MODEL.doc_Buyer(); LoadDataToList(row, c); lists.Add(c); } } return(lists); }
public List <MODEL.doc_Buyer> GetAllBuyer(List <string> codes, List <string> values) { if (codes.Count > 0) { codes.Distinct().ToList(); } if (values.Count > 0) { values.Distinct().ToList(); } string sqlstr = ""; if (codes.Count > 0) { for (int i = 0; i < codes.Count; i++) { sqlstr = sqlstr + codes[i] + " like '%" + values[i] + "%' and "; } } string sql = @"select * from doc_Buyer WHERE " + sqlstr + @" 1=1 order by CustomName,CustomBuyOwner,CustomBuyName,Destination"; DataTable dt = SqlHelper.ExcuteTable(sql); List <MODEL.doc_Buyer> lists = null; if (dt.Rows.Count > 0) { lists = new List <MODEL.doc_Buyer>(); foreach (DataRow row in dt.Rows) { MODEL.doc_Buyer c = new MODEL.doc_Buyer(); LoadDataToList(row, c); lists.Add(c); } } return(lists); }