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