/// <summary>
/// 更新JD_Customer_Mng对象
/// 编写人：ywk
/// 编写日期：2018/9/5 星期三
/// </summary>
public void Update(JD_Customer_Mng model)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("UPDATE JD_Customer_Mng SET TaskID = @m_TaskID,RequestUser = @m_RequestUser,RequestDept = @m_RequestDept,RequestDate = @m_RequestDate,SNumber = @m_SNumber,FNumber = @m_FNumber,FSaleModeName = @m_FSaleModeName,FSaleModeID = @m_FSaleModeID,FSaleModeNumber = @m_FSaleModeNumber,FSaleTypeName = @m_FSaleTypeName,FSaleTypeID = @m_FSaleTypeID,FSaleTypeNumber = @m_FSaleTypeNumber,FCyName = @m_FCyName,FCyID = @m_FCyID,FCyNumber = @m_FCyNumber,FAPAccountIDName = @m_FAPAccountIDName,FAPAccountIDNumber = @m_FAPAccountIDNumber,FPreAcctIDName = @m_FPreAcctIDName,FPreAcctIDNumber = @m_FPreAcctIDNumber,FOtherAPAcctIDName = @m_FOtherAPAcctIDName,FOtherAPAcctIDNumber = @m_FOtherAPAcctIDNumber,FPayTaxAcctIDName = @m_FPayTaxAcctIDName,FPayTaxAcctIDNumber = @m_FPayTaxAcctIDNumber,FemployeeName = @m_FemployeeName,FemployeeNumber = @m_FemployeeNumber,FPayConditionName = @m_FPayConditionName,FPayConditionNumber = @m_FPayConditionNumber,FSetIDName = @m_FSetIDName,FSetIDNumber = @m_FSetIDNumber,CustomerName = @m_CustomerName,CustomerNameEN = @m_CustomerNameEN,CompanyAddress = @m_CompanyAddress,Headquarter = @m_Headquarter,CompanyContact = @m_CompanyContact,CustomTel = @m_CustomTel,CustomFax = @m_CustomFax,CustomEmail = @m_CustomEmail,BankAccount = @m_BankAccount,BankName = @m_BankName,BankAddress = @m_BankAddress,BankAccountNo = @m_BankAccountNo,VATNo = @m_VATNo,SwiftCode = @m_SwiftCode,ABANumber = @m_ABANumber,IBANumber = @m_IBANumber,PayTerms = @m_PayTerms,PayTermsCode = @m_PayTermsCode,PayMethod = @m_PayMethod,PayMethodCode = @m_PayMethodCode,CreditLimit = @m_CreditLimit,Currency = @m_Currency,CurrencyCode = @m_CurrencyCode,FinanceContacter = @m_FinanceContacter,PayTel = @m_PayTel,PayFax = @m_PayFax,PayEmail = @m_PayEmail,DeliveryEXW = @m_DeliveryEXW,DeliveryDDP = @m_DeliveryDDP,DeliveryCIF = @m_DeliveryCIF,DeliveryFCA = @m_DeliveryFCA,DeliveryDDU = @m_DeliveryDDU,DeliveryFOB = @m_DeliveryFOB,ShipVia = @m_ShipVia,BillAddress = @m_BillAddress,BillContacter = @m_BillContacter,BillTel = @m_BillTel,BillFax = @m_BillFax,BillEmail = @m_BillEmail,ShipAddress = @m_ShipAddress,ShipContacter = @m_ShipContacter,ShipPhone = @m_ShipPhone,ShipFax = @m_ShipFax,ShipEmail = @m_ShipEmail,FShortName = @m_FShortName,FValueAddRate = @m_FValueAddRate,IsForbidden = @m_IsForbidden,FemployeeID = @m_FemployeeID,FSetID = @m_FSetID,FAPAccountID = @m_FAPAccountID,FpreAcctID = @m_FpreAcctID,FOtherAPAcctID = @m_FOtherAPAcctID,FPayTaxAcctID = @m_FPayTaxAcctID,FPayCondition = @m_FPayCondition WHERE ItemID = @m_ItemID", con);
con.Open();
if (model.TaskID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = model.TaskID;
}
if (model.RequestUser == null)
{
cmd.Parameters.Add(new SqlParameter("@m_RequestUser", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_RequestUser", SqlDbType.NVarChar, 50)).Value = model.RequestUser;
}
if (model.RequestDept == null)
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDept", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDept", SqlDbType.NVarChar, 50)).Value = model.RequestDept;
}
if (model.RequestDate == new DateTime())
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = model.RequestDate;
}
if (model.SNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = model.SNumber;
}
if (model.FNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).Value = model.FNumber;
}
if (model.FSaleModeName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeName", SqlDbType.NVarChar, 50)).Value = model.FSaleModeName;
}
if (model.FSaleModeID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeID", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeID", SqlDbType.NVarChar, 50)).Value = model.FSaleModeID;
}
if (model.FSaleModeNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleModeNumber", SqlDbType.NVarChar, 50)).Value = model.FSaleModeNumber;
}
if (model.FSaleTypeName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeName", SqlDbType.NVarChar, 50)).Value = model.FSaleTypeName;
}
if (model.FSaleTypeID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeID", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeID", SqlDbType.NVarChar, 50)).Value = model.FSaleTypeID;
}
if (model.FSaleTypeNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSaleTypeNumber", SqlDbType.NVarChar, 50)).Value = model.FSaleTypeNumber;
}
if (model.FCyName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FCyName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FCyName", SqlDbType.NVarChar, 50)).Value = model.FCyName;
}
if (model.FCyID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FCyID", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FCyID", SqlDbType.NVarChar, 50)).Value = model.FCyID;
}
if (model.FCyNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FCyNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FCyNumber", SqlDbType.NVarChar, 50)).Value = model.FCyNumber;
}
if (model.FAPAccountIDName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountIDName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountIDName", SqlDbType.NVarChar, 50)).Value = model.FAPAccountIDName;
}
if (model.FAPAccountIDNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountIDNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountIDNumber", SqlDbType.NVarChar, 50)).Value = model.FAPAccountIDNumber;
}
if (model.FPreAcctIDName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPreAcctIDName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPreAcctIDName", SqlDbType.NVarChar, 50)).Value = model.FPreAcctIDName;
}
if (model.FPreAcctIDNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPreAcctIDNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPreAcctIDNumber", SqlDbType.NVarChar, 50)).Value = model.FPreAcctIDNumber;
}
if (model.FOtherAPAcctIDName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctIDName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctIDName", SqlDbType.NVarChar, 50)).Value = model.FOtherAPAcctIDName;
}
if (model.FOtherAPAcctIDNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctIDNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctIDNumber", SqlDbType.NVarChar, 50)).Value = model.FOtherAPAcctIDNumber;
}
if (model.FPayTaxAcctIDName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctIDName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctIDName", SqlDbType.NVarChar, 50)).Value = model.FPayTaxAcctIDName;
}
if (model.FPayTaxAcctIDNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctIDNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctIDNumber", SqlDbType.NVarChar, 50)).Value = model.FPayTaxAcctIDNumber;
}
if (model.FemployeeName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeName", SqlDbType.NVarChar, 50)).Value = model.FemployeeName;
}
if (model.FemployeeNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeNumber", SqlDbType.NVarChar, 50)).Value = model.FemployeeNumber;
}
if (model.FPayConditionName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayConditionName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayConditionName", SqlDbType.NVarChar, 50)).Value = model.FPayConditionName;
}
if (model.FPayConditionNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayConditionNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayConditionNumber", SqlDbType.NVarChar, 50)).Value = model.FPayConditionNumber;
}
if (model.FSetIDName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSetIDName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSetIDName", SqlDbType.NVarChar, 50)).Value = model.FSetIDName;
}
if (model.FSetIDNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSetIDNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSetIDNumber", SqlDbType.NVarChar, 50)).Value = model.FSetIDNumber;
}
if (model.CustomerName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CustomerName", SqlDbType.NVarChar, 200)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CustomerName", SqlDbType.NVarChar, 200)).Value = model.CustomerName;
}
if (model.CustomerNameEN == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CustomerNameEN", SqlDbType.NVarChar, 300)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CustomerNameEN", SqlDbType.NVarChar, 300)).Value = model.CustomerNameEN;
}
if (model.CompanyAddress == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CompanyAddress", SqlDbType.NVarChar, 500)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CompanyAddress", SqlDbType.NVarChar, 500)).Value = model.CompanyAddress;
}
if (model.Headquarter == null)
{
cmd.Parameters.Add(new SqlParameter("@m_Headquarter", SqlDbType.NVarChar, 200)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_Headquarter", SqlDbType.NVarChar, 200)).Value = model.Headquarter;
}
if (model.CompanyContact == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CompanyContact", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CompanyContact", SqlDbType.NVarChar, 50)).Value = model.CompanyContact;
}
if (model.CustomTel == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CustomTel", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CustomTel", SqlDbType.NVarChar, 50)).Value = model.CustomTel;
}
if (model.CustomFax == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CustomFax", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CustomFax", SqlDbType.NVarChar, 50)).Value = model.CustomFax;
}
if (model.CustomEmail == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CustomEmail", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CustomEmail", SqlDbType.NVarChar, 50)).Value = model.CustomEmail;
}
if (model.BankAccount == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BankAccount", SqlDbType.NVarChar, 200)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BankAccount", SqlDbType.NVarChar, 200)).Value = model.BankAccount;
}
if (model.BankName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BankName", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BankName", SqlDbType.NVarChar, 100)).Value = model.BankName;
}
if (model.BankAddress == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BankAddress", SqlDbType.NVarChar, 300)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BankAddress", SqlDbType.NVarChar, 300)).Value = model.BankAddress;
}
if (model.BankAccountNo == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BankAccountNo", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BankAccountNo", SqlDbType.NVarChar, 100)).Value = model.BankAccountNo;
}
if (model.VATNo == null)
{
cmd.Parameters.Add(new SqlParameter("@m_VATNo", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_VATNo", SqlDbType.NVarChar, 100)).Value = model.VATNo;
}
if (model.SwiftCode == null)
{
cmd.Parameters.Add(new SqlParameter("@m_SwiftCode", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_SwiftCode", SqlDbType.NVarChar, 100)).Value = model.SwiftCode;
}
if (model.ABANumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ABANumber", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ABANumber", SqlDbType.NVarChar, 100)).Value = model.ABANumber;
}
if (model.IBANumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_IBANumber", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_IBANumber", SqlDbType.NVarChar, 100)).Value = model.IBANumber;
}
if (model.PayTerms == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayTerms", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayTerms", SqlDbType.NVarChar, 50)).Value = model.PayTerms;
}
if (model.PayTermsCode == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayTermsCode", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayTermsCode", SqlDbType.NVarChar, 50)).Value = model.PayTermsCode;
}
if (model.PayMethod == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayMethod", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayMethod", SqlDbType.NVarChar, 50)).Value = model.PayMethod;
}
if (model.PayMethodCode == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayMethodCode", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayMethodCode", SqlDbType.NVarChar, 50)).Value = model.PayMethodCode;
}
if (model.CreditLimit == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CreditLimit", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CreditLimit", SqlDbType.NVarChar, 50)).Value = model.CreditLimit;
}
if (model.Currency == null)
{
cmd.Parameters.Add(new SqlParameter("@m_Currency", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_Currency", SqlDbType.NVarChar, 50)).Value = model.Currency;
}
if (model.CurrencyCode == null)
{
cmd.Parameters.Add(new SqlParameter("@m_CurrencyCode", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_CurrencyCode", SqlDbType.NVarChar, 50)).Value = model.CurrencyCode;
}
if (model.FinanceContacter == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FinanceContacter", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FinanceContacter", SqlDbType.NVarChar, 50)).Value = model.FinanceContacter;
}
if (model.PayTel == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayTel", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayTel", SqlDbType.NVarChar, 50)).Value = model.PayTel;
}
if (model.PayFax == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayFax", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayFax", SqlDbType.NVarChar, 50)).Value = model.PayFax;
}
if (model.PayEmail == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PayEmail", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PayEmail", SqlDbType.NVarChar, 50)).Value = model.PayEmail;
}
if (model.DeliveryEXW == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryEXW", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryEXW", SqlDbType.NVarChar, 50)).Value = model.DeliveryEXW;
}
if (model.DeliveryDDP == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryDDP", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryDDP", SqlDbType.NVarChar, 50)).Value = model.DeliveryDDP;
}
if (model.DeliveryCIF == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryCIF", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryCIF", SqlDbType.NVarChar, 50)).Value = model.DeliveryCIF;
}
if (model.DeliveryFCA == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryFCA", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryFCA", SqlDbType.NVarChar, 50)).Value = model.DeliveryFCA;
}
if (model.DeliveryDDU == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryDDU", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryDDU", SqlDbType.NVarChar, 50)).Value = model.DeliveryDDU;
}
if (model.DeliveryFOB == null)
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryFOB", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_DeliveryFOB", SqlDbType.NVarChar, 50)).Value = model.DeliveryFOB;
}
if (model.ShipVia == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipVia", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipVia", SqlDbType.NVarChar, 50)).Value = model.ShipVia;
}
if (model.BillAddress == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BillAddress", SqlDbType.NVarChar, 300)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BillAddress", SqlDbType.NVarChar, 300)).Value = model.BillAddress;
}
if (model.BillContacter == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BillContacter", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BillContacter", SqlDbType.NVarChar, 50)).Value = model.BillContacter;
}
if (model.BillTel == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BillTel", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BillTel", SqlDbType.NVarChar, 50)).Value = model.BillTel;
}
if (model.BillFax == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BillFax", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BillFax", SqlDbType.NVarChar, 50)).Value = model.BillFax;
}
if (model.BillEmail == null)
{
cmd.Parameters.Add(new SqlParameter("@m_BillEmail", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_BillEmail", SqlDbType.NVarChar, 50)).Value = model.BillEmail;
}
if (model.ShipAddress == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipAddress", SqlDbType.NVarChar, 500)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipAddress", SqlDbType.NVarChar, 500)).Value = model.ShipAddress;
}
if (model.ShipContacter == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipContacter", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipContacter", SqlDbType.NVarChar, 50)).Value = model.ShipContacter;
}
if (model.ShipPhone == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipPhone", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipPhone", SqlDbType.NVarChar, 50)).Value = model.ShipPhone;
}
if (model.ShipFax == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipFax", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipFax", SqlDbType.NVarChar, 50)).Value = model.ShipFax;
}
if (model.ShipEmail == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ShipEmail", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ShipEmail", SqlDbType.NVarChar, 50)).Value = model.ShipEmail;
}
if (model.FShortName == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FShortName", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FShortName", SqlDbType.NVarChar, 50)).Value = model.FShortName;
}
if (model.FValueAddRate == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FValueAddRate", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FValueAddRate", SqlDbType.Int, 0)).Value = model.FValueAddRate;
}
if (model.IsForbidden == null)
{
cmd.Parameters.Add(new SqlParameter("@m_IsForbidden", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_IsForbidden", SqlDbType.Int, 0)).Value = model.IsForbidden;
}
if (model.FemployeeID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FemployeeID", SqlDbType.Int, 0)).Value = model.FemployeeID;
}
if (model.FSetID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FSetID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FSetID", SqlDbType.Int, 0)).Value = model.FSetID;
}
if (model.FAPAccountID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FAPAccountID", SqlDbType.Int, 0)).Value = model.FAPAccountID;
}
if (model.FpreAcctID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FpreAcctID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FpreAcctID", SqlDbType.Int, 0)).Value = model.FpreAcctID;
}
if (model.FOtherAPAcctID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FOtherAPAcctID", SqlDbType.Int, 0)).Value = model.FOtherAPAcctID;
}
if (model.FPayTaxAcctID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayTaxAcctID", SqlDbType.Int, 0)).Value = model.FPayTaxAcctID;
}
if (model.FPayCondition == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FPayCondition", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FPayCondition", SqlDbType.Int, 0)).Value = model.FPayCondition;
}
cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = model.ItemID;
try { cmd.ExecuteNonQuery(); }
catch (Exception e) { throw new Exception(e.ToString()); }
cmd.Dispose();
con.Close();
con.Dispose();
}
public static string connectionString = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None).AppSettings.Settings["ConnectionString"].Value; //连接信息
/// <summary>
/// 对象JD_Customer_Mng明细
/// 编写人：ywk
/// 编写日期：2018/9/5 星期三
/// </summary>
public JD_Customer_Mng Detail(int TaskID)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM JD_Customer_Mng WHERE TaskID = @m_TaskID", con);
con.Open();
cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = TaskID;
JD_Customer_Mng myDetail = new JD_Customer_Mng();
SqlDataReader myReader = cmd.ExecuteReader();
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["ItemID"]))
{
myDetail.ItemID = Convert.ToInt32(myReader["ItemID"]);
}
if (!Convert.IsDBNull(myReader["TaskID"]))
{
myDetail.TaskID = Convert.ToInt32(myReader["TaskID"]);
}
if (!Convert.IsDBNull(myReader["RequestUser"]))
{
myDetail.RequestUser = Convert.ToString(myReader["RequestUser"]);
}
if (!Convert.IsDBNull(myReader["RequestDept"]))
{
myDetail.RequestDept = Convert.ToString(myReader["RequestDept"]);
}
if (!Convert.IsDBNull(myReader["RequestDate"]))
{
myDetail.RequestDate = Convert.ToDateTime(myReader["RequestDate"]);
}
if (!Convert.IsDBNull(myReader["SNumber"]))
{
myDetail.SNumber = Convert.ToString(myReader["SNumber"]);
}
if (!Convert.IsDBNull(myReader["FNumber"]))
{
myDetail.FNumber = Convert.ToString(myReader["FNumber"]);
}
if (!Convert.IsDBNull(myReader["FSaleModeName"]))
{
myDetail.FSaleModeName = Convert.ToString(myReader["FSaleModeName"]);
}
if (!Convert.IsDBNull(myReader["FSaleModeID"]))
{
myDetail.FSaleModeID = Convert.ToString(myReader["FSaleModeID"]);
}
if (!Convert.IsDBNull(myReader["FSaleModeNumber"]))
{
myDetail.FSaleModeNumber = Convert.ToString(myReader["FSaleModeNumber"]);
}
if (!Convert.IsDBNull(myReader["FSaleTypeName"]))
{
myDetail.FSaleTypeName = Convert.ToString(myReader["FSaleTypeName"]);
}
if (!Convert.IsDBNull(myReader["FSaleTypeID"]))
{
myDetail.FSaleTypeID = Convert.ToString(myReader["FSaleTypeID"]);
}
if (!Convert.IsDBNull(myReader["FSaleTypeNumber"]))
{
myDetail.FSaleTypeNumber = Convert.ToString(myReader["FSaleTypeNumber"]);
}
if (!Convert.IsDBNull(myReader["FCyName"]))
{
myDetail.FCyName = Convert.ToString(myReader["FCyName"]);
}
if (!Convert.IsDBNull(myReader["FCyID"]))
{
myDetail.FCyID = Convert.ToString(myReader["FCyID"]);
}
if (!Convert.IsDBNull(myReader["FCyNumber"]))
{
myDetail.FCyNumber = Convert.ToString(myReader["FCyNumber"]);
}
if (!Convert.IsDBNull(myReader["FAPAccountIDName"]))
{
myDetail.FAPAccountIDName = Convert.ToString(myReader["FAPAccountIDName"]);
}
if (!Convert.IsDBNull(myReader["FAPAccountIDNumber"]))
{
myDetail.FAPAccountIDNumber = Convert.ToString(myReader["FAPAccountIDNumber"]);
}
if (!Convert.IsDBNull(myReader["FPreAcctIDName"]))
{
myDetail.FPreAcctIDName = Convert.ToString(myReader["FPreAcctIDName"]);
}
if (!Convert.IsDBNull(myReader["FPreAcctIDNumber"]))
{
myDetail.FPreAcctIDNumber = Convert.ToString(myReader["FPreAcctIDNumber"]);
}
if (!Convert.IsDBNull(myReader["FOtherAPAcctIDName"]))
{
myDetail.FOtherAPAcctIDName = Convert.ToString(myReader["FOtherAPAcctIDName"]);
}
if (!Convert.IsDBNull(myReader["FOtherAPAcctIDNumber"]))
{
myDetail.FOtherAPAcctIDNumber = Convert.ToString(myReader["FOtherAPAcctIDNumber"]);
}
if (!Convert.IsDBNull(myReader["FPayTaxAcctIDName"]))
{
myDetail.FPayTaxAcctIDName = Convert.ToString(myReader["FPayTaxAcctIDName"]);
}
if (!Convert.IsDBNull(myReader["FPayTaxAcctIDNumber"]))
{
myDetail.FPayTaxAcctIDNumber = Convert.ToString(myReader["FPayTaxAcctIDNumber"]);
}
if (!Convert.IsDBNull(myReader["FemployeeName"]))
{
myDetail.FemployeeName = Convert.ToString(myReader["FemployeeName"]);
}
if (!Convert.IsDBNull(myReader["FemployeeNumber"]))
{
myDetail.FemployeeNumber = Convert.ToString(myReader["FemployeeNumber"]);
}
if (!Convert.IsDBNull(myReader["FPayConditionName"]))
{
myDetail.FPayConditionName = Convert.ToString(myReader["FPayConditionName"]);
}
if (!Convert.IsDBNull(myReader["FPayConditionNumber"]))
{
myDetail.FPayConditionNumber = Convert.ToString(myReader["FPayConditionNumber"]);
}
if (!Convert.IsDBNull(myReader["FSetIDName"]))
{
myDetail.FSetIDName = Convert.ToString(myReader["FSetIDName"]);
}
if (!Convert.IsDBNull(myReader["FSetIDNumber"]))
{
myDetail.FSetIDNumber = Convert.ToString(myReader["FSetIDNumber"]);
}
if (!Convert.IsDBNull(myReader["CustomerName"]))
{
myDetail.CustomerName = Convert.ToString(myReader["CustomerName"]);
}
if (!Convert.IsDBNull(myReader["CustomerNameEN"]))
{
myDetail.CustomerNameEN = Convert.ToString(myReader["CustomerNameEN"]);
}
if (!Convert.IsDBNull(myReader["CompanyAddress"]))
{
myDetail.CompanyAddress = Convert.ToString(myReader["CompanyAddress"]);
}
if (!Convert.IsDBNull(myReader["Headquarter"]))
{
myDetail.Headquarter = Convert.ToString(myReader["Headquarter"]);
}
if (!Convert.IsDBNull(myReader["CompanyContact"]))
{
myDetail.CompanyContact = Convert.ToString(myReader["CompanyContact"]);
}
if (!Convert.IsDBNull(myReader["CustomTel"]))
{
myDetail.CustomTel = Convert.ToString(myReader["CustomTel"]);
}
if (!Convert.IsDBNull(myReader["CustomFax"]))
{
myDetail.CustomFax = Convert.ToString(myReader["CustomFax"]);
}
if (!Convert.IsDBNull(myReader["CustomEmail"]))
{
myDetail.CustomEmail = Convert.ToString(myReader["CustomEmail"]);
}
if (!Convert.IsDBNull(myReader["BankAccount"]))
{
myDetail.BankAccount = Convert.ToString(myReader["BankAccount"]);
}
if (!Convert.IsDBNull(myReader["BankName"]))
{
myDetail.BankName = Convert.ToString(myReader["BankName"]);
}
if (!Convert.IsDBNull(myReader["BankAddress"]))
{
myDetail.BankAddress = Convert.ToString(myReader["BankAddress"]);
}
if (!Convert.IsDBNull(myReader["BankAccountNo"]))
{
myDetail.BankAccountNo = Convert.ToString(myReader["BankAccountNo"]);
}
if (!Convert.IsDBNull(myReader["VATNo"]))
{
myDetail.VATNo = Convert.ToString(myReader["VATNo"]);
}
if (!Convert.IsDBNull(myReader["SwiftCode"]))
{
myDetail.SwiftCode = Convert.ToString(myReader["SwiftCode"]);
}
if (!Convert.IsDBNull(myReader["ABANumber"]))
{
myDetail.ABANumber = Convert.ToString(myReader["ABANumber"]);
}
if (!Convert.IsDBNull(myReader["IBANumber"]))
{
myDetail.IBANumber = Convert.ToString(myReader["IBANumber"]);
}
if (!Convert.IsDBNull(myReader["PayTerms"]))
{
myDetail.PayTerms = Convert.ToString(myReader["PayTerms"]);
}
if (!Convert.IsDBNull(myReader["PayTermsCode"]))
{
myDetail.PayTermsCode = Convert.ToString(myReader["PayTermsCode"]);
}
if (!Convert.IsDBNull(myReader["PayMethod"]))
{
myDetail.PayMethod = Convert.ToString(myReader["PayMethod"]);
}
if (!Convert.IsDBNull(myReader["PayMethodCode"]))
{
myDetail.PayMethodCode = Convert.ToString(myReader["PayMethodCode"]);
}
if (!Convert.IsDBNull(myReader["CreditLimit"]))
{
myDetail.CreditLimit = Convert.ToString(myReader["CreditLimit"]);
}
if (!Convert.IsDBNull(myReader["Currency"]))
{
myDetail.Currency = Convert.ToString(myReader["Currency"]);
}
if (!Convert.IsDBNull(myReader["CurrencyCode"]))
{
myDetail.CurrencyCode = Convert.ToString(myReader["CurrencyCode"]);
}
if (!Convert.IsDBNull(myReader["FinanceContacter"]))
{
myDetail.FinanceContacter = Convert.ToString(myReader["FinanceContacter"]);
}
if (!Convert.IsDBNull(myReader["PayTel"]))
{
myDetail.PayTel = Convert.ToString(myReader["PayTel"]);
}
if (!Convert.IsDBNull(myReader["PayFax"]))
{
myDetail.PayFax = Convert.ToString(myReader["PayFax"]);
}
if (!Convert.IsDBNull(myReader["PayEmail"]))
{
myDetail.PayEmail = Convert.ToString(myReader["PayEmail"]);
}
if (!Convert.IsDBNull(myReader["DeliveryEXW"]))
{
myDetail.DeliveryEXW = Convert.ToString(myReader["DeliveryEXW"]);
}
if (!Convert.IsDBNull(myReader["DeliveryDDP"]))
{
myDetail.DeliveryDDP = Convert.ToString(myReader["DeliveryDDP"]);
}
if (!Convert.IsDBNull(myReader["DeliveryCIF"]))
{
myDetail.DeliveryCIF = Convert.ToString(myReader["DeliveryCIF"]);
}
if (!Convert.IsDBNull(myReader["DeliveryFCA"]))
{
myDetail.DeliveryFCA = Convert.ToString(myReader["DeliveryFCA"]);
}
if (!Convert.IsDBNull(myReader["DeliveryDDU"]))
{
myDetail.DeliveryDDU = Convert.ToString(myReader["DeliveryDDU"]);
}
if (!Convert.IsDBNull(myReader["DeliveryFOB"]))
{
myDetail.DeliveryFOB = Convert.ToString(myReader["DeliveryFOB"]);
}
if (!Convert.IsDBNull(myReader["ShipVia"]))
{
myDetail.ShipVia = Convert.ToString(myReader["ShipVia"]);
}
if (!Convert.IsDBNull(myReader["BillAddress"]))
{
myDetail.BillAddress = Convert.ToString(myReader["BillAddress"]);
}
if (!Convert.IsDBNull(myReader["BillContacter"]))
{
myDetail.BillContacter = Convert.ToString(myReader["BillContacter"]);
}
if (!Convert.IsDBNull(myReader["BillTel"]))
{
myDetail.BillTel = Convert.ToString(myReader["BillTel"]);
}
if (!Convert.IsDBNull(myReader["BillFax"]))
{
myDetail.BillFax = Convert.ToString(myReader["BillFax"]);
}
if (!Convert.IsDBNull(myReader["BillEmail"]))
{
myDetail.BillEmail = Convert.ToString(myReader["BillEmail"]);
}
if (!Convert.IsDBNull(myReader["ShipAddress"]))
{
myDetail.ShipAddress = Convert.ToString(myReader["ShipAddress"]);
}
if (!Convert.IsDBNull(myReader["ShipContacter"]))
{
myDetail.ShipContacter = Convert.ToString(myReader["ShipContacter"]);
}
if (!Convert.IsDBNull(myReader["ShipPhone"]))
{
myDetail.ShipPhone = Convert.ToString(myReader["ShipPhone"]);
}
if (!Convert.IsDBNull(myReader["ShipFax"]))
{
myDetail.ShipFax = Convert.ToString(myReader["ShipFax"]);
}
if (!Convert.IsDBNull(myReader["ShipEmail"]))
{
myDetail.ShipEmail = Convert.ToString(myReader["ShipEmail"]);
}
if (!Convert.IsDBNull(myReader["FShortName"]))
{
myDetail.FShortName = Convert.ToString(myReader["FShortName"]);
}
if (!Convert.IsDBNull(myReader["FValueAddRate"]))
{
myDetail.FValueAddRate = Convert.ToInt32(myReader["FValueAddRate"]);
}
if (!Convert.IsDBNull(myReader["IsForbidden"]))
{
myDetail.IsForbidden = Convert.ToInt32(myReader["IsForbidden"]);
}
if (!Convert.IsDBNull(myReader["FemployeeID"]))
{
myDetail.FemployeeID = Convert.ToInt32(myReader["FemployeeID"]);
}
if (!Convert.IsDBNull(myReader["FSetID"]))
{
myDetail.FSetID = Convert.ToInt32(myReader["FSetID"]);
}
if (!Convert.IsDBNull(myReader["FAPAccountID"]))
{
myDetail.FAPAccountID = Convert.ToInt32(myReader["FAPAccountID"]);
}
if (!Convert.IsDBNull(myReader["FpreAcctID"]))
{
myDetail.FpreAcctID = Convert.ToInt32(myReader["FpreAcctID"]);
}
if (!Convert.IsDBNull(myReader["FOtherAPAcctID"]))
{
myDetail.FOtherAPAcctID = Convert.ToInt32(myReader["FOtherAPAcctID"]);
}
if (!Convert.IsDBNull(myReader["FPayTaxAcctID"]))
{
myDetail.FPayTaxAcctID = Convert.ToInt32(myReader["FPayTaxAcctID"]);
}
if (!Convert.IsDBNull(myReader["FPayCondition"]))
{
myDetail.FPayCondition = Convert.ToInt32(myReader["FPayCondition"]);
}
}
myReader.Close();
cmd.Dispose();
con.Close();
con.Dispose();
return(myDetail);
}
