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