public void AddSale_Order_SD_Process(int lgIndex, SqlCommand cmd, MSale_Order_SD_Process model)
{
StringBuilder strSql = new StringBuilder();
SqlParameter[] parameters = null;
strSql.Clear();
strSql.Append("insert into Sale_Order_SD_Process(");
strSql.Append("ID,F_CusLens,CXType,PD,PH,JY,UV,JS,RS,RSName,CS,SY,CB,ChB,KK,ZK,PiH,PG,JJ,OP,DpCodeJG)");
strSql.Append(" values (");
strSql.Append("@ID,@F_CusLens,@CXType,@PD,@PH,@JY,@UV,@JS,@RS,@RSName,@CS,@SY,@CB,@ChB,@KK,@ZK,@PiH,@PG,@JJ,@OP,@DpCodeJG)");
parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@F_CusLens", SqlDbType.Bit, 1),
new SqlParameter("@CXType", SqlDbType.TinyInt, 1),
new SqlParameter("@PD", SqlDbType.VarChar, 30),
new SqlParameter("@PH", SqlDbType.VarChar, 30),
new SqlParameter("@JY", SqlDbType.Bit, 1),
new SqlParameter("@UV", SqlDbType.Bit, 1),
new SqlParameter("@JS", SqlDbType.VarChar, 15),
new SqlParameter("@RS", SqlDbType.VarChar, 15),
new SqlParameter("@RSName", SqlDbType.NVarChar, 20),
new SqlParameter("@CS", SqlDbType.VarChar, 15),
new SqlParameter("@SY", SqlDbType.VarChar, 15),
new SqlParameter("@CB", SqlDbType.VarChar, 15),
new SqlParameter("@ChB", SqlDbType.VarChar, 15),
new SqlParameter("@KK", SqlDbType.VarChar, 15),
new SqlParameter("@ZK", SqlDbType.VarChar, 15),
new SqlParameter("@PiH", SqlDbType.VarChar, 15),
new SqlParameter("@PG", SqlDbType.VarChar, 15),
new SqlParameter("@JJ", SqlDbType.VarChar, 15),
new SqlParameter("@OP", SqlDbType.VarChar, 15),
new SqlParameter("@DpCodeJG", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.F_CusLens;
parameters[2].Value = model.CXType;
parameters[3].Value = model.PD;
parameters[4].Value = model.PH;
parameters[5].Value = model.JY;
parameters[6].Value = model.UV;
parameters[7].Value = model.JS;
parameters[8].Value = model.RS;
parameters[9].Value = model.RSName;
parameters[10].Value = model.CS;
parameters[11].Value = model.SY;
parameters[12].Value = model.CB;
parameters[13].Value = model.ChB;
parameters[14].Value = model.KK;
parameters[15].Value = model.ZK;
parameters[16].Value = model.PiH;
parameters[17].Value = model.PG;
parameters[18].Value = model.JJ;
parameters[19].Value = model.OP;
parameters[20].Value = model.DpCodeJG;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public void UpdateSale_Order_SD_Process(int lgIndex, SqlCommand cmd, MSale_Order_SD_Process model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sale_Order_SD_Process set ");
strSql.Append("F_CusLens=@F_CusLens,");
strSql.Append("CXType=@CXType,");
strSql.Append("PD=@PD,");
strSql.Append("PH=@PH,");
strSql.Append("JY=@JY,");
strSql.Append("UV=@UV,");
strSql.Append("JS=@JS,");
strSql.Append("RS=@RS,");
strSql.Append("RSName=@RSName,");
strSql.Append("CS=@CS,");
strSql.Append("SY=@SY,");
strSql.Append("CB=@CB,");
strSql.Append("ChB=@ChB,");
strSql.Append("KK=@KK,");
strSql.Append("ZK=@ZK,");
strSql.Append("PiH=@PiH,");
strSql.Append("PG=@PG,");
strSql.Append("JJ=@JJ,");
strSql.Append("OP=@OP,");
strSql.Append("DpCodeJG=@DpCodeJG");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@F_CusLens", SqlDbType.Bit, 1),
new SqlParameter("@CXType", SqlDbType.TinyInt, 1),
new SqlParameter("@PD", SqlDbType.VarChar, 30),
new SqlParameter("@PH", SqlDbType.VarChar, 30),
new SqlParameter("@JY", SqlDbType.Bit, 1),
new SqlParameter("@UV", SqlDbType.Bit, 1),
new SqlParameter("@JS", SqlDbType.VarChar, 15),
new SqlParameter("@RS", SqlDbType.VarChar, 15),
new SqlParameter("@RSName", SqlDbType.NVarChar, 20),
new SqlParameter("@CS", SqlDbType.VarChar, 15),
new SqlParameter("@SY", SqlDbType.VarChar, 15),
new SqlParameter("@CB", SqlDbType.VarChar, 15),
new SqlParameter("@ChB", SqlDbType.VarChar, 15),
new SqlParameter("@KK", SqlDbType.VarChar, 15),
new SqlParameter("@ZK", SqlDbType.VarChar, 15),
new SqlParameter("@PiH", SqlDbType.VarChar, 15),
new SqlParameter("@PG", SqlDbType.VarChar, 15),
new SqlParameter("@JJ", SqlDbType.VarChar, 15),
new SqlParameter("@OP", SqlDbType.VarChar, 15),
new SqlParameter("@DpCodeJG", SqlDbType.VarChar, 10),
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.F_CusLens;
parameters[1].Value = model.CXType;
parameters[2].Value = model.PD;
parameters[3].Value = model.PH;
parameters[4].Value = model.JY;
parameters[5].Value = model.UV;
parameters[6].Value = model.JS;
parameters[7].Value = model.RS;
parameters[8].Value = model.RSName;
parameters[9].Value = model.CS;
parameters[10].Value = model.SY;
parameters[11].Value = model.CB;
parameters[12].Value = model.ChB;
parameters[13].Value = model.KK;
parameters[14].Value = model.ZK;
parameters[15].Value = model.PiH;
parameters[16].Value = model.PG;
parameters[17].Value = model.JJ;
parameters[18].Value = model.OP;
parameters[19].Value = model.DpCodeJG;
parameters[20].Value = model.ID;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
