public CustomerInfo CustomerIDataReader(IDataReader dr) { DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo(); obj.CustomerID = (dr["CustomerID"] is DBNull) ? string.Empty : dr["CustomerID"].ToString(); obj.UserName = (dr["UserName"] is DBNull) ? string.Empty : dr["UserName"].ToString(); obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString(); obj.FullName = (dr["FullName"] is DBNull) ? string.Empty : dr["FullName"].ToString(); obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString(); obj.Birthday = (dr["Birthday"] is DBNull) ? string.Empty : dr["Birthday"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString(); obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString(); obj.MobileNumber = (dr["MobileNumber"] is DBNull) ? string.Empty : dr["MobileNumber"].ToString(); obj.HomePhone = (dr["HomePhone"] is DBNull) ? string.Empty : dr["HomePhone"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); return(obj); }
public List <CustomerInfo> Customer_GetByAll() { List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>(); DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo(); DbCommand cmd = db.GetStoredProcCommand("CustomerInfos_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.CustomerIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <CustomerInfo> Customer_Paging(string CurentCustomerInfo, string CustomerInfoSize) { List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>(); DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo(); DbCommand cmd = db.GetStoredProcCommand("CustomerInfos_SelectPage", CurentCustomerInfo, CustomerInfoSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.CustomerIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <CustomerInfo> Customer_GetByLevel(string Level, int LevelLength) { List <DataAccess.CustomerInfo> list = new List <DataAccess.CustomerInfo>(); DataAccess.CustomerInfo obj = new DataAccess.CustomerInfo(); DbCommand cmd = db.GetStoredProcCommand("sp_CustomerInfo_GetByLevel", Level, LevelLength); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.CustomerIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }