/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.SampleMain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SampleMain set ");
strSql.Append("CompanyID=@CompanyID,");
strSql.Append("BrandID=@BrandID,");
strSql.Append("Season=@Season,");
strSql.Append("MTID=@MTID,");
strSql.Append("Fabric=@Fabric,");
strSql.Append("MainCloth1=@MainCloth1,");
strSql.Append("MainCloth2=@MainCloth2,");
strSql.Append("MinorCloth1=@MinorCloth1,");
strSql.Append("MinorCloth2=@MinorCloth2,");
strSql.Append("MainCloth1Remark=@MainCloth1Remark,");
strSql.Append("MainCloth2Remak=@MainCloth2Remak,");
strSql.Append("MinorCloth1Remark=@MinorCloth1Remark,");
strSql.Append("MinorCloth2Remark=@MinorCloth2Remark,");
strSql.Append("DateTime=@DateTime,");
strSql.Append("POID=@POID,");
strSql.Append("CompanyMateriel=@CompanyMateriel,");
strSql.Append("MaterielID=@MaterielID,");
strSql.Append("SumAmount=@SumAmount,");
strSql.Append("BackSampleDate=@BackSampleDate,");
strSql.Append("AskBackDate=@AskBackDate,");
strSql.Append("BillingMan=@BillingMan,");
strSql.Append("Counter=@Counter,");
strSql.Append("RevisedCounter=@RevisedCounter,");
strSql.Append("Approval=@Approval,");
strSql.Append("TextSample=@TextSample,");
strSql.Append("ShowSample=@ShowSample,");
strSql.Append("PhotoSample=@PhotoSample,");
strSql.Append("SizeSet1=@SizeSet1,");
strSql.Append("SizeSet2=@SizeSet2,");
strSql.Append("SizeSet3=@SizeSet3,");
strSql.Append("SalesmanSample=@SalesmanSample,");
strSql.Append("ProductionSample=@ProductionSample,");
strSql.Append("ShipmentSample=@ShipmentSample,");
strSql.Append("UpData=@UpData,");
strSql.Append("FillMan=@FillMan,");
strSql.Append("IsVerify=@IsVerify,");
strSql.Append("VerifyMan=@VerifyMan,");
strSql.Append("VerifyDate=@VerifyDate,");
strSql.Append("Remark=@Remark,");
strSql.Append("Stata=@Stata,");
strSql.Append("OderMainID=@OderMainID,");
strSql.Append("LastEdit=@LastEdit,");
strSql.Append("LastEditDate=@LastEditDate,");
strSql.Append("EditRemark=@EditRemark,");
strSql.Append("GenDan=@GenDan,");
strSql.Append("BanFangGengDan=@BanFangGengDan,");
strSql.Append("ZhiYang=@ZhiYang,");
strSql.Append("CheBan=@CheBan,");
strSql.Append("BanFangZhuGuang=@BanFangZhuGuang,");
strSql.Append("ShengChanBu=@ShengChanBu,");
strSql.Append("Size1=@Size1,");
strSql.Append("Size2=@Size2,");
strSql.Append("BackAmount=@BackAmount,");
strSql.Append("HaveOld=@HaveOld,");
strSql.Append("SizeRefer=@SizeRefer,");
strSql.Append("TaskRemark=@TaskRemark,");
strSql.Append("BrandRemark=@BrandRemark,");
strSql.Append("Images=@Images,");
strSql.Append("BrandImages=@BrandImages,");
strSql.Append("DefaultSTID=@DefaultSTID");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CompanyID", SqlDbType.Int, 4),
new SqlParameter("@BrandID", SqlDbType.Int, 4),
new SqlParameter("@Season", SqlDbType.NVarChar, 50),
new SqlParameter("@MTID", SqlDbType.Int, 4),
new SqlParameter("@Fabric", SqlDbType.NVarChar, 200),
new SqlParameter("@MainCloth1", SqlDbType.NVarChar, 50),
new SqlParameter("@MainCloth2", SqlDbType.NVarChar, 50),
new SqlParameter("@MinorCloth1", SqlDbType.NVarChar, 50),
new SqlParameter("@MinorCloth2", SqlDbType.NVarChar, 50),
new SqlParameter("@MainCloth1Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@MainCloth2Remak", SqlDbType.NVarChar, 200),
new SqlParameter("@MinorCloth1Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@MinorCloth2Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@DateTime", SqlDbType.DateTime),
new SqlParameter("@POID", SqlDbType.NVarChar, 50),
new SqlParameter("@CompanyMateriel", SqlDbType.NVarChar, 50),
new SqlParameter("@MaterielID", SqlDbType.NVarChar, 50),
new SqlParameter("@SumAmount", SqlDbType.Int, 4),
new SqlParameter("@BackSampleDate", SqlDbType.DateTime),
new SqlParameter("@AskBackDate", SqlDbType.DateTime),
new SqlParameter("@BillingMan", SqlDbType.NVarChar, 50),
new SqlParameter("@Counter", SqlDbType.Bit, 1),
new SqlParameter("@RevisedCounter", SqlDbType.Bit, 1),
new SqlParameter("@Approval", SqlDbType.Bit, 1),
new SqlParameter("@TextSample", SqlDbType.Bit, 1),
new SqlParameter("@ShowSample", SqlDbType.Bit, 1),
new SqlParameter("@PhotoSample", SqlDbType.Bit, 1),
new SqlParameter("@SizeSet1", SqlDbType.Bit, 1),
new SqlParameter("@SizeSet2", SqlDbType.Bit, 1),
new SqlParameter("@SizeSet3", SqlDbType.Bit, 1),
new SqlParameter("@SalesmanSample", SqlDbType.Bit, 1),
new SqlParameter("@ProductionSample", SqlDbType.Bit, 1),
new SqlParameter("@ShipmentSample", SqlDbType.Bit, 1),
new SqlParameter("@UpData", SqlDbType.Int, 4),
new SqlParameter("@FillMan", SqlDbType.Int, 4),
new SqlParameter("@IsVerify", SqlDbType.Int, 4),
new SqlParameter("@VerifyMan", SqlDbType.Int, 4),
new SqlParameter("@VerifyDate", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Stata", SqlDbType.Int, 4),
new SqlParameter("@OderMainID", SqlDbType.Int, 4),
new SqlParameter("@LastEdit", SqlDbType.Int, 4),
new SqlParameter("@LastEditDate", SqlDbType.DateTime),
new SqlParameter("@EditRemark", SqlDbType.NVarChar, 2000),
new SqlParameter("@GenDan", SqlDbType.NVarChar, 50),
new SqlParameter("@BanFangGengDan", SqlDbType.NVarChar, 50),
new SqlParameter("@ZhiYang", SqlDbType.NVarChar, 50),
new SqlParameter("@CheBan", SqlDbType.NVarChar, 50),
new SqlParameter("@BanFangZhuGuang", SqlDbType.NVarChar, 50),
new SqlParameter("@ShengChanBu", SqlDbType.NVarChar, 50),
new SqlParameter("@Size1", SqlDbType.NVarChar, 50),
new SqlParameter("@Size2", SqlDbType.NVarChar, 50),
new SqlParameter("@BackAmount", SqlDbType.NVarChar, 50),
new SqlParameter("@HaveOld", SqlDbType.NVarChar, 50),
new SqlParameter("@SizeRefer", SqlDbType.NVarChar, 50),
new SqlParameter("@TaskRemark", SqlDbType.NVarChar, 2000),
new SqlParameter("@BrandRemark", SqlDbType.NVarChar, 2000),
new SqlParameter("@Images", SqlDbType.NVarChar, 50),
new SqlParameter("@BrandImages", SqlDbType.NVarChar, 50),
new SqlParameter("@DefaultSTID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CompanyID;
parameters[2].Value = model.BrandID;
parameters[3].Value = model.Season;
parameters[4].Value = model.MTID;
parameters[5].Value = model.Fabric;
parameters[6].Value = model.MainCloth1;
parameters[7].Value = model.MainCloth2;
parameters[8].Value = model.MinorCloth1;
parameters[9].Value = model.MinorCloth2;
parameters[10].Value = model.MainCloth1Remark;
parameters[11].Value = model.MainCloth2Remak;
parameters[12].Value = model.MinorCloth1Remark;
parameters[13].Value = model.MinorCloth2Remark;
parameters[14].Value = model.DateTime;
parameters[15].Value = model.POID;
parameters[16].Value = model.CompanyMateriel;
parameters[17].Value = model.MaterielID;
parameters[18].Value = model.SumAmount;
parameters[19].Value = model.BackSampleDate;
parameters[20].Value = model.AskBackDate;
parameters[21].Value = model.BillingMan;
parameters[22].Value = model.Counter;
parameters[23].Value = model.RevisedCounter;
parameters[24].Value = model.Approval;
parameters[25].Value = model.TextSample;
parameters[26].Value = model.ShowSample;
parameters[27].Value = model.PhotoSample;
parameters[28].Value = model.SizeSet1;
parameters[29].Value = model.SizeSet2;
parameters[30].Value = model.SizeSet3;
parameters[31].Value = model.SalesmanSample;
parameters[32].Value = model.ProductionSample;
parameters[33].Value = model.ShipmentSample;
parameters[34].Value = model.UpData;
parameters[35].Value = model.FillMan;
parameters[36].Value = model.IsVerify;
parameters[37].Value = model.VerifyMan;
parameters[38].Value = model.VerifyDate;
parameters[39].Value = model.Remark;
parameters[40].Value = model.Stata;
parameters[41].Value = model.OderMainID;
parameters[42].Value = model.LastEdit;
parameters[43].Value = model.LastEditDate;
parameters[44].Value = model.EditRemark;
parameters[45].Value = model.GenDan;
parameters[46].Value = model.BanFangGengDan;
parameters[47].Value = model.ZhiYang;
parameters[48].Value = model.CheBan;
parameters[49].Value = model.BanFangZhuGuang;
parameters[50].Value = model.ShengChanBu;
parameters[51].Value = model.Size1;
parameters[52].Value = model.Size2;
parameters[53].Value = model.BackAmount;
parameters[54].Value = model.HaveOld;
parameters[55].Value = model.SizeRefer;
parameters[56].Value = model.TaskRemark;
parameters[57].Value = model.BrandRemark;
parameters[58].Value = model.Images;
parameters[59].Value = model.BrandImages;
parameters[60].Value = model.DefaultSTID;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
