protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t) { MSale_Order model = t as MSale_Order; switch (model.MType) { case "L": if (model.F_SD) { this.PrepareSD(lgIndex, cmd, model); } else { this.PreparePD(lgIndex, cmd, model); } break; case "F": this.PrepareFD(lgIndex, cmd, model); break; default: break; } this.PrepareAddExtend(lgIndex, cmd, model); }
private void PreparePD(int lgIndex, SqlCommand cmd, MSale_Order model) { model.Sub_PD.ID = model.ID; _DS.AddSale_Order_PD(lgIndex, cmd, model.Sub_PD); model.Sub_PD_Detail.ForEach(it => it.ID = model.ID); _DS.AddSale_Order_PD_Detail(lgIndex, cmd, model.Sub_PD_Detail); }
public void UpdateSale_Order(int lgIndex, SqlCommand cmd, MSale_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sale_Order set "); strSql.Append("OBCode=@OBCode,"); strSql.Append("UD=@UD,"); strSql.Append("CsDate=@CsDate,"); strSql.Append("CusCode=@CusCode,"); strSql.Append("SpCode=@SpCode,"); strSql.Append("DpCodeWG=@DpCodeWG,"); strSql.Append("WhCode=@WhCode,"); strSql.Append("OGType=@OGType,"); strSql.Append("Notes=@Notes,"); strSql.Append("Remark=@Remark,"); strSql.Append("Freight=@Freight,"); strSql.Append("BarCodePre=@BarCodePre"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@OBCode", SqlDbType.NVarChar, 50), new SqlParameter("@UD", SqlDbType.TinyInt, 1), new SqlParameter("@CsDate", SqlDbType.Date, 3), new SqlParameter("@CusCode", SqlDbType.VarChar, 10), new SqlParameter("@SpCode", SqlDbType.VarChar, 10), new SqlParameter("@DpCodeWG", SqlDbType.VarChar, 10), new SqlParameter("@WhCode", SqlDbType.VarChar, 10), new SqlParameter("@OGType", SqlDbType.TinyInt, 1), new SqlParameter("@Notes", SqlDbType.NVarChar, 200), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@Freight", SqlDbType.Decimal, 9), new SqlParameter("@BarCodePre", SqlDbType.VarChar, 50), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.OBCode; parameters[1].Value = model.UD; parameters[2].Value = model.CsDate; parameters[3].Value = model.CusCode; parameters[4].Value = model.SpCode; parameters[5].Value = model.DpCodeWG; parameters[6].Value = model.WhCode; parameters[7].Value = model.OGType; parameters[8].Value = model.Notes; parameters[9].Value = model.Remark; parameters[10].Value = model.Freight; parameters[11].Value = model.BarCodePre ?? ""; parameters[12].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void UpdateFD(int lgIndex, SqlCommand cmd, MSale_Order model) { StringBuilder strSql = new StringBuilder(); SqlParameter[] parameters = null; strSql.Clear(); strSql.Append("delete Sale_Order_FD_Detail"); strSql.Append(" where ID=@ID "); parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); //////////////////////////////////////////////////////////////////////////////////////////// foreach (var modelFD_Detail in model.Sub_FD_Detail) { strSql.Clear(); strSql.Append("insert into Sale_Order_FD_Detail("); strSql.Append("ID,SubID,FrameCode,Qty,QtyPur,QtyRec,QtySO,QtyCs,QtyRt,Price,DeliveryName)"); strSql.Append(" values ("); strSql.Append("@ID,@SubID,@FrameCode,@Qty,@QtyPur,@QtyRec,@QtySO,@QtyCs,@QtyRt,@Price,@DeliveryName)"); parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@SubID", SqlDbType.Int, 4), new SqlParameter("@FrameCode", SqlDbType.VarChar, 50), new SqlParameter("@Qty", SqlDbType.Int, 4), new SqlParameter("@QtyPur", SqlDbType.Int, 4), new SqlParameter("@QtyRec", SqlDbType.Int, 4), new SqlParameter("@QtySO", SqlDbType.Int, 4), new SqlParameter("@QtyCs", SqlDbType.Int, 4), new SqlParameter("@QtyRt", SqlDbType.Int, 4), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@DeliveryName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = modelFD_Detail.SubID; parameters[2].Value = modelFD_Detail.FrameCode; parameters[3].Value = modelFD_Detail.Qty; parameters[4].Value = modelFD_Detail.QtyPur; parameters[5].Value = modelFD_Detail.QtyRec; parameters[6].Value = modelFD_Detail.QtySO; parameters[7].Value = modelFD_Detail.QtyCs; parameters[8].Value = modelFD_Detail.QtyRt; parameters[9].Value = modelFD_Detail.Price; parameters[10].Value = modelFD_Detail.DeliveryName; cmd.ExecuteMyQuery(strSql.ToString(), parameters); } }
public void UpdateEditSale_Order(int lgIndex, SqlCommand cmd, MSale_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sale_Order set "); strSql.Append("OBCode=@OBCode,"); strSql.Append("Notes=@Notes,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@OBCode", SqlDbType.NVarChar, 50), new SqlParameter("@Notes", SqlDbType.NVarChar, 200), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.OBCode; parameters[1].Value = model.Notes; parameters[2].Value = model.Remark; parameters[3].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void Update(string dbCode, int lgIndex, MSale_Order t) { bll.Update(dbCode, lgIndex, t); }
public string Add(string dbCode, int lgIndex, MSale_Order t) { return(bll.Add(dbCode, lgIndex, t)); }
private void PrepareExtend(MSale_Order model) { model.Sub_Extend = new MSale_Order_Extend() { ID = model.ID, SPHL = 0, SPHR = 0, CYLL = 0, CYLR = 0, X_ADDL = 0, X_ADDR = 0, LensCodeL = "", LensCodeR = "", SumQty = 0, DN = "", LensCodeRL = "", LensCodeRR = "", PdCode = "", PdName = "", Rt1 = "", Rt2 = "", Rt3 = "", Rt4 = "", Rt5 = "", SumMoney = 0, SumQtyCs = 0, SumQtyPur = 0, SumQtyRec = 0, SumQtyRt = 0, SumQtySO = 0, QtyR = 0, QtyL = 0, RtQR1 = "", RtQR2 = "", PriceL = 0, PriceR = 0, ProCostL = 0, ProCostR = 0, SN = "", }; switch (model.MType) { case "L": if (model.F_SD) { model.Sub_Extend.SPHR = model.Sub_SD[0].SPH; model.Sub_Extend.SPHL = model.Sub_SD[1].SPH; model.Sub_Extend.CYLR = model.Sub_SD[0].CYL; model.Sub_Extend.CYLL = model.Sub_SD[1].CYL; model.Sub_Extend.X_ADDR = model.Sub_SD[0].X_ADD; model.Sub_Extend.X_ADDL = model.Sub_SD[1].X_ADD; model.Sub_Extend.LensCodeR = model.Sub_SD[0].LensCode; model.Sub_Extend.LensCodeL = model.Sub_SD[1].LensCode; model.Sub_Extend.LensCodeRR = model.Sub_SD[0].LensCodeR; model.Sub_Extend.LensCodeRL = model.Sub_SD[1].LensCodeR; model.Sub_Extend.QtyR = model.Sub_SD[0].Qty; model.Sub_Extend.QtyL = model.Sub_SD[1].Qty; model.Sub_Extend.PriceR = model.Sub_SD[0].Price; model.Sub_Extend.PriceL = model.Sub_SD[1].Price; model.Sub_Extend.ProCostR = model.Sub_SD[0].ProCost; model.Sub_Extend.ProCostL = model.Sub_SD[1].ProCost; model.Sub_Extend.SumQty = model.Sub_SD[0].Qty + model.Sub_SD[1].Qty; } else { model.Sub_Extend.LensCodeR = model.Sub_PD.LensCode; model.Sub_Extend.LensCodeL = model.Sub_PD.LensCode; model.Sub_Extend.SumQty = model.Sub_PD_Detail.Sum(it => it.Qty); } break; default: break; } }
private void PrepareAddExtend(int lgIndex, SqlCommand cmd, MSale_Order model) { this.PrepareExtend(model); _DS.AddSale_Order_Extend(lgIndex, cmd, model.Sub_Extend); }
private void UpdateSD(int lgIndex, SqlCommand cmd, MSale_Order model) { _DS.UpdateSale_Order_SD(lgIndex, cmd, model.Sub_SD); _DS.UpdateSale_Order_SD_Process(lgIndex, cmd, model.Sub_SD_Process); //StringBuilder strSql = new StringBuilder(); //SqlParameter[] parameters = null; //foreach (var modelSD in model.Sub_SD) //{ // strSql.Clear(); // strSql.Append("update Sale_Order_SD set "); // strSql.Append("Dia=@Dia,"); // strSql.Append("LensCode=@LensCode,"); // strSql.Append("LensCodeR=@LensCodeR,"); // strSql.Append("SPH=@SPH,"); // strSql.Append("CYL=@CYL,"); // strSql.Append("Axis=@Axis,"); // strSql.Append("X_ADD=@X_ADD,"); // strSql.Append("Qty=@Qty,"); // strSql.Append("BASE=@BASE,"); // strSql.Append("CT=@CT,"); // strSql.Append("DB=@DB,"); // strSql.Append("D1=@D1,"); // strSql.Append("D2=@D2,"); // strSql.Append("D3=@D3,"); // strSql.Append("D4=@D4,"); // strSql.Append("P1=@P1,"); // strSql.Append("P2=@P2,"); // strSql.Append("P3=@P3,"); // strSql.Append("P4=@P4"); // strSql.Append(" where ID=@ID and F_LR=@F_LR "); // parameters = new SqlParameter[] { // new SqlParameter("@Dia", SqlDbType.Int,4), // new SqlParameter("@LensCode", SqlDbType.VarChar,50), // new SqlParameter("@LensCodeR", SqlDbType.VarChar,50), // new SqlParameter("@SPH", SqlDbType.Int,4), // new SqlParameter("@CYL", SqlDbType.Int,4), // new SqlParameter("@Axis", SqlDbType.Int,4), // new SqlParameter("@X_ADD", SqlDbType.Int,4), // new SqlParameter("@Qty", SqlDbType.Int,4), // new SqlParameter("@BASE", SqlDbType.VarChar,10), // new SqlParameter("@CT", SqlDbType.VarChar,10), // new SqlParameter("@DB", SqlDbType.Bit,1), // new SqlParameter("@D1", SqlDbType.VarChar,10), // new SqlParameter("@D2", SqlDbType.VarChar,10), // new SqlParameter("@D3", SqlDbType.VarChar,10), // new SqlParameter("@D4", SqlDbType.VarChar,10), // new SqlParameter("@P1", SqlDbType.VarChar,10), // new SqlParameter("@P2", SqlDbType.VarChar,10), // new SqlParameter("@P3", SqlDbType.VarChar,10), // new SqlParameter("@P4", SqlDbType.VarChar,10), // new SqlParameter("@ID", SqlDbType.VarChar,25), // new SqlParameter("@F_LR", SqlDbType.VarChar,1)}; // parameters[0].Value = modelSD.Dia; // parameters[1].Value = modelSD.LensCode; // parameters[2].Value = modelSD.LensCodeR; // parameters[3].Value = modelSD.SPH; // parameters[4].Value = modelSD.CYL; // parameters[5].Value = modelSD.Axis; // parameters[6].Value = modelSD.X_ADD; // parameters[7].Value = modelSD.Qty; // parameters[8].Value = modelSD.BASE; // parameters[9].Value = modelSD.CT; // parameters[10].Value = modelSD.DB; // parameters[11].Value = modelSD.D1; // parameters[12].Value = modelSD.D2; // parameters[13].Value = modelSD.D3; // parameters[14].Value = modelSD.D4; // parameters[15].Value = modelSD.P1; // parameters[16].Value = modelSD.P2; // parameters[17].Value = modelSD.P3; // parameters[18].Value = modelSD.P4; // parameters[19].Value = model.ID; // parameters[20].Value = modelSD.F_LR; // cmd.ExecuteMyQuery(strSql.ToString(), parameters); //} ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //var modelSDProcess = model.Sub_SD_Process; //strSql.Clear(); //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 "); //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 = modelSDProcess.F_CusLens; //parameters[1].Value = modelSDProcess.CXType; //parameters[2].Value = modelSDProcess.PD; //parameters[3].Value = modelSDProcess.PH; //parameters[4].Value = modelSDProcess.JY; //parameters[5].Value = modelSDProcess.UV; //parameters[6].Value = modelSDProcess.JS; //parameters[7].Value = modelSDProcess.RS; //parameters[8].Value = modelSDProcess.RSName; //parameters[9].Value = modelSDProcess.CS; //parameters[10].Value = modelSDProcess.SY; //parameters[11].Value = modelSDProcess.CB; //parameters[12].Value = modelSDProcess.ChB; //parameters[13].Value = modelSDProcess.KK; //parameters[14].Value = modelSDProcess.ZK; //parameters[15].Value = modelSDProcess.PiH; //parameters[16].Value = modelSDProcess.PG; //parameters[17].Value = modelSDProcess.JJ; //parameters[18].Value = modelSDProcess.OP; //parameters[19].Value = modelSDProcess.DpCodeJG; //parameters[20].Value = model.ID; //cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void UpdatePD(int lgIndex, SqlCommand cmd, MSale_Order model) { _DS.UpdateSale_Order_PD(lgIndex, cmd, model.Sub_PD); _DS.UpdateSale_Order_PD_Detail(lgIndex, cmd, model.Sub_PD_Detail); //StringBuilder strSql = new StringBuilder(); //SqlParameter[] parameters = null; //var modelPD = model.Sub_PD; //strSql.Append("update Sale_Order_PD set "); //strSql.Append("F_LR=@F_LR,"); //strSql.Append("LensCode=@LensCode,"); //strSql.Append("LensCodeR=@LensCodeR"); //strSql.Append(" where ID=@ID "); //parameters = new SqlParameter[] { // new SqlParameter("@F_LR", SqlDbType.VarChar,1), // new SqlParameter("@LensCode", SqlDbType.NVarChar,50), // new SqlParameter("@LensCodeR", SqlDbType.NVarChar,50), // new SqlParameter("@ID", SqlDbType.VarChar,25)}; //parameters[0].Value = modelPD.F_LR; //parameters[1].Value = modelPD.LensCode; //parameters[2].Value = modelPD.LensCodeR; //parameters[3].Value = model.ID; //cmd.ExecuteMyQuery(strSql.ToString(), parameters); ///////////////////////////////////////////////////////////////////////////////////////// //strSql.Clear(); //strSql.Append("delete Sale_Order_PD_Detail"); //strSql.Append(" where ID=@ID "); //parameters = new SqlParameter[] { // new SqlParameter("@ID", SqlDbType.VarChar,25)}; //parameters[0].Value = model.ID; //cmd.ExecuteMyQuery(strSql.ToString(), parameters); ////////////////////////////////////////////////////////////////////////////////////////////// //foreach (var modelPD_Detail in model.Sub_PD_Detail) //{ // strSql.Clear(); // strSql.Append("insert into Sale_Order_PD_Detail("); // strSql.Append("ID,SubID,SPH,CYL,X_ADD,Qty,QtyPur,QtyRec,QtySO,QtyCs,QtyRt,Price)"); // strSql.Append(" values ("); // strSql.Append("@ID,@SubID,@SPH,@CYL,@X_ADD,@Qty,@QtyPur,@QtyRec,@QtySO,@QtyCs,@QtyRt,@Price)"); // parameters = new SqlParameter[] { // new SqlParameter("@ID", SqlDbType.VarChar,25), // new SqlParameter("@SubID", SqlDbType.Int,4), // new SqlParameter("@SPH", SqlDbType.Int,4), // new SqlParameter("@CYL", SqlDbType.Int,4), // new SqlParameter("@X_ADD", SqlDbType.Int,4), // new SqlParameter("@Qty", SqlDbType.Int,4), // new SqlParameter("@QtyPur", SqlDbType.Int,4), // new SqlParameter("@QtyRec", SqlDbType.Int,4), // new SqlParameter("@QtySO", SqlDbType.Int,4), // new SqlParameter("@QtyCs", SqlDbType.Int,4), // new SqlParameter("@QtyRt", SqlDbType.Int,4), // new SqlParameter("@Price", SqlDbType.Decimal,9)}; // parameters[0].Value = model.ID; // parameters[1].Value = modelPD_Detail.SubID; // parameters[2].Value = modelPD_Detail.SPH; // parameters[3].Value = modelPD_Detail.CYL; // parameters[4].Value = modelPD_Detail.X_ADD; // parameters[5].Value = modelPD_Detail.Qty; // parameters[6].Value = modelPD_Detail.QtyPur; // parameters[7].Value = modelPD_Detail.QtyRec; // parameters[8].Value = modelPD_Detail.QtySO; // parameters[9].Value = modelPD_Detail.QtyCs; // parameters[10].Value = modelPD_Detail.QtyRt; // parameters[11].Value = modelPD_Detail.Price; // cmd.ExecuteMyQuery(strSql.ToString(), parameters); //} }
private void UpdateExtend(int lgIndex, SqlCommand cmd, MSale_Order model) { this.PrepareExtend(model); _DS.UpdateSale_Order_Extend(lgIndex, cmd, model.Sub_Extend); //MSale_Order_Extend model_Extend = model.Sub_Extend; //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("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(" 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("@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("@ID", SqlDbType.VarChar,25)}; //parameters[0].Value = model_Extend.SumQty; //parameters[1].Value = model_Extend.SumMoney; //parameters[2].Value = model_Extend.SumQtyPur; //parameters[3].Value = model_Extend.SumQtyRec; //parameters[4].Value = model_Extend.SumQtySO; //parameters[5].Value = model_Extend.SumQtyCs; //parameters[6].Value = model_Extend.SumQtyRt; //parameters[7].Value = model_Extend.DN; //parameters[8].Value = System.DBNull.Value;//model_Extend.DDate; //parameters[9].Value = model_Extend.Rt1; //parameters[10].Value = model_Extend.Rt2; //parameters[11].Value = model_Extend.Rt3; //parameters[12].Value = model_Extend.Rt4; //parameters[13].Value = model_Extend.Rt5; //parameters[14].Value = model_Extend.PdCode; //parameters[15].Value = model_Extend.PdName; //parameters[16].Value = model_Extend.LensCodeR; //parameters[17].Value = model_Extend.LensCodeRR; //parameters[18].Value = model_Extend.LensCodeL; //parameters[19].Value = model_Extend.LensCodeRL; //parameters[20].Value = model_Extend.SPHR; //parameters[21].Value = model_Extend.SPHL; //parameters[22].Value = model_Extend.CYLR; //parameters[23].Value = model_Extend.CYLL; //parameters[24].Value = model_Extend.X_ADDR; //parameters[25].Value = model_Extend.X_ADDL; //parameters[26].Value = model.ID; //cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t) { MSale_Order model = t as MSale_Order; _DS.AddSale_Order(lgIndex, cmd, model); }
private void PrepareSD(int lgIndex, SqlCommand cmd, MSale_Order model) { model.Sub_SD.ForEach(it => it.ID = model.ID); _DS.AddSale_Order_SD(lgIndex, cmd, model.Sub_SD); model.Sub_SD_Process.ID = model.ID; _DS.AddSale_Order_SD_Process(lgIndex, cmd, model.Sub_SD_Process); //StringBuilder strSql = new StringBuilder(); //SqlParameter[] parameters = null; //foreach (var modelSD in model.Sub_SD) //{ // strSql.Clear(); // strSql.Append("insert into Sale_Order_SD("); // strSql.Append("ID,F_LR,Dia,LensCode,LensCodeR,SPH,CYL,Axis,X_ADD,Qty,BASE,CT,DB,D1,D2,D3,D4,P1,P2,P3,P4,QtyPur,QtyRec,QtySO,QtyCs,QtyRt,Price,ProCost,InvTitle,ProReport,ProCostReport)"); // strSql.Append(" values ("); // strSql.Append("@ID,@F_LR,@Dia,@LensCode,@LensCodeR,@SPH,@CYL,@Axis,@X_ADD,@Qty,@BASE,@CT,@DB,@D1,@D2,@D3,@D4,@P1,@P2,@P3,@P4,@QtyPur,@QtyRec,@QtySO,@QtyCs,@QtyRt,@Price,@ProCost,@InvTitle,@ProReport,@ProCostReport)"); // parameters = new SqlParameter[] { // new SqlParameter("@ID", SqlDbType.VarChar,25), // new SqlParameter("@F_LR", SqlDbType.VarChar,1), // new SqlParameter("@Dia", SqlDbType.Int,4), // new SqlParameter("@LensCode", SqlDbType.VarChar,50), // new SqlParameter("@LensCodeR", SqlDbType.VarChar,50), // new SqlParameter("@SPH", SqlDbType.Int,4), // new SqlParameter("@CYL", SqlDbType.Int,4), // new SqlParameter("@Axis", SqlDbType.Int,4), // new SqlParameter("@X_ADD", SqlDbType.Int,4), // new SqlParameter("@Qty", SqlDbType.Int,4), // new SqlParameter("@BASE", SqlDbType.VarChar,10), // new SqlParameter("@CT", SqlDbType.VarChar,10), // new SqlParameter("@DB", SqlDbType.Bit,1), // new SqlParameter("@D1", SqlDbType.VarChar,10), // new SqlParameter("@D2", SqlDbType.VarChar,10), // new SqlParameter("@D3", SqlDbType.VarChar,10), // new SqlParameter("@D4", SqlDbType.VarChar,10), // new SqlParameter("@P1", SqlDbType.VarChar,10), // new SqlParameter("@P2", SqlDbType.VarChar,10), // new SqlParameter("@P3", SqlDbType.VarChar,10), // new SqlParameter("@P4", SqlDbType.VarChar,10), // new SqlParameter("@QtyPur", SqlDbType.Int,4), // new SqlParameter("@QtyRec", SqlDbType.Int,4), // new SqlParameter("@QtySO", SqlDbType.Int,4), // new SqlParameter("@QtyCs", SqlDbType.Int,4), // new SqlParameter("@QtyRt", SqlDbType.Int,4), // new SqlParameter("@Price", SqlDbType.Decimal,9), // new SqlParameter("@ProCost", SqlDbType.Decimal,9), // new SqlParameter("@InvTitle", SqlDbType.NVarChar,100), // new SqlParameter("@ProReport", SqlDbType.NVarChar,200), // new SqlParameter("@ProCostReport", SqlDbType.NVarChar,200)}; // parameters[0].Value = model.ID; // parameters[1].Value = modelSD.F_LR; // parameters[2].Value = modelSD.Dia; // parameters[3].Value = modelSD.LensCode; // parameters[4].Value = modelSD.LensCodeR; // parameters[5].Value = modelSD.SPH; // parameters[6].Value = modelSD.CYL; // parameters[7].Value = modelSD.Axis; // parameters[8].Value = modelSD.X_ADD; // parameters[9].Value = modelSD.Qty; // parameters[10].Value = modelSD.BASE; // parameters[11].Value = modelSD.CT; // parameters[12].Value = modelSD.DB; // parameters[13].Value = modelSD.D1; // parameters[14].Value = modelSD.D2; // parameters[15].Value = modelSD.D3; // parameters[16].Value = modelSD.D4; // parameters[17].Value = modelSD.P1; // parameters[18].Value = modelSD.P2; // parameters[19].Value = modelSD.P3; // parameters[20].Value = modelSD.P4; // parameters[21].Value = modelSD.QtyPur; // parameters[22].Value = modelSD.QtyRec; // parameters[23].Value = modelSD.QtySO; // parameters[24].Value = modelSD.QtyCs; // parameters[25].Value = modelSD.QtyRt; // parameters[26].Value = modelSD.Price; // parameters[27].Value = modelSD.ProCost; // parameters[28].Value = modelSD.InvTitle; // parameters[29].Value = modelSD.ProReport; // parameters[30].Value = modelSD.ProCostReport; // cmd.ExecuteMyQuery(strSql.ToString(), parameters); //} /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //var modelSDProcess = model.Sub_SD_Process; //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 = modelSDProcess.F_CusLens; //parameters[2].Value = modelSDProcess.CXType; //parameters[3].Value = modelSDProcess.PD; //parameters[4].Value = modelSDProcess.PH; //parameters[5].Value = modelSDProcess.JY; //parameters[6].Value = modelSDProcess.UV; //parameters[7].Value = modelSDProcess.JS; //parameters[8].Value = modelSDProcess.RS; //parameters[9].Value = modelSDProcess.RSName; //parameters[10].Value = modelSDProcess.CS; //parameters[11].Value = modelSDProcess.SY; //parameters[12].Value = modelSDProcess.CB; //parameters[13].Value = modelSDProcess.ChB; //parameters[14].Value = modelSDProcess.KK; //parameters[15].Value = modelSDProcess.ZK; //parameters[16].Value = modelSDProcess.PiH; //parameters[17].Value = modelSDProcess.PG; //parameters[18].Value = modelSDProcess.JJ; //parameters[19].Value = modelSDProcess.OP; //parameters[20].Value = modelSDProcess.DpCodeJG; //cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void AddSale_Order(int lgIndex, SqlCommand cmd, MSale_Order model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sale_Order("); strSql.Append("ID,BCode,BDate,OBCode,FBCode,UD,CsDate,BType,MType,F_SD,F_FS,CusCode,OGType,WhCode,SpCode,DpCodeWG,Notes,Remark,Freight,Maker,MName,BarCodePre)"); strSql.Append(" values ("); strSql.Append("@ID,@BCode,@BDate,@OBCode,@FBCode,@UD,@CsDate,@BType,@MType,@F_SD,@F_FS,@CusCode,@OGType,@WhCode,@SpCode,@DpCodeWG,@Notes,@Remark,@Freight,@Maker,@MName,@BarCodePre)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@BCode", SqlDbType.VarChar, 25), new SqlParameter("@BDate", SqlDbType.Date, 3), new SqlParameter("@OBCode", SqlDbType.NVarChar, 50), new SqlParameter("@FBCode", SqlDbType.VarChar, 50), new SqlParameter("@UD", SqlDbType.TinyInt, 1), new SqlParameter("@CsDate", SqlDbType.Date, 3), new SqlParameter("@BType", SqlDbType.VarChar, 6), new SqlParameter("@MType", SqlDbType.VarChar, 10), new SqlParameter("@F_SD", SqlDbType.Bit, 1), new SqlParameter("@F_FS", SqlDbType.Bit, 1), new SqlParameter("@CusCode", SqlDbType.VarChar, 10), new SqlParameter("@OGType", SqlDbType.TinyInt, 1), new SqlParameter("@WhCode", SqlDbType.VarChar, 10), new SqlParameter("@SpCode", SqlDbType.VarChar, 10), new SqlParameter("@DpCodeWG", SqlDbType.VarChar, 10), new SqlParameter("@Notes", SqlDbType.NVarChar, 200), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@Freight", SqlDbType.Decimal, 9), new SqlParameter("@Maker", SqlDbType.VarChar, 10), new SqlParameter("@MName", SqlDbType.NVarChar, 30), new SqlParameter("@BarCodePre", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.BCode; parameters[2].Value = model.BDate; parameters[3].Value = model.OBCode; parameters[4].Value = model.FBCode; parameters[5].Value = model.UD; parameters[6].Value = model.CsDate; parameters[7].Value = model.BType; parameters[8].Value = model.MType; parameters[9].Value = model.F_SD; parameters[10].Value = model.F_FS; parameters[11].Value = model.CusCode; parameters[12].Value = model.OGType; parameters[13].Value = model.WhCode; parameters[14].Value = model.SpCode; parameters[15].Value = model.DpCodeWG; parameters[16].Value = model.Notes; parameters[17].Value = model.Remark; parameters[18].Value = model.Freight; parameters[19].Value = model.Maker; parameters[20].Value = model.MName; parameters[21].Value = model.BarCodePre ?? ""; cmd.ExecuteMyQuery(strSql.ToString(), parameters); //Addtional strSql.Clear(); strSql.Append("insert into Sale_Order_ADD("); strSql.Append("ID,StCode,BCodeKFSO,BCodeCGDD,BCodePC,MDate,Checker,ChName,ChDate,Deler,DelName,DelDate,Closer,ClName,ClDate)"); strSql.Append(" values ("); strSql.Append("@ID,@StCode,@BCodeKFSO,@BCodeCGDD,@BCodePC,@MDate,@Checker,@ChName,@ChDate,@Deler,@DelName,@DelDate,@Closer,@ClName,@ClDate)"); parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@StCode", SqlDbType.VarChar, 6), new SqlParameter("@BCodeKFSO", SqlDbType.VarChar, 25), new SqlParameter("@BCodeCGDD", SqlDbType.VarChar, 25), new SqlParameter("@BCodePC", SqlDbType.VarChar, 25), new SqlParameter("@MDate", SqlDbType.DateTime), new SqlParameter("@Checker", SqlDbType.VarChar, 10), new SqlParameter("@ChName", SqlDbType.NVarChar, 30), new SqlParameter("@ChDate", SqlDbType.DateTime), new SqlParameter("@Deler", SqlDbType.VarChar, 10), new SqlParameter("@DelName", SqlDbType.NVarChar, 30), new SqlParameter("@DelDate", SqlDbType.DateTime), new SqlParameter("@Closer", SqlDbType.VarChar, 10), new SqlParameter("@ClName", SqlDbType.NVarChar, 30), new SqlParameter("@ClDate", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = "DSH"; parameters[2].Value = ""; // model.BCodeKFSO; parameters[3].Value = ""; //model.BCodeCGDD; parameters[4].Value = ""; //model.BCodePC; parameters[5].Value = System.DateTime.Now; //model.MDate; parameters[6].Value = ""; // model.Checker; parameters[7].Value = ""; //model.ChName; parameters[8].Value = System.DBNull.Value; // model.ChDate; parameters[9].Value = ""; // model.Deler; parameters[10].Value = ""; //model.DelName; parameters[11].Value = System.DBNull.Value; // model.DelDate; parameters[12].Value = ""; // model.Closer; parameters[13].Value = ""; // model.ClName; parameters[14].Value = System.DBNull.Value; //model.ClDate; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }