public bool CreateToSup(SD_Customer cust)
{
if (instance.Add(cust) > 0)
{
return true;
}
return false;
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name="strCondition"></param>
/// <returns></returns>
public SD_Customer GetModel(string strCondition)
{
List<SD_Customer> list = instance.GetListByWhere(strCondition);
SD_Customer model = new SD_Customer();
if (list != null && list.Count > 0)
{
model = list[0];
}
return model;
}
//public List<SD_Customer> GetCustomerByWhere(string filter)
//{
// List<SD_Customer> list = instance.GetAll();
// return list;
//}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(SD_Customer model)
{
bool result = false;
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
return result;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SD_Customer model)
{
bool result = false;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return result;
}
/// <summary>
/// 获取所有的SD_Customer对象(即:一条记录
/// </summary>
public List <SD_Customer> GetAll()
{
List <SD_Customer> ret = new List <SD_Customer>();
string sql = "SELECT Cust_ID,Cust_Code,Cust_Name,Cust_Addr,Cust_Contact,Cust_COwner,Cust_CTel,Cust_CMobile,Cust_CMail,Cust_TypeCode,Cust_TypeName,Cust_Owner,Cust_Date,Stat,Cust_Type FROM SD_Customer where 1=1 AND ((Stat is null) or (Stat=0) ) order by Cust_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
SD_Customer sD_Customer = new SD_Customer();
if (dr["Cust_ID"] != DBNull.Value)
{
sD_Customer.Cust_ID = Convert.ToInt64(dr["Cust_ID"]);
}
if (dr["Cust_Code"] != DBNull.Value)
{
sD_Customer.Cust_Code = Convert.ToString(dr["Cust_Code"]);
}
if (dr["Cust_Name"] != DBNull.Value)
{
sD_Customer.Cust_Name = Convert.ToString(dr["Cust_Name"]);
}
if (dr["Cust_Addr"] != DBNull.Value)
{
sD_Customer.Cust_Addr = Convert.ToString(dr["Cust_Addr"]);
}
if (dr["Cust_Contact"] != DBNull.Value)
{
sD_Customer.Cust_Contact = Convert.ToString(dr["Cust_Contact"]);
}
if (dr["Cust_COwner"] != DBNull.Value)
{
sD_Customer.Cust_COwner = Convert.ToString(dr["Cust_COwner"]);
}
if (dr["Cust_CTel"] != DBNull.Value)
{
sD_Customer.Cust_CTel = Convert.ToString(dr["Cust_CTel"]);
}
if (dr["Cust_CMobile"] != DBNull.Value)
{
sD_Customer.Cust_CMobile = Convert.ToString(dr["Cust_CMobile"]);
}
if (dr["Cust_CMail"] != DBNull.Value)
{
sD_Customer.Cust_CMail = Convert.ToString(dr["Cust_CMail"]);
}
if (dr["Cust_TypeCode"] != DBNull.Value)
{
sD_Customer.Cust_TypeCode = Convert.ToString(dr["Cust_TypeCode"]);
}
if (dr["Cust_TypeName"] != DBNull.Value)
{
sD_Customer.Cust_TypeName = Convert.ToString(dr["Cust_TypeName"]);
}
if (dr["Cust_Owner"] != DBNull.Value)
{
sD_Customer.Cust_Owner = Convert.ToString(dr["Cust_Owner"]);
}
if (dr["Cust_Date"] != DBNull.Value)
{
sD_Customer.Cust_Date = Convert.ToDateTime(dr["Cust_Date"]);
}
if (dr["Stat"] != DBNull.Value)
{
sD_Customer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["Cust_Type"] != DBNull.Value)
{
sD_Customer.Cust_Type = Convert.ToString(dr["Cust_Type"]);
}
ret.Add(sD_Customer);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的SD_Customer对象集合
/// </summary>
public List <SD_Customer> GetListByWhere(string strCondition)
{
List <SD_Customer> ret = new List <SD_Customer>();
string sql = "SELECT Cust_ID,Cust_Code,Cust_Name,Cust_Addr,Cust_Contact,Cust_COwner,Cust_CTel,Cust_CMobile,Cust_CMail,Cust_TypeCode,Cust_TypeName,Cust_Owner,Cust_Date,Stat,Cust_Type FROM SD_Customer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY Cust_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
SD_Customer sD_Customer = new SD_Customer();
if (dr["Cust_ID"] != DBNull.Value)
{
sD_Customer.Cust_ID = Convert.ToInt64(dr["Cust_ID"]);
}
if (dr["Cust_Code"] != DBNull.Value)
{
sD_Customer.Cust_Code = Convert.ToString(dr["Cust_Code"]);
}
if (dr["Cust_Name"] != DBNull.Value)
{
sD_Customer.Cust_Name = Convert.ToString(dr["Cust_Name"]);
}
if (dr["Cust_Addr"] != DBNull.Value)
{
sD_Customer.Cust_Addr = Convert.ToString(dr["Cust_Addr"]);
}
if (dr["Cust_Contact"] != DBNull.Value)
{
sD_Customer.Cust_Contact = Convert.ToString(dr["Cust_Contact"]);
}
if (dr["Cust_COwner"] != DBNull.Value)
{
sD_Customer.Cust_COwner = Convert.ToString(dr["Cust_COwner"]);
}
if (dr["Cust_CTel"] != DBNull.Value)
{
sD_Customer.Cust_CTel = Convert.ToString(dr["Cust_CTel"]);
}
if (dr["Cust_CMobile"] != DBNull.Value)
{
sD_Customer.Cust_CMobile = Convert.ToString(dr["Cust_CMobile"]);
}
if (dr["Cust_CMail"] != DBNull.Value)
{
sD_Customer.Cust_CMail = Convert.ToString(dr["Cust_CMail"]);
}
if (dr["Cust_TypeCode"] != DBNull.Value)
{
sD_Customer.Cust_TypeCode = Convert.ToString(dr["Cust_TypeCode"]);
}
if (dr["Cust_TypeName"] != DBNull.Value)
{
sD_Customer.Cust_TypeName = Convert.ToString(dr["Cust_TypeName"]);
}
if (dr["Cust_Owner"] != DBNull.Value)
{
sD_Customer.Cust_Owner = Convert.ToString(dr["Cust_Owner"]);
}
if (dr["Cust_Date"] != DBNull.Value)
{
sD_Customer.Cust_Date = Convert.ToDateTime(dr["Cust_Date"]);
}
if (dr["Stat"] != DBNull.Value)
{
sD_Customer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["Cust_Type"] != DBNull.Value)
{
sD_Customer.Cust_Type = Convert.ToString(dr["Cust_Type"]);
}
ret.Add(sD_Customer);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的SD_Customer对象(即:一条记录
/// </summary>
public SD_Customer GetByKey(Int64 cust_ID)
{
SD_Customer sD_Customer = new SD_Customer();
string sql = "SELECT Cust_ID,Cust_Code,Cust_Name,Cust_Addr,Cust_Contact,Cust_COwner,Cust_CTel,Cust_CMobile,Cust_CMail,Cust_TypeCode,Cust_TypeName,Cust_Owner,Cust_Date,Stat,Cust_Type FROM SD_Customer WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Cust_ID=@Cust_ID ";
idb.AddParameter("@Cust_ID", cust_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["Cust_ID"] != DBNull.Value)
{
sD_Customer.Cust_ID = Convert.ToInt64(dr["Cust_ID"]);
}
if (dr["Cust_Code"] != DBNull.Value)
{
sD_Customer.Cust_Code = Convert.ToString(dr["Cust_Code"]);
}
if (dr["Cust_Name"] != DBNull.Value)
{
sD_Customer.Cust_Name = Convert.ToString(dr["Cust_Name"]);
}
if (dr["Cust_Addr"] != DBNull.Value)
{
sD_Customer.Cust_Addr = Convert.ToString(dr["Cust_Addr"]);
}
if (dr["Cust_Contact"] != DBNull.Value)
{
sD_Customer.Cust_Contact = Convert.ToString(dr["Cust_Contact"]);
}
if (dr["Cust_COwner"] != DBNull.Value)
{
sD_Customer.Cust_COwner = Convert.ToString(dr["Cust_COwner"]);
}
if (dr["Cust_CTel"] != DBNull.Value)
{
sD_Customer.Cust_CTel = Convert.ToString(dr["Cust_CTel"]);
}
if (dr["Cust_CMobile"] != DBNull.Value)
{
sD_Customer.Cust_CMobile = Convert.ToString(dr["Cust_CMobile"]);
}
if (dr["Cust_CMail"] != DBNull.Value)
{
sD_Customer.Cust_CMail = Convert.ToString(dr["Cust_CMail"]);
}
if (dr["Cust_TypeCode"] != DBNull.Value)
{
sD_Customer.Cust_TypeCode = Convert.ToString(dr["Cust_TypeCode"]);
}
if (dr["Cust_TypeName"] != DBNull.Value)
{
sD_Customer.Cust_TypeName = Convert.ToString(dr["Cust_TypeName"]);
}
if (dr["Cust_Owner"] != DBNull.Value)
{
sD_Customer.Cust_Owner = Convert.ToString(dr["Cust_Owner"]);
}
if (dr["Cust_Date"] != DBNull.Value)
{
sD_Customer.Cust_Date = Convert.ToDateTime(dr["Cust_Date"]);
}
if (dr["Stat"] != DBNull.Value)
{
sD_Customer.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["Cust_Type"] != DBNull.Value)
{
sD_Customer.Cust_Type = Convert.ToString(dr["Cust_Type"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(sD_Customer);
}
/// <summary>
/// 更新SD_Customer对象(即:一条记录
/// </summary>
public int Update(SD_Customer sD_Customer)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE SD_Customer SET ");
if (sD_Customer.Cust_Code_IsChanged)
{
sbParameter.Append("Cust_Code=@Cust_Code, ");
}
if (sD_Customer.Cust_Name_IsChanged)
{
sbParameter.Append("Cust_Name=@Cust_Name, ");
}
if (sD_Customer.Cust_Addr_IsChanged)
{
sbParameter.Append("Cust_Addr=@Cust_Addr, ");
}
if (sD_Customer.Cust_Contact_IsChanged)
{
sbParameter.Append("Cust_Contact=@Cust_Contact, ");
}
if (sD_Customer.Cust_COwner_IsChanged)
{
sbParameter.Append("Cust_COwner=@Cust_COwner, ");
}
if (sD_Customer.Cust_CTel_IsChanged)
{
sbParameter.Append("Cust_CTel=@Cust_CTel, ");
}
if (sD_Customer.Cust_CMobile_IsChanged)
{
sbParameter.Append("Cust_CMobile=@Cust_CMobile, ");
}
if (sD_Customer.Cust_CMail_IsChanged)
{
sbParameter.Append("Cust_CMail=@Cust_CMail, ");
}
if (sD_Customer.Cust_TypeCode_IsChanged)
{
sbParameter.Append("Cust_TypeCode=@Cust_TypeCode, ");
}
if (sD_Customer.Cust_TypeName_IsChanged)
{
sbParameter.Append("Cust_TypeName=@Cust_TypeName, ");
}
if (sD_Customer.Cust_Owner_IsChanged)
{
sbParameter.Append("Cust_Owner=@Cust_Owner, ");
}
if (sD_Customer.Cust_Date_IsChanged)
{
sbParameter.Append("Cust_Date=@Cust_Date, ");
}
if (sD_Customer.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (sD_Customer.Cust_Type_IsChanged)
{
sbParameter.Append("Cust_Type=@Cust_Type ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Cust_ID=@Cust_ID; ");
string sql = sb.ToString();
if (sD_Customer.Cust_Code_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Code))
{
idb.AddParameter("@Cust_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Code", sD_Customer.Cust_Code);
}
}
if (sD_Customer.Cust_Name_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Name))
{
idb.AddParameter("@Cust_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Name", sD_Customer.Cust_Name);
}
}
if (sD_Customer.Cust_Addr_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Addr))
{
idb.AddParameter("@Cust_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Addr", sD_Customer.Cust_Addr);
}
}
if (sD_Customer.Cust_Contact_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Contact))
{
idb.AddParameter("@Cust_Contact", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Contact", sD_Customer.Cust_Contact);
}
}
if (sD_Customer.Cust_COwner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_COwner))
{
idb.AddParameter("@Cust_COwner", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_COwner", sD_Customer.Cust_COwner);
}
}
if (sD_Customer.Cust_CTel_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_CTel))
{
idb.AddParameter("@Cust_CTel", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CTel", sD_Customer.Cust_CTel);
}
}
if (sD_Customer.Cust_CMobile_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_CMobile))
{
idb.AddParameter("@Cust_CMobile", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CMobile", sD_Customer.Cust_CMobile);
}
}
if (sD_Customer.Cust_CMail_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_CMail))
{
idb.AddParameter("@Cust_CMail", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CMail", sD_Customer.Cust_CMail);
}
}
if (sD_Customer.Cust_TypeCode_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_TypeCode))
{
idb.AddParameter("@Cust_TypeCode", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_TypeCode", sD_Customer.Cust_TypeCode);
}
}
if (sD_Customer.Cust_TypeName_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_TypeName))
{
idb.AddParameter("@Cust_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_TypeName", sD_Customer.Cust_TypeName);
}
}
if (sD_Customer.Cust_Owner_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Owner))
{
idb.AddParameter("@Cust_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Owner", sD_Customer.Cust_Owner);
}
}
if (sD_Customer.Cust_Date_IsChanged)
{
if (sD_Customer.Cust_Date == DateTime.MinValue)
{
idb.AddParameter("@Cust_Date", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Date", sD_Customer.Cust_Date);
}
}
if (sD_Customer.Stat_IsChanged)
{
if (sD_Customer.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sD_Customer.Stat);
}
}
if (sD_Customer.Cust_Type_IsChanged)
{
if (string.IsNullOrEmpty(sD_Customer.Cust_Type))
{
idb.AddParameter("@Cust_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Type", sD_Customer.Cust_Type);
}
}
idb.AddParameter("@Cust_ID", sD_Customer.Cust_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加SD_Customer对象(即:一条记录)
/// </summary>
public int Add(SD_Customer sD_Customer)
{
string sql = "INSERT INTO SD_Customer (Cust_Code,Cust_Name,Cust_Addr,Cust_Contact,Cust_COwner,Cust_CTel,Cust_CMobile,Cust_CMail,Cust_TypeCode,Cust_TypeName,Cust_Owner,Cust_Date,Stat,Cust_Type) VALUES (@Cust_Code,@Cust_Name,@Cust_Addr,@Cust_Contact,@Cust_COwner,@Cust_CTel,@Cust_CMobile,@Cust_CMail,@Cust_TypeCode,@Cust_TypeName,@Cust_Owner,@Cust_Date,@Stat,@Cust_Type)";
if (string.IsNullOrEmpty(sD_Customer.Cust_Code))
{
idb.AddParameter("@Cust_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Code", sD_Customer.Cust_Code);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_Name))
{
idb.AddParameter("@Cust_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Name", sD_Customer.Cust_Name);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_Addr))
{
idb.AddParameter("@Cust_Addr", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Addr", sD_Customer.Cust_Addr);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_Contact))
{
idb.AddParameter("@Cust_Contact", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Contact", sD_Customer.Cust_Contact);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_COwner))
{
idb.AddParameter("@Cust_COwner", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_COwner", sD_Customer.Cust_COwner);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_CTel))
{
idb.AddParameter("@Cust_CTel", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CTel", sD_Customer.Cust_CTel);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_CMobile))
{
idb.AddParameter("@Cust_CMobile", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CMobile", sD_Customer.Cust_CMobile);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_CMail))
{
idb.AddParameter("@Cust_CMail", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_CMail", sD_Customer.Cust_CMail);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_TypeCode))
{
idb.AddParameter("@Cust_TypeCode", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_TypeCode", sD_Customer.Cust_TypeCode);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_TypeName))
{
idb.AddParameter("@Cust_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_TypeName", sD_Customer.Cust_TypeName);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_Owner))
{
idb.AddParameter("@Cust_Owner", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Owner", sD_Customer.Cust_Owner);
}
if (sD_Customer.Cust_Date == DateTime.MinValue)
{
idb.AddParameter("@Cust_Date", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Date", sD_Customer.Cust_Date);
}
if (sD_Customer.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sD_Customer.Stat);
}
if (string.IsNullOrEmpty(sD_Customer.Cust_Type))
{
idb.AddParameter("@Cust_Type", DBNull.Value);
}
else
{
idb.AddParameter("@Cust_Type", sD_Customer.Cust_Type);
}
return(idb.ExeCmd(sql));
}
