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