private static DbHelperCmdObject PrePareOrdConet(OrdConet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Conet(");
strSql.Append("ID,BCode1,BCode2,F_Read,F_Confirm,F_Shipping,F_Reject,F_Err_Convert)");
strSql.Append(" values (");
strSql.Append("@ID,@BCode1,@BCode2,@F_Read,@F_Confirm,@F_Shipping,@F_Reject,@F_Err_Convert)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BCode1", SqlDbType.VarChar, 50),
new SqlParameter("@BCode2", SqlDbType.VarChar, 30),
new SqlParameter("@F_Read", SqlDbType.Bit, 1),
new SqlParameter("@F_Confirm", SqlDbType.Bit, 1),
new SqlParameter("@F_Shipping", SqlDbType.Int, 4),
new SqlParameter("@F_Reject", SqlDbType.Bit, 1),
new SqlParameter("@F_Err_Convert", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BCode1;
parameters[2].Value = model.BCode2;
parameters[3].Value = model.F_Read;
parameters[4].Value = model.F_Confirm;
parameters[5].Value = model.F_Shipping;
parameters[6].Value = model.F_Reject;
parameters[7].Value = model.F_Err_Convert;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
public static void DeleteOrdErr(string id)
{
DbHelperSQL dbHelper = new DbHelperSQL(JinsPub.DbName);
List <DbHelperCmdObject> cmdObjec = new List <DbHelperCmdObject>();
DbHelperCmdObject obj = null;
//
obj = PrePareOrdDeleteErr(id);
cmdObjec.Add(obj);
//
dbHelper.ExecuteCmdObjectTran(cmdObjec);
}
private static DbHelperCmdObject PrePareOrdDeleteErr(string ordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SP_JinsOrd_DeleteOrdErr");
SqlParameter[] parameters =
{
new SqlParameter("@OrdID", SqlDbType.VarChar, 50)
};
parameters[0].Value = ordID;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters, CommandType.StoredProcedure);
return(obj);
}
private static DbHelperCmdObject PrePareOrdSaveVerify(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SP_JinsOrd_SaveVerify");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25)
};
parameters[0].Value = id;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters, CommandType.StoredProcedure);
return(obj);
}
private static DbHelperCmdObject PrePareOrdZ(OrdZ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Ord_Z(");
strSql.Append("ID,BillCode,BillDate,ConsignDate,CusCode,Remark,Notes,BillType,OBillCode,MR,QtyR,ML,QtyL,SumQty)");
strSql.Append(" values (");
strSql.Append("@ID,@BillCode,@BillDate,@ConsignDate,@CusCode,@Remark,@Notes,@BillType,@OBillCode,@MR,@QtyR,@ML,@QtyL,@SumQty)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BillCode", SqlDbType.NVarChar, 30),
new SqlParameter("@BillDate", SqlDbType.Date, 3),
new SqlParameter("@ConsignDate", SqlDbType.Date, 3),
new SqlParameter("@CusCode", SqlDbType.NVarChar, 10),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@Notes", SqlDbType.NVarChar, 200),
new SqlParameter("@BillType", SqlDbType.NVarChar, 10),
new SqlParameter("@OBillCode", SqlDbType.NVarChar, 30),
new SqlParameter("@MR", SqlDbType.NVarChar, 30),
new SqlParameter("@QtyR", SqlDbType.Int, 4),
new SqlParameter("@ML", SqlDbType.NVarChar, 30),
new SqlParameter("@QtyL", SqlDbType.Int, 4),
new SqlParameter("@SumQty", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BillCode;
parameters[2].Value = model.BillDate;
parameters[3].Value = model.ConsignDate;
parameters[4].Value = model.CusCode;
parameters[5].Value = model.Remark;
parameters[6].Value = model.Notes;
parameters[7].Value = model.BillType;
parameters[8].Value = model.OBillCode;
parameters[9].Value = model.MR;
parameters[10].Value = model.QtyR;
parameters[11].Value = model.ML;
parameters[12].Value = model.QtyL;
parameters[13].Value = model.SumQty;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
private static DbHelperCmdObject PrePareOrdMain(OrdMain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Ord_Main(");
strSql.Append("ID,OrdID,OrdHdID,OrdType,Address1,Postal,Tel,Memo,Created,SalesOfficeCode,SalesOfficeName,Procurement_Type)");
strSql.Append(" values (");
strSql.Append("@ID,@OrdID,@OrdHdID,@OrdType,@Address1,@Postal,@Tel,@Memo,@Created,@SalesOfficeCode,@SalesOfficeName,@Procurement_Type)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@OrdID", SqlDbType.VarChar, 50),
new SqlParameter("@OrdHdID", SqlDbType.VarChar, 10),
new SqlParameter("@OrdType", SqlDbType.VarChar, 10),
new SqlParameter("@Address1", SqlDbType.VarChar, 100),
new SqlParameter("@Postal", SqlDbType.VarChar, 10),
new SqlParameter("@Tel", SqlDbType.VarChar, 20),
new SqlParameter("@Memo", SqlDbType.VarChar, 200),
new SqlParameter("@Created", SqlDbType.DateTime),
new SqlParameter("@SalesOfficeCode", SqlDbType.VarChar, 10),
new SqlParameter("@SalesOfficeName", SqlDbType.VarChar, 100),
new SqlParameter("@Procurement_Type", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.OrdID;
parameters[2].Value = model.OrdHdID;
parameters[3].Value = model.OrdType;
parameters[4].Value = model.Address1;
parameters[5].Value = model.Postal;
parameters[6].Value = model.Tel;
parameters[7].Value = model.Memo;
parameters[8].Value = model.Created;
parameters[9].Value = model.SalesOfficeCode;
parameters[10].Value = model.SalesOfficeName;
parameters[11].Value = model.Procurement_Type;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
public static void AddOrdErr(OrdMain model)
{
DbHelperSQL dbHelper = new DbHelperSQL(JinsPub.DbName);
List <DbHelperCmdObject> cmdObjec = new List <DbHelperCmdObject>();
DbHelperCmdObject obj = null;
//
model.ID = JinsPub.ID25;
//
obj = PrePareOrdMain(model);
cmdObjec.Add(obj);
//
model.SubZ.ID = model.ID;
obj = PrePareOrdZ(model.SubZ);
cmdObjec.Add(obj);
//
model.SubConet.ID = JinsPub.ID25;
obj = PrePareOrdConet(model.SubConet);
cmdObjec.Add(obj);
//
dbHelper.ExecuteCmdObjectTran(cmdObjec);
}
public static void AddOrd(OrdMain model)
{
DbHelperSQL dbHelper = new DbHelperSQL(JinsPub.DbName);
List <DbHelperCmdObject> cmdObjec = new List <DbHelperCmdObject>();
DbHelperCmdObject obj = null;
//
model.ID = JinsPub.ID25;
//
obj = PrePareOrdMain(model);
cmdObjec.Add(obj);
if (model.OrdType.ToLower() == "rx")
{
model.SubRX.ID = model.ID;
obj = PrePareOrdRX(model.SubRX);
cmdObjec.Add(obj);
}
else
{
foreach (var item in model.SubST)
{
item.ID = model.ID;
obj = PrePareOrdST(item);
cmdObjec.Add(obj);
}
}
model.SubZ.ID = model.ID;
obj = PrePareOrdZ(model.SubZ);
cmdObjec.Add(obj);
model.SubZMain.ID = model.ID;
obj = PrePareOrdZMain(model.SubZMain);
cmdObjec.Add(obj);
//
obj = PrePareOrdSaveVerify(model.ID);
cmdObjec.Add(obj);
dbHelper.ExecuteCmdObjectTran(cmdObjec);
}
private static DbHelperCmdObject PrePareOrdST(OrdST model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Ord_ST(");
strSql.Append("ID,SubID,OPC,Qty)");
strSql.Append(" values (");
strSql.Append("@ID,@SubID,@OPC,@Qty)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@OPC", SqlDbType.VarChar, 50),
new SqlParameter("@Qty", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.SubID;
parameters[2].Value = model.OPC;
parameters[3].Value = model.Qty;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
private static DbHelperCmdObject PrePareOrdRX(OrdRX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Ord_RX(");
strSql.Append("ID,SpecialRight1,SpecialRight2,SpecialRight3,SpecialRight4,SpecialLeft1,SpecialLeft2,SpecialLeft3,SpecialLeft4,Lens_Type,Tint_Type,Tint,Polarized,Mirrored,Oculus_Dexter_Sphere,Oculus_Sinister_Sphere,Oculus_Dexter_Cylinder,Oculus_Sinister_Cylinder,Oculus_Dexter_Axis,Oculus_Sinister_Axis,Oculus_Dexter_Add,Oculus_Sinister_Add,Oculus_Dexter_Diameter,Oculus_Sinister_Diameter,Oculus_Dexter_Quantity,Oculus_Sinister_Quantity,Frame_Code,Polishing,Oculus_Eye_Point,Oculus_Dexter_Pupillary_Distance,Oculus_Sinister_Pupillary_Distance)");
strSql.Append(" values (");
strSql.Append("@ID,@SpecialRight1,@SpecialRight2,@SpecialRight3,@SpecialRight4,@SpecialLeft1,@SpecialLeft2,@SpecialLeft3,@SpecialLeft4,@Lens_Type,@Tint_Type,@Tint,@Polarized,@Mirrored,@Oculus_Dexter_Sphere,@Oculus_Sinister_Sphere,@Oculus_Dexter_Cylinder,@Oculus_Sinister_Cylinder,@Oculus_Dexter_Axis,@Oculus_Sinister_Axis,@Oculus_Dexter_Add,@Oculus_Sinister_Add,@Oculus_Dexter_Diameter,@Oculus_Sinister_Diameter,@Oculus_Dexter_Quantity,@Oculus_Sinister_Quantity,@Frame_Code,@Polishing,@Oculus_Eye_Point,@Oculus_Dexter_Pupillary_Distance,@Oculus_Sinister_Pupillary_Distance)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@SpecialRight1", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialRight2", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialRight3", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialRight4", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialLeft1", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialLeft2", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialLeft3", SqlDbType.VarChar, 20),
new SqlParameter("@SpecialLeft4", SqlDbType.VarChar, 20),
new SqlParameter("@Lens_Type", SqlDbType.VarChar, 30),
new SqlParameter("@Tint_Type", SqlDbType.VarChar, 30),
new SqlParameter("@Tint", SqlDbType.VarChar, 30),
new SqlParameter("@Polarized", SqlDbType.VarChar, 30),
new SqlParameter("@Mirrored", SqlDbType.VarChar, 30),
new SqlParameter("@Oculus_Dexter_Sphere", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Sinister_Sphere", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Dexter_Cylinder", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Sinister_Cylinder", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Dexter_Axis", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Sinister_Axis", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Dexter_Add", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Sinister_Add", SqlDbType.Decimal, 5),
new SqlParameter("@Oculus_Dexter_Diameter", SqlDbType.Int, 4),
new SqlParameter("@Oculus_Sinister_Diameter", SqlDbType.Int, 4),
new SqlParameter("@Oculus_Dexter_Quantity", SqlDbType.Int, 4),
new SqlParameter("@Oculus_Sinister_Quantity", SqlDbType.Int, 4),
new SqlParameter("@Frame_Code", SqlDbType.NVarChar, 30),
new SqlParameter("@Polishing", SqlDbType.NVarChar, 30),
new SqlParameter("@Oculus_Eye_Point", SqlDbType.NVarChar, 30),
new SqlParameter("@Oculus_Dexter_Pupillary_Distance", SqlDbType.NVarChar, 30),
new SqlParameter("@Oculus_Sinister_Pupillary_Distance", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.SpecialRight1;
parameters[2].Value = model.SpecialRight2;
parameters[3].Value = model.SpecialRight3;
parameters[4].Value = model.SpecialRight4;
parameters[5].Value = model.SpecialLeft1;
parameters[6].Value = model.SpecialLeft2;
parameters[7].Value = model.SpecialLeft3;
parameters[8].Value = model.SpecialLeft4;
parameters[9].Value = model.Lens_Type;
parameters[10].Value = model.Tint_Type;
parameters[11].Value = model.Tint;
parameters[12].Value = model.Polarized;
parameters[13].Value = model.Mirrored;
parameters[14].Value = model.Oculus_Dexter_Sphere;
parameters[15].Value = model.Oculus_Sinister_Sphere;
parameters[16].Value = model.Oculus_Dexter_Cylinder;
parameters[17].Value = model.Oculus_Sinister_Cylinder;
parameters[18].Value = model.Oculus_Dexter_Axis;
parameters[19].Value = model.Oculus_Sinister_Axis;
parameters[20].Value = model.Oculus_Dexter_Add;
parameters[21].Value = model.Oculus_Sinister_Add;
parameters[22].Value = model.Oculus_Dexter_Diameter;
parameters[23].Value = model.Oculus_Sinister_Diameter;
parameters[24].Value = model.Oculus_Dexter_Quantity;
parameters[25].Value = model.Oculus_Sinister_Quantity;
parameters[26].Value = model.Frame_Code;
parameters[27].Value = model.Polishing;
parameters[28].Value = model.Oculus_Eye_Point;
parameters[29].Value = model.Oculus_Dexter_Pupillary_Distance;
parameters[30].Value = model.Oculus_Sinister_Pupillary_Distance;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
private static DbHelperCmdObject PrePareOrdZMain(OrdZMain model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Jins_Ord_Z_Main(");
strSql.Append("ID,BillCode,CusCode,Remark,Notes,PD,OBillCode,Flag_CX,AxisR,Center_ThicknessR,CYLR,DaoBianR,Decenter1R,Decenter2R,Decenter3R,Decenter4R,DiameterR,MianWanR,MnumberR,Prism1R,Prism2R,Prism3R,Prism4R,QuantityR,SPHR,X_ADDR,AxisL,Center_ThicknessL,CYLL,DaoBianL,Decenter1L,Decenter2L,Decenter3L,Decenter4L,DiameterL,MianWanL,MnumberL,Prism1L,Prism2L,Prism3L,Prism4L,QuantityL,SPHL,X_ADDL,CaiBian,ChaSe,CheBian,ExtraProcess,Hardened,JingJia,JuSe,KaiKeng,OtherProcess,PaoGuang,PiHua,RanSe,RanSeName,ShuiYin,UV,ZuanKong,LR_Flag,Mnumber)");
strSql.Append(" values (");
strSql.Append("@ID,@BillCode,@CusCode,@Remark,@Notes,@PD,@OBillCode,@Flag_CX,@AxisR,@Center_ThicknessR,@CYLR,@DaoBianR,@Decenter1R,@Decenter2R,@Decenter3R,@Decenter4R,@DiameterR,@MianWanR,@MnumberR,@Prism1R,@Prism2R,@Prism3R,@Prism4R,@QuantityR,@SPHR,@X_ADDR,@AxisL,@Center_ThicknessL,@CYLL,@DaoBianL,@Decenter1L,@Decenter2L,@Decenter3L,@Decenter4L,@DiameterL,@MianWanL,@MnumberL,@Prism1L,@Prism2L,@Prism3L,@Prism4L,@QuantityL,@SPHL,@X_ADDL,@CaiBian,@ChaSe,@CheBian,@ExtraProcess,@Hardened,@JingJia,@JuSe,@KaiKeng,@OtherProcess,@PaoGuang,@PiHua,@RanSe,@RanSeName,@ShuiYin,@UV,@ZuanKong,@LR_Flag,@Mnumber)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BillCode", SqlDbType.NVarChar, 30),
new SqlParameter("@CusCode", SqlDbType.VarChar, 22),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@Notes", SqlDbType.NVarChar, 200),
new SqlParameter("@PD", SqlDbType.NVarChar, 10),
new SqlParameter("@OBillCode", SqlDbType.NVarChar, 30),
new SqlParameter("@Flag_CX", SqlDbType.Bit, 1),
new SqlParameter("@AxisR", SqlDbType.NVarChar, 5),
new SqlParameter("@Center_ThicknessR", SqlDbType.NVarChar, 5),
new SqlParameter("@CYLR", SqlDbType.Int, 4),
new SqlParameter("@DaoBianR", SqlDbType.Bit, 1),
new SqlParameter("@Decenter1R", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter2R", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter3R", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter4R", SqlDbType.NVarChar, 10),
new SqlParameter("@DiameterR", SqlDbType.Int, 4),
new SqlParameter("@MianWanR", SqlDbType.NVarChar, 10),
new SqlParameter("@MnumberR", SqlDbType.NVarChar, 30),
new SqlParameter("@Prism1R", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism2R", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism3R", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism4R", SqlDbType.NVarChar, 10),
new SqlParameter("@QuantityR", SqlDbType.Int, 4),
new SqlParameter("@SPHR", SqlDbType.Int, 4),
new SqlParameter("@X_ADDR", SqlDbType.Int, 4),
new SqlParameter("@AxisL", SqlDbType.NVarChar, 5),
new SqlParameter("@Center_ThicknessL", SqlDbType.NVarChar, 5),
new SqlParameter("@CYLL", SqlDbType.Int, 4),
new SqlParameter("@DaoBianL", SqlDbType.Bit, 1),
new SqlParameter("@Decenter1L", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter2L", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter3L", SqlDbType.NVarChar, 10),
new SqlParameter("@Decenter4L", SqlDbType.NVarChar, 10),
new SqlParameter("@DiameterL", SqlDbType.Int, 4),
new SqlParameter("@MianWanL", SqlDbType.NVarChar, 10),
new SqlParameter("@MnumberL", SqlDbType.NVarChar, 30),
new SqlParameter("@Prism1L", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism2L", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism3L", SqlDbType.NVarChar, 10),
new SqlParameter("@Prism4L", SqlDbType.NVarChar, 10),
new SqlParameter("@QuantityL", SqlDbType.Int, 4),
new SqlParameter("@SPHL", SqlDbType.Int, 4),
new SqlParameter("@X_ADDL", SqlDbType.Int, 4),
new SqlParameter("@CaiBian", SqlDbType.NVarChar, 20),
new SqlParameter("@ChaSe", SqlDbType.NVarChar, 20),
new SqlParameter("@CheBian", SqlDbType.NVarChar, 20),
new SqlParameter("@ExtraProcess", SqlDbType.NVarChar, 20),
new SqlParameter("@Hardened", SqlDbType.Bit, 1),
new SqlParameter("@JingJia", SqlDbType.NVarChar, 20),
new SqlParameter("@JuSe", SqlDbType.NVarChar, 20),
new SqlParameter("@KaiKeng", SqlDbType.NVarChar, 20),
new SqlParameter("@OtherProcess", SqlDbType.NVarChar, 20),
new SqlParameter("@PaoGuang", SqlDbType.NVarChar, 20),
new SqlParameter("@PiHua", SqlDbType.NVarChar, 20),
new SqlParameter("@RanSe", SqlDbType.NVarChar, 20),
new SqlParameter("@RanSeName", SqlDbType.NVarChar, 20),
new SqlParameter("@ShuiYin", SqlDbType.NVarChar, 20),
new SqlParameter("@UV", SqlDbType.Bit, 1),
new SqlParameter("@ZuanKong", SqlDbType.NVarChar, 20),
new SqlParameter("@LR_Flag", SqlDbType.NVarChar, 1),
new SqlParameter("@Mnumber", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BillCode;
parameters[2].Value = model.CusCode;
parameters[3].Value = model.Remark;
parameters[4].Value = model.Notes;
parameters[5].Value = model.PD;
parameters[6].Value = model.OBillCode;
parameters[7].Value = model.Flag_CX;
parameters[8].Value = model.AxisR;
parameters[9].Value = model.Center_ThicknessR;
parameters[10].Value = model.CYLR;
parameters[11].Value = model.DaoBianR;
parameters[12].Value = model.Decenter1R;
parameters[13].Value = model.Decenter2R;
parameters[14].Value = model.Decenter3R;
parameters[15].Value = model.Decenter4R;
parameters[16].Value = model.DiameterR;
parameters[17].Value = model.MianWanR;
parameters[18].Value = model.MnumberR;
parameters[19].Value = model.Prism1R;
parameters[20].Value = model.Prism2R;
parameters[21].Value = model.Prism3R;
parameters[22].Value = model.Prism4R;
parameters[23].Value = model.QuantityR;
parameters[24].Value = model.SPHR;
parameters[25].Value = model.X_ADDR;
parameters[26].Value = model.AxisL;
parameters[27].Value = model.Center_ThicknessL;
parameters[28].Value = model.CYLL;
parameters[29].Value = model.DaoBianL;
parameters[30].Value = model.Decenter1L;
parameters[31].Value = model.Decenter2L;
parameters[32].Value = model.Decenter3L;
parameters[33].Value = model.Decenter4L;
parameters[34].Value = model.DiameterL;
parameters[35].Value = model.MianWanL;
parameters[36].Value = model.MnumberL;
parameters[37].Value = model.Prism1L;
parameters[38].Value = model.Prism2L;
parameters[39].Value = model.Prism3L;
parameters[40].Value = model.Prism4L;
parameters[41].Value = model.QuantityL;
parameters[42].Value = model.SPHL;
parameters[43].Value = model.X_ADDL;
parameters[44].Value = model.CaiBian;
parameters[45].Value = model.ChaSe;
parameters[46].Value = model.CheBian;
parameters[47].Value = model.ExtraProcess;
parameters[48].Value = model.Hardened;
parameters[49].Value = model.JingJia;
parameters[50].Value = model.JuSe;
parameters[51].Value = model.KaiKeng;
parameters[52].Value = model.OtherProcess;
parameters[53].Value = model.PaoGuang;
parameters[54].Value = model.PiHua;
parameters[55].Value = model.RanSe;
parameters[56].Value = model.RanSeName;
parameters[57].Value = model.ShuiYin;
parameters[58].Value = model.UV;
parameters[59].Value = model.ZuanKong;
parameters[60].Value = model.LR_Flag;
parameters[61].Value = model.Mnumber;
//
DbHelperCmdObject obj = new DbHelperCmdObject(strSql.ToString(), parameters);
return(obj);
}
