public void UpdateSale_Order_Extend(int lgIndex, SqlCommand cmd, MSale_Order_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sale_Order_Extend set "); strSql.Append("SumQty=@SumQty,"); strSql.Append("SumMoney=@SumMoney,"); strSql.Append("SumQtyPur=@SumQtyPur,"); strSql.Append("SumQtyRec=@SumQtyRec,"); strSql.Append("SumQtySO=@SumQtySO,"); strSql.Append("SumQtyCs=@SumQtyCs,"); strSql.Append("SumQtyRt=@SumQtyRt,"); strSql.Append("DN=@DN,"); strSql.Append("DDate=@DDate,"); strSql.Append("Rt1=@Rt1,"); strSql.Append("Rt2=@Rt2,"); strSql.Append("Rt3=@Rt3,"); strSql.Append("Rt4=@Rt4,"); strSql.Append("Rt5=@Rt5,"); strSql.Append("RtQR1=@RtQR1,"); strSql.Append("RtQR2=@RtQR2,"); strSql.Append("PdCode=@PdCode,"); strSql.Append("PdName=@PdName,"); strSql.Append("LensCodeR=@LensCodeR,"); strSql.Append("LensCodeRR=@LensCodeRR,"); strSql.Append("LensCodeL=@LensCodeL,"); strSql.Append("LensCodeRL=@LensCodeRL,"); strSql.Append("SPHR=@SPHR,"); strSql.Append("SPHL=@SPHL,"); strSql.Append("CYLR=@CYLR,"); strSql.Append("CYLL=@CYLL,"); strSql.Append("X_ADDR=@X_ADDR,"); strSql.Append("X_ADDL=@X_ADDL,"); strSql.Append("QtyR=@QtyR,"); strSql.Append("QtyL=@QtyL,"); strSql.Append("PriceR=@PriceR,"); strSql.Append("PriceL=@PriceL,"); strSql.Append("ProCostR=@ProCostR,"); strSql.Append("ProCostL=@ProCostL,"); strSql.Append("SN=@SN"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@SumQty", SqlDbType.Int, 4), new SqlParameter("@SumMoney", SqlDbType.Decimal, 9), new SqlParameter("@SumQtyPur", SqlDbType.Int, 4), new SqlParameter("@SumQtyRec", SqlDbType.Int, 4), new SqlParameter("@SumQtySO", SqlDbType.Int, 4), new SqlParameter("@SumQtyCs", SqlDbType.Int, 4), new SqlParameter("@SumQtyRt", SqlDbType.Int, 4), new SqlParameter("@DN", SqlDbType.VarChar, 100), new SqlParameter("@DDate", SqlDbType.DateTime), new SqlParameter("@Rt1", SqlDbType.VarChar, 200), new SqlParameter("@Rt2", SqlDbType.VarChar, 200), new SqlParameter("@Rt3", SqlDbType.VarChar, 200), new SqlParameter("@Rt4", SqlDbType.VarChar, 200), new SqlParameter("@Rt5", SqlDbType.VarChar, 200), new SqlParameter("@RtQR1", SqlDbType.VarChar, 2000), new SqlParameter("@RtQR2", SqlDbType.VarChar, 2000), new SqlParameter("@PdCode", SqlDbType.VarChar, 500), new SqlParameter("@PdName", SqlDbType.VarChar, 500), new SqlParameter("@LensCodeR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeRR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeL", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeRL", SqlDbType.VarChar, 50), new SqlParameter("@SPHR", SqlDbType.Int, 4), new SqlParameter("@SPHL", SqlDbType.Int, 4), new SqlParameter("@CYLR", SqlDbType.Int, 4), new SqlParameter("@CYLL", SqlDbType.Int, 4), new SqlParameter("@X_ADDR", SqlDbType.Int, 4), new SqlParameter("@X_ADDL", SqlDbType.Int, 4), new SqlParameter("@QtyR", SqlDbType.Int, 4), new SqlParameter("@QtyL", SqlDbType.Int, 4), new SqlParameter("@PriceR", SqlDbType.Decimal, 9), new SqlParameter("@PriceL", SqlDbType.Decimal, 9), new SqlParameter("@ProCostR", SqlDbType.Decimal, 9), new SqlParameter("@ProCostL", SqlDbType.Decimal, 9), new SqlParameter("@SN", SqlDbType.NVarChar, 50), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.SumQty; parameters[1].Value = model.SumMoney; parameters[2].Value = model.SumQtyPur; parameters[3].Value = model.SumQtyRec; parameters[4].Value = model.SumQtySO; parameters[5].Value = model.SumQtyCs; parameters[6].Value = model.SumQtyRt; parameters[7].Value = model.DN; parameters[8].Value = System.DBNull.Value;//model.DDate; parameters[9].Value = model.Rt1; parameters[10].Value = model.Rt2; parameters[11].Value = model.Rt3; parameters[12].Value = model.Rt4; parameters[13].Value = model.Rt5; parameters[14].Value = model.RtQR1; parameters[15].Value = model.RtQR2; parameters[16].Value = model.PdCode; parameters[17].Value = model.PdName; parameters[18].Value = model.LensCodeR; parameters[19].Value = model.LensCodeRR; parameters[20].Value = model.LensCodeL; parameters[21].Value = model.LensCodeRL; parameters[22].Value = model.SPHR; parameters[23].Value = model.SPHL; parameters[24].Value = model.CYLR; parameters[25].Value = model.CYLL; parameters[26].Value = model.X_ADDR; parameters[27].Value = model.X_ADDL; parameters[28].Value = model.QtyR; parameters[29].Value = model.QtyL; parameters[30].Value = model.PriceR; parameters[31].Value = model.PriceL; parameters[32].Value = model.ProCostR; parameters[33].Value = model.ProCostL; parameters[34].Value = model.SN; parameters[35].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void AddSale_Order_Extend(int lgIndex, SqlCommand cmd, MSale_Order_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sale_Order_Extend("); strSql.Append("ID,SumQty,SumMoney,SumQtyPur,SumQtyRec,SumQtySO,SumQtyCs,SumQtyRt,DN,DDate,Rt1,Rt2,Rt3,Rt4,Rt5,RtQR1,RtQR2,PdCode,PdName,LensCodeR,LensCodeRR,LensCodeL,LensCodeRL,SPHR,SPHL,CYLR,CYLL,X_ADDR,X_ADDL,QtyR,QtyL,PriceR,PriceL,ProCostR,ProCostL,SN)"); strSql.Append(" values ("); strSql.Append("@ID,@SumQty,@SumMoney,@SumQtyPur,@SumQtyRec,@SumQtySO,@SumQtyCs,@SumQtyRt,@DN,@DDate,@Rt1,@Rt2,@Rt3,@Rt4,@Rt5,@RtQR1,@RtQR2,@PdCode,@PdName,@LensCodeR,@LensCodeRR,@LensCodeL,@LensCodeRL,@SPHR,@SPHL,@CYLR,@CYLL,@X_ADDR,@X_ADDL,@QtyR,@QtyL,@PriceR,@PriceL,@ProCostR,@ProCostL,@SN)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@SumQty", SqlDbType.Int, 4), new SqlParameter("@SumMoney", SqlDbType.Decimal, 9), new SqlParameter("@SumQtyPur", SqlDbType.Int, 4), new SqlParameter("@SumQtyRec", SqlDbType.Int, 4), new SqlParameter("@SumQtySO", SqlDbType.Int, 4), new SqlParameter("@SumQtyCs", SqlDbType.Int, 4), new SqlParameter("@SumQtyRt", SqlDbType.Int, 4), new SqlParameter("@DN", SqlDbType.VarChar, 100), new SqlParameter("@DDate", SqlDbType.DateTime), new SqlParameter("@Rt1", SqlDbType.VarChar, 200), new SqlParameter("@Rt2", SqlDbType.VarChar, 200), new SqlParameter("@Rt3", SqlDbType.VarChar, 200), new SqlParameter("@Rt4", SqlDbType.VarChar, 200), new SqlParameter("@Rt5", SqlDbType.VarChar, 200), new SqlParameter("@RtQR1", SqlDbType.VarChar, 2000), new SqlParameter("@RtQR2", SqlDbType.VarChar, 2000), new SqlParameter("@PdCode", SqlDbType.VarChar, 500), new SqlParameter("@PdName", SqlDbType.VarChar, 500), new SqlParameter("@LensCodeR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeRR", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeL", SqlDbType.VarChar, 50), new SqlParameter("@LensCodeRL", SqlDbType.VarChar, 50), new SqlParameter("@SPHR", SqlDbType.Int, 4), new SqlParameter("@SPHL", SqlDbType.Int, 4), new SqlParameter("@CYLR", SqlDbType.Int, 4), new SqlParameter("@CYLL", SqlDbType.Int, 4), new SqlParameter("@X_ADDR", SqlDbType.Int, 4), new SqlParameter("@X_ADDL", SqlDbType.Int, 4), new SqlParameter("@QtyR", SqlDbType.Int, 4), new SqlParameter("@QtyL", SqlDbType.Int, 4), new SqlParameter("@PriceR", SqlDbType.Decimal, 9), new SqlParameter("@PriceL", SqlDbType.Decimal, 9), new SqlParameter("@ProCostR", SqlDbType.Decimal, 9), new SqlParameter("@ProCostL", SqlDbType.Decimal, 9), new SqlParameter("@SN", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.SumQty; parameters[2].Value = model.SumMoney; parameters[3].Value = model.SumQtyPur; parameters[4].Value = model.SumQtyRec; parameters[5].Value = model.SumQtySO; parameters[6].Value = model.SumQtyCs; parameters[7].Value = model.SumQtyRt; parameters[8].Value = model.DN; parameters[9].Value = System.DBNull.Value;//model.DDate; parameters[10].Value = model.Rt1; parameters[11].Value = model.Rt2; parameters[12].Value = model.Rt3; parameters[13].Value = model.Rt4; parameters[14].Value = model.Rt5; parameters[15].Value = model.RtQR1; parameters[16].Value = model.RtQR2; parameters[17].Value = model.PdCode; parameters[18].Value = model.PdName; parameters[19].Value = model.LensCodeR; parameters[20].Value = model.LensCodeRR; parameters[21].Value = model.LensCodeL; parameters[22].Value = model.LensCodeRL; parameters[23].Value = model.SPHR; parameters[24].Value = model.SPHL; parameters[25].Value = model.CYLR; parameters[26].Value = model.CYLL; parameters[27].Value = model.X_ADDR; parameters[28].Value = model.X_ADDL; parameters[29].Value = model.QtyR; parameters[30].Value = model.QtyL; parameters[31].Value = model.PriceR; parameters[32].Value = model.PriceL; parameters[33].Value = model.ProCostR; parameters[34].Value = model.ProCostL; parameters[35].Value = model.SN; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }