public List <Customers> GetFillerList(Customers FilterCS)
{
string SQLStr = "select * from Customers where Customer_DelFlag=1 ";//改成逻辑删除
List <SqlParameter> SQLps = new List <SqlParameter>();
if (!String.IsNullOrEmpty(FilterCS.Customer_Name))
{
SQLStr += " and Customer_Name like @CSName";
SQLps.Add(new SqlParameter("@CSName", "%" + FilterCS.Customer_Name + "%"));
}
if (FilterCS.Customer_Gender == "男" || FilterCS.Customer_Gender == "女")
{
SQLStr += " and Customer_Gender= @CSGender";
SQLps.Add(new SqlParameter("@CSGender", FilterCS.Customer_Gender));
}
if (!String.IsNullOrEmpty(FilterCS.Customer_Phone))
{
SQLStr += " and Customer_Phone like @CSPhone";
SQLps.Add(new SqlParameter("@CSPhone", "%" + FilterCS.Customer_Phone + "%"));
}
if (!String.IsNullOrEmpty(FilterCS.Customer_Email))
{
SQLStr += " and Customer_Email like @CSEmail";
SQLps.Add(new SqlParameter("@CSEmail", "%" + FilterCS.Customer_Email + "%"));
}
List <Customers> FilterResult = new List <Customers>();
DataTable dt = new DataTable();
dt = SQLHelper.Adapter(SQLStr, SQLps.ToArray());
foreach (DataRow DTrow in dt.Rows)
{
FilterResult.Add(new Customers()
{
Customer_ID = Convert.ToInt32(DTrow["ID"]),
Customer_Name = Convert.ToString(DTrow["Customer_Name"]),
Customer_Gender = Convert.ToString(DTrow["Customer_Gender"]),
Customer_Phone = Convert.ToString(DTrow["Customer_Phone"]),
Customer_Email = Convert.ToString(DTrow["Customer_Email"]),
Customer_Birthday = Convert.ToDateTime(DTrow["Customer_Birthday"])
}
);
}
return(FilterResult);
}
public List <Customers> Get_Customers_List()
{
string SQLStr = "select * from Customers";
DataTable dt = new DataTable();
List <Customers> customersList = new List <Customers>();
dt = SQLHelper.Adapter(SQLStr);
foreach (DataRow DTrow in dt.Rows)
{
customersList.Add(new Customers()
{
Customer_ID = Convert.ToInt32(DTrow["ID"]),
Customer_Name = Convert.ToString(DTrow["Customer_Name"]),
Customer_Gender = Convert.ToString(DTrow["Customer_Gender"]),
Customer_Phone = Convert.ToString(DTrow["Customer_Phone"]),
Customer_Email = Convert.ToString(DTrow["Customer_Email"]),
Customer_Birthday = Convert.ToDateTime(DTrow["Customer_Birthday"])
}
);
}
return(customersList);
}
