public int Add(Hi.Model.BD_Company model, System.Data.SqlClient.SqlTransaction Tran)
{
return(dal.Add(model, Tran));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_Company model, System.Data.SqlClient.SqlTransaction Tran)
{
return(dal.Update(model, Tran));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.BD_Company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BD_Company](");
strSql.Append("[OrgID],[SalesManID],[IndID],[CompCode],[CompName],[SortIndex],[ShortName],[Tel],[Legal],[Identitys],[LegalTel],[Zip],[ManageInfo],[Fax],[Codes],[Trade],[Principal],[Phone],[Licence],[Account],[OrganizationCode],[CompAddr],[Address],[CompLogo],[ShopLogo],[BrandInfo],[CompInfo],[Remark],[IsEnabled],[FirstBanerImg],[HotShow],[FirstShow],[CustomCompinfo],[CustomAddress],[FinanceCode],[FinanceName],[CreateUserID],[CreateDate],[AuditUser],[AuditDate],[ts],[modifyuser],[Attachment],[Erptype],[CompNewLogo],[QQ],[creditCode])");
strSql.Append(" values (");
strSql.Append("@OrgID,@SalesManID,@IndID,@CompCode,@CompName,@SortIndex,@ShortName,@Tel,@Legal,@Identitys,@LegalTel,@Zip,@ManageInfo,@Fax,@Codes,@Trade,@Principal,@Phone,@Licence,@Account,@OrganizationCode,@CompAddr,@Address,@CompLogo,@ShopLogo,@BrandInfo,@CompInfo,@Remark,@IsEnabled,@FirstBanerImg,@HotShow,@FirstShow,@CustomCompinfo,@CustomAddress,@FinanceCode,@FinanceName,@CreateUserID,@CreateDate,@AuditUser,@AuditDate,@ts,@modifyuser,@Attachment,@Erptype,@CompNewLogo,@QQ,@creditCode)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@OrgID", SqlDbType.Int),
new SqlParameter("@SalesManID", SqlDbType.Int),
new SqlParameter("@IndID", SqlDbType.Int),
new SqlParameter("@CompCode", SqlDbType.VarChar, 50),
new SqlParameter("@CompName", SqlDbType.VarChar, 50),
new SqlParameter("@SortIndex", SqlDbType.VarChar, 50),
new SqlParameter("@ShortName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Legal", SqlDbType.VarChar, 50),
new SqlParameter("@Identitys", SqlDbType.VarChar, 50),
new SqlParameter("@LegalTel", SqlDbType.VarChar, 50),
new SqlParameter("@Zip", SqlDbType.VarChar, 50),
new SqlParameter("@ManageInfo", SqlDbType.VarChar, 500),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Codes", SqlDbType.VarChar, 50),
new SqlParameter("@Trade", SqlDbType.VarChar, 50),
new SqlParameter("@Principal", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@Licence", SqlDbType.VarChar, 50),
new SqlParameter("@Account", SqlDbType.VarChar, 50),
new SqlParameter("@OrganizationCode", SqlDbType.VarChar, 50),
new SqlParameter("@CompAddr", SqlDbType.VarChar, 200),
new SqlParameter("@Address", SqlDbType.VarChar, 200),
new SqlParameter("@CompLogo", SqlDbType.VarChar, 200),
new SqlParameter("@ShopLogo", SqlDbType.VarChar, 200),
new SqlParameter("@BrandInfo", SqlDbType.VarChar, 2000),
new SqlParameter("@CompInfo", SqlDbType.VarChar, 4000),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@FirstBanerImg", SqlDbType.VarChar, 200),
new SqlParameter("@HotShow", SqlDbType.Int),
new SqlParameter("@FirstShow", SqlDbType.Int),
new SqlParameter("@CustomCompinfo", SqlDbType.Text),
new SqlParameter("@CustomAddress", SqlDbType.VarChar, 8000),
new SqlParameter("@FinanceCode", SqlDbType.VarChar, 200),
new SqlParameter("@FinanceName", SqlDbType.VarChar, 200),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@AuditUser", SqlDbType.VarChar, 50),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@Attachment", SqlDbType.VarChar, 4000),
new SqlParameter("@Erptype", SqlDbType.Int),
new SqlParameter("@CompNewLogo", SqlDbType.VarChar, 128),
new SqlParameter("@QQ", SqlDbType.VarChar, 20),
new SqlParameter("@creditCode", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.OrgID;
parameters[1].Value = model.SalesManID;
parameters[2].Value = model.IndID;
if (model.CompCode != null)
{
parameters[3].Value = model.CompCode;
}
else
{
parameters[3].Value = DBNull.Value;
}
parameters[4].Value = model.CompName;
if (model.SortIndex != null)
{
parameters[5].Value = model.SortIndex;
}
else
{
parameters[5].Value = DBNull.Value;
}
if (model.ShortName != null)
{
parameters[6].Value = model.ShortName;
}
else
{
parameters[6].Value = DBNull.Value;
}
if (model.Tel != null)
{
parameters[7].Value = model.Tel;
}
else
{
parameters[7].Value = DBNull.Value;
}
if (model.Legal != null)
{
parameters[8].Value = model.Legal;
}
else
{
parameters[8].Value = DBNull.Value;
}
if (model.Identitys != null)
{
parameters[9].Value = model.Identitys;
}
else
{
parameters[9].Value = DBNull.Value;
}
if (model.LegalTel != null)
{
parameters[10].Value = model.LegalTel;
}
else
{
parameters[10].Value = DBNull.Value;
}
if (model.Zip != null)
{
parameters[11].Value = model.Zip;
}
else
{
parameters[11].Value = DBNull.Value;
}
if (model.ManageInfo != null)
{
parameters[12].Value = model.ManageInfo;
}
else
{
parameters[12].Value = DBNull.Value;
}
if (model.Fax != null)
{
parameters[13].Value = model.Fax;
}
else
{
parameters[13].Value = DBNull.Value;
}
if (model.Codes != null)
{
parameters[14].Value = model.Codes;
}
else
{
parameters[14].Value = DBNull.Value;
}
if (model.Trade != null)
{
parameters[15].Value = model.Trade;
}
else
{
parameters[15].Value = DBNull.Value;
}
if (model.Principal != null)
{
parameters[16].Value = model.Principal;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.Phone != null)
{
parameters[17].Value = model.Phone;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.Licence != null)
{
parameters[18].Value = model.Licence;
}
else
{
parameters[18].Value = DBNull.Value;
}
if (model.Account != null)
{
parameters[19].Value = model.Account;
}
else
{
parameters[19].Value = DBNull.Value;
}
if (model.OrganizationCode != null)
{
parameters[20].Value = model.OrganizationCode;
}
else
{
parameters[20].Value = DBNull.Value;
}
if (model.CompAddr != null)
{
parameters[21].Value = model.CompAddr;
}
else
{
parameters[21].Value = DBNull.Value;
}
if (model.Address != null)
{
parameters[22].Value = model.Address;
}
else
{
parameters[22].Value = DBNull.Value;
}
if (model.CompLogo != null)
{
parameters[23].Value = model.CompLogo;
}
else
{
parameters[23].Value = DBNull.Value;
}
if (model.ShopLogo != null)
{
parameters[24].Value = model.ShopLogo;
}
else
{
parameters[24].Value = DBNull.Value;
}
if (model.BrandInfo != null)
{
parameters[25].Value = model.BrandInfo;
}
else
{
parameters[25].Value = DBNull.Value;
}
if (model.CompInfo != null)
{
parameters[26].Value = model.CompInfo;
}
else
{
parameters[26].Value = DBNull.Value;
}
if (model.Remark != null)
{
parameters[27].Value = model.Remark;
}
else
{
parameters[27].Value = DBNull.Value;
}
parameters[28].Value = model.IsEnabled;
if (model.FirstBanerImg != null)
{
parameters[29].Value = model.FirstBanerImg;
}
else
{
parameters[29].Value = DBNull.Value;
}
parameters[30].Value = model.HotShow;
parameters[31].Value = model.FirstShow;
if (model.CustomCompinfo != null)
{
parameters[32].Value = model.CustomCompinfo;
}
else
{
parameters[32].Value = DBNull.Value;
}
if (model.CustomAddress != null)
{
parameters[33].Value = model.CustomAddress;
}
else
{
parameters[33].Value = DBNull.Value;
}
if (model.FinanceCode != null)
{
parameters[34].Value = model.FinanceCode;
}
else
{
parameters[34].Value = DBNull.Value;
}
if (model.FinanceName != null)
{
parameters[35].Value = model.FinanceName;
}
else
{
parameters[35].Value = DBNull.Value;
}
parameters[36].Value = model.CreateUserID;
if (model.CreateDate != DateTime.MinValue)
{
parameters[37].Value = model.CreateDate;
}
else
{
parameters[37].Value = DBNull.Value;
}
if (model.AuditUser != null)
{
parameters[38].Value = model.AuditUser;
}
else
{
parameters[38].Value = DBNull.Value;
}
if (model.AuditDate != DateTime.MinValue)
{
parameters[39].Value = model.AuditDate;
}
else
{
parameters[39].Value = DBNull.Value;
}
parameters[40].Value = model.ts;
parameters[41].Value = model.modifyuser;
if (model.Attachment != null)
{
parameters[42].Value = model.Attachment;
}
else
{
parameters[42].Value = DBNull.Value;
}
parameters[43].Value = model.Erptype;
if (model.CompNewLogo != null)
{
parameters[44].Value = model.CompNewLogo;
}
else
{
parameters[44].Value = DBNull.Value;
}
if (model.QQ != null)
{
parameters[45].Value = model.QQ;
}
else
{
parameters[45].Value = DBNull.Value;
}
if (model.creditCode != null)
{
parameters[46].Value = model.creditCode;
}
else
{
parameters[46].Value = DBNull.Value;
}
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_Company model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [BD_Company] set ");
strSql.Append("[OrgID]=@OrgID,");
strSql.Append("[SalesManID]=@SalesManID,");
strSql.Append("[IndID]=@IndID,");
strSql.Append("[CompCode]=@CompCode,");
strSql.Append("[CompName]=@CompName,");
strSql.Append("[SortIndex]=@SortIndex,");
strSql.Append("[ShortName]=@ShortName,");
strSql.Append("[Tel]=@Tel,");
strSql.Append("[Legal]=@Legal,");
strSql.Append("[Identitys]=@Identitys,");
strSql.Append("[LegalTel]=@LegalTel,");
strSql.Append("[Zip]=@Zip,");
strSql.Append("[ManageInfo]=@ManageInfo,");
strSql.Append("[Fax]=@Fax,");
strSql.Append("[Codes]=@Codes,");
strSql.Append("[Trade]=@Trade,");
strSql.Append("[Principal]=@Principal,");
strSql.Append("[Phone]=@Phone,");
strSql.Append("[Licence]=@Licence,");
strSql.Append("[Account]=@Account,");
strSql.Append("[OrganizationCode]=@OrganizationCode,");
strSql.Append("[CompAddr]=@CompAddr,");
strSql.Append("[Address]=@Address,");
strSql.Append("[CompLogo]=@CompLogo,");
strSql.Append("[ShopLogo]=@ShopLogo,");
strSql.Append("[BrandInfo]=@BrandInfo,");
strSql.Append("[CompInfo]=@CompInfo,");
strSql.Append("[Remark]=@Remark,");
strSql.Append("[IsEnabled]=@IsEnabled,");
strSql.Append("[FirstBanerImg]=@FirstBanerImg,");
strSql.Append("[HotShow]=@HotShow,");
strSql.Append("[FirstShow]=@FirstShow,");
strSql.Append("[CustomCompinfo]=@CustomCompinfo,");
strSql.Append("[CustomAddress]=@CustomAddress,");
strSql.Append("[FinanceCode]=@FinanceCode,");
strSql.Append("[FinanceName]=@FinanceName,");
strSql.Append("[CreateUserID]=@CreateUserID,");
strSql.Append("[CreateDate]=@CreateDate,");
strSql.Append("[AuditState]=@AuditState,");
strSql.Append("[AuditUser]=@AuditUser,");
strSql.Append("[AuditDate]=@AuditDate,");
strSql.Append("[ts]=@ts,");
strSql.Append("[dr]=@dr,");
strSql.Append("[modifyuser]=@modifyuser,");
strSql.Append("[Attachment]=@Attachment,");
strSql.Append("[Erptype]=@Erptype,");
strSql.Append("[CompNewLogo]=@CompNewLogo,");
strSql.Append("[QQ]=@QQ,");
strSql.Append("[EnabledStartDate]=@EnabledStartDate,");
strSql.Append("[EnabledEndDate]=@EnabledEndDate,");
strSql.Append("[Capital]=@Capital,");
strSql.Append("[CompType]=@CompType,");
strSql.Append("[IsZXAudit]=@IsZXAudit,");
strSql.Append("[ZXAuditDate]=@ZXAuditDate,");
strSql.Append("[ZXAuditUser]=@ZXAuditUser,");
strSql.Append("[IsOrgZX]=@IsOrgZX,");
strSql.Append("[OrgZXDate]=@OrgZXDate,");
strSql.Append("[creditCode]=@creditCode");
strSql.Append(" where [ID]=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@OrgID", SqlDbType.Int),
new SqlParameter("@SalesManID", SqlDbType.Int),
new SqlParameter("@IndID", SqlDbType.Int),
new SqlParameter("@CompCode", SqlDbType.VarChar, 50),
new SqlParameter("@CompName", SqlDbType.VarChar, 50),
new SqlParameter("@SortIndex", SqlDbType.VarChar, 50),
new SqlParameter("@ShortName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@Legal", SqlDbType.VarChar, 50),
new SqlParameter("@Identitys", SqlDbType.VarChar, 50),
new SqlParameter("@LegalTel", SqlDbType.VarChar, 50),
new SqlParameter("@Zip", SqlDbType.VarChar, 50),
new SqlParameter("@ManageInfo", SqlDbType.VarChar, 500),
new SqlParameter("@Fax", SqlDbType.VarChar, 50),
new SqlParameter("@Codes", SqlDbType.VarChar, 50),
new SqlParameter("@Trade", SqlDbType.VarChar, 50),
new SqlParameter("@Principal", SqlDbType.VarChar, 50),
new SqlParameter("@Phone", SqlDbType.VarChar, 50),
new SqlParameter("@Licence", SqlDbType.VarChar, 50),
new SqlParameter("@Account", SqlDbType.VarChar, 50),
new SqlParameter("@OrganizationCode", SqlDbType.VarChar, 50),
new SqlParameter("@CompAddr", SqlDbType.VarChar, 200),
new SqlParameter("@Address", SqlDbType.VarChar, 200),
new SqlParameter("@CompLogo", SqlDbType.VarChar, 200),
new SqlParameter("@ShopLogo", SqlDbType.VarChar, 200),
new SqlParameter("@BrandInfo", SqlDbType.VarChar, 2000),
new SqlParameter("@CompInfo", SqlDbType.VarChar, 4000),
new SqlParameter("@Remark", SqlDbType.VarChar, 2000),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@FirstBanerImg", SqlDbType.VarChar, 200),
new SqlParameter("@HotShow", SqlDbType.Int),
new SqlParameter("@FirstShow", SqlDbType.Int),
new SqlParameter("@CustomCompinfo", SqlDbType.Text),
new SqlParameter("@CustomAddress", SqlDbType.VarChar, 8000),
new SqlParameter("@FinanceCode", SqlDbType.VarChar, 200),
new SqlParameter("@FinanceName", SqlDbType.VarChar, 200),
new SqlParameter("@CreateUserID", SqlDbType.Int),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@AuditState", SqlDbType.Int),
new SqlParameter("@AuditUser", SqlDbType.VarChar, 50),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@Attachment", SqlDbType.VarChar, 4000),
new SqlParameter("@Erptype", SqlDbType.Int),
new SqlParameter("@CompNewLogo", SqlDbType.VarChar, 20),
new SqlParameter("@QQ", SqlDbType.VarChar, 128),
new SqlParameter("@EnabledStartDate", SqlDbType.DateTime),
new SqlParameter("@EnabledEndDate", SqlDbType.DateTime),
new SqlParameter("@Capital", SqlDbType.VarChar, 50),
new SqlParameter("@CompType", SqlDbType.Int),
new SqlParameter("@IsZXAudit", SqlDbType.Int),
new SqlParameter("@ZXAuditDate", SqlDbType.DateTime),
new SqlParameter("@ZXAuditUser", SqlDbType.Int),
new SqlParameter("@IsOrgZX", SqlDbType.Int),
new SqlParameter("@OrgZXDate", SqlDbType.DateTime),
new SqlParameter("@creditCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.OrgID;
parameters[2].Value = model.SalesManID;
parameters[3].Value = model.IndID;
if (model.CompCode != null)
{
parameters[4].Value = model.CompCode;
}
else
{
parameters[4].Value = DBNull.Value;
}
parameters[5].Value = model.CompName;
if (model.SortIndex != null)
{
parameters[6].Value = model.SortIndex;
}
else
{
parameters[6].Value = DBNull.Value;
}
if (model.ShortName != null)
{
parameters[7].Value = model.ShortName;
}
else
{
parameters[7].Value = DBNull.Value;
}
if (model.Tel != null)
{
parameters[8].Value = model.Tel;
}
else
{
parameters[8].Value = DBNull.Value;
}
if (model.Legal != null)
{
parameters[9].Value = model.Legal;
}
else
{
parameters[9].Value = DBNull.Value;
}
if (model.Identitys != null)
{
parameters[10].Value = model.Identitys;
}
else
{
parameters[10].Value = DBNull.Value;
}
if (model.LegalTel != null)
{
parameters[11].Value = model.LegalTel;
}
else
{
parameters[11].Value = DBNull.Value;
}
if (model.Zip != null)
{
parameters[12].Value = model.Zip;
}
else
{
parameters[12].Value = DBNull.Value;
}
if (model.ManageInfo != null)
{
parameters[13].Value = model.ManageInfo;
}
else
{
parameters[13].Value = DBNull.Value;
}
if (model.Fax != null)
{
parameters[14].Value = model.Fax;
}
else
{
parameters[14].Value = DBNull.Value;
}
if (model.Codes != null)
{
parameters[15].Value = model.Codes;
}
else
{
parameters[15].Value = DBNull.Value;
}
if (model.Trade != null)
{
parameters[16].Value = model.Trade;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.Principal != null)
{
parameters[17].Value = model.Principal;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.Phone != null)
{
parameters[18].Value = model.Phone;
}
else
{
parameters[18].Value = DBNull.Value;
}
if (model.Licence != null)
{
parameters[19].Value = model.Licence;
}
else
{
parameters[19].Value = DBNull.Value;
}
if (model.Account != null)
{
parameters[20].Value = model.Account;
}
else
{
parameters[20].Value = DBNull.Value;
}
if (model.OrganizationCode != null)
{
parameters[21].Value = model.OrganizationCode;
}
else
{
parameters[21].Value = DBNull.Value;
}
if (model.CompAddr != null)
{
parameters[22].Value = model.CompAddr;
}
else
{
parameters[22].Value = DBNull.Value;
}
if (model.Address != null)
{
parameters[23].Value = model.Address;
}
else
{
parameters[23].Value = DBNull.Value;
}
if (model.CompLogo != null)
{
parameters[24].Value = model.CompLogo;
}
else
{
parameters[24].Value = DBNull.Value;
}
if (model.ShopLogo != null)
{
parameters[25].Value = model.ShopLogo;
}
else
{
parameters[25].Value = DBNull.Value;
}
if (model.BrandInfo != null)
{
parameters[26].Value = model.BrandInfo;
}
else
{
parameters[26].Value = DBNull.Value;
}
if (model.CompInfo != null)
{
parameters[27].Value = model.CompInfo;
}
else
{
parameters[27].Value = DBNull.Value;
}
if (model.Remark != null)
{
parameters[28].Value = model.Remark;
}
else
{
parameters[28].Value = DBNull.Value;
}
parameters[29].Value = model.IsEnabled;
if (model.FirstBanerImg != null)
{
parameters[30].Value = model.FirstBanerImg;
}
else
{
parameters[30].Value = DBNull.Value;
}
parameters[31].Value = model.HotShow;
parameters[32].Value = model.FirstShow;
if (model.CustomCompinfo != null)
{
parameters[33].Value = model.CustomCompinfo;
}
else
{
parameters[33].Value = DBNull.Value;
}
if (model.CustomAddress != null)
{
parameters[34].Value = model.CustomAddress;
}
else
{
parameters[34].Value = DBNull.Value;
}
if (model.FinanceCode != null)
{
parameters[35].Value = model.FinanceCode;
}
else
{
parameters[35].Value = DBNull.Value;
}
if (model.FinanceName != null)
{
parameters[36].Value = model.FinanceName;
}
else
{
parameters[36].Value = DBNull.Value;
}
parameters[37].Value = model.CreateUserID;
if (model.CreateDate != DateTime.MinValue)
{
parameters[38].Value = model.CreateDate;
}
else
{
parameters[38].Value = DBNull.Value;
}
parameters[39].Value = model.AuditState;
if (model.AuditUser != null)
{
parameters[40].Value = model.AuditUser;
}
else
{
parameters[40].Value = DBNull.Value;
}
if (model.AuditDate != DateTime.MinValue)
{
parameters[41].Value = model.AuditDate;
}
else
{
parameters[41].Value = DBNull.Value;
}
parameters[42].Value = model.ts;
parameters[43].Value = model.dr;
parameters[44].Value = model.modifyuser;
if (model.Attachment != null)
{
parameters[45].Value = model.Attachment;
}
else
{
parameters[45].Value = DBNull.Value;
}
parameters[46].Value = model.Erptype;
if (model.CompNewLogo != null)
{
parameters[47].Value = model.CompNewLogo;
}
else
{
parameters[47].Value = DBNull.Value;
}
if (model.QQ != null)
{
parameters[48].Value = model.QQ;
}
else
{
parameters[48].Value = DBNull.Value;
}
if (model.EnabledStartDate != DateTime.MinValue)
{
parameters[49].Value = model.EnabledStartDate;
}
else
{
parameters[49].Value = DBNull.Value;
}
if (model.EnabledEndDate != DateTime.MinValue)
{
parameters[50].Value = model.EnabledEndDate;
}
else
{
parameters[50].Value = DBNull.Value;
}
if (model.Capital != null)
{
parameters[51].Value = model.Capital;
}
else
{
parameters[51].Value = DBNull.Value;
}
parameters[52].Value = model.CompType;
parameters[53].Value = model.IsZXAudit;
if (model.ZXAuditDate != DateTime.MinValue)
{
parameters[54].Value = model.ZXAuditDate;
}
else
{
parameters[54].Value = DBNull.Value;
}
parameters[55].Value = model.Zxaudituser;
parameters[56].Value = model.Isorgzx;
if (model.Orgzxdate != DateTime.MinValue)
{
parameters[57].Value = model.Orgzxdate;
}
else
{
parameters[57].Value = DBNull.Value;
}
if (model.creditCode != null)
{
parameters[58].Value = model.creditCode;
}
else
{
parameters[58].Value = DBNull.Value;
}
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.BD_Company GetModel(DataRow r)
{
Hi.Model.BD_Company model = new Hi.Model.BD_Company();
model.ID = SqlHelper.GetInt(r["ID"]);
model.OrgID = SqlHelper.GetInt(r["OrgID"]);
model.SalesManID = SqlHelper.GetInt(r["SalesManID"]);
model.IndID = SqlHelper.GetInt(r["IndID"]);
model.CompCode = SqlHelper.GetString(r["CompCode"]);
model.CompName = SqlHelper.GetString(r["CompName"]);
model.SortIndex = SqlHelper.GetString(r["SortIndex"]);
model.ShortName = SqlHelper.GetString(r["ShortName"]);
model.Tel = SqlHelper.GetString(r["Tel"]);
model.Legal = SqlHelper.GetString(r["Legal"]);
model.Identitys = SqlHelper.GetString(r["Identitys"]);
model.LegalTel = SqlHelper.GetString(r["LegalTel"]);
model.Zip = SqlHelper.GetString(r["Zip"]);
model.ManageInfo = SqlHelper.GetString(r["ManageInfo"]);
model.Fax = SqlHelper.GetString(r["Fax"]);
model.Codes = SqlHelper.GetString(r["Codes"]);
model.Trade = SqlHelper.GetString(r["Trade"]);
model.Principal = SqlHelper.GetString(r["Principal"]);
model.Phone = SqlHelper.GetString(r["Phone"]);
model.Licence = SqlHelper.GetString(r["Licence"]);
model.Account = SqlHelper.GetString(r["Account"]);
model.OrganizationCode = SqlHelper.GetString(r["OrganizationCode"]);
model.CompAddr = SqlHelper.GetString(r["CompAddr"]);
model.Address = SqlHelper.GetString(r["Address"]);
model.CompLogo = SqlHelper.GetString(r["CompLogo"]);
model.ShopLogo = SqlHelper.GetString(r["ShopLogo"]);
model.BrandInfo = SqlHelper.GetString(r["BrandInfo"]);
model.CompInfo = SqlHelper.GetString(r["CompInfo"]);
model.Remark = SqlHelper.GetString(r["Remark"]);
model.IsEnabled = SqlHelper.GetInt(r["IsEnabled"]);
model.FirstBanerImg = SqlHelper.GetString(r["FirstBanerImg"]);
model.HotShow = SqlHelper.GetInt(r["HotShow"]);
model.FirstShow = SqlHelper.GetInt(r["FirstShow"]);
model.CustomCompinfo = SqlHelper.GetString(r["CustomCompinfo"]);
model.CustomAddress = SqlHelper.GetString(r["CustomAddress"]);
model.FinanceCode = SqlHelper.GetString(r["FinanceCode"]);
model.FinanceName = SqlHelper.GetString(r["FinanceName"]);
model.CreateUserID = SqlHelper.GetInt(r["CreateUserID"]);
model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]);
model.AuditState = SqlHelper.GetInt(r["AuditState"]);
model.AuditUser = SqlHelper.GetString(r["AuditUser"]);
model.AuditDate = SqlHelper.GetDateTime(r["AuditDate"]);
model.ts = SqlHelper.GetDateTime(r["ts"]);
model.dr = SqlHelper.GetInt(r["dr"]);
model.modifyuser = SqlHelper.GetInt(r["modifyuser"]);
model.Attachment = SqlHelper.GetString(r["Attachment"]);
model.Erptype = SqlHelper.GetInt(r["Erptype"]);
model.CompNewLogo = SqlHelper.GetString(r["CompNewLogo"]);
model.QQ = SqlHelper.GetString(r["QQ"]);
model.EnabledStartDate = SqlHelper.GetDateTime(r["EnabledStartDate"]);
model.EnabledEndDate = SqlHelper.GetDateTime(r["EnabledEndDate"]);
model.Capital = SqlHelper.GetString(r["Capital"]);
model.CompType = SqlHelper.GetInt(r["CompType"]);
model.IsZXAudit = SqlHelper.GetInt(r["IsZXAudit"]);
model.ZXAuditDate = SqlHelper.GetDateTime(r["ZXAuditDate"]);
model.Zxaudituser = SqlHelper.GetInt(r["ZXAuditUser"]);
model.Isorgzx = SqlHelper.GetInt(r["IsOrgZX"]);
model.Orgzxdate = SqlHelper.GetDateTime(r["OrgZXDate"]);
model.creditCode = SqlHelper.GetString(r["creditCode"]);
return(model);
}
