/// <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);
}
