public void Update(string dbCode, int lgIndex, MB_Material_Lens t)
{
bll.Update(dbCode, lgIndex, t);
}
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t)
{
MB_Material_Lens model = t as MB_Material_Lens;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into B_Material_Lens(");
strSql.Append("LensCode,LensLevel,LensName,SPH1,SPH2,CYL1,CYL2,X_ADD1,X_ADD2,Focus,RIndex,Design,DefaultCoating,Usage,Materials,Material,Density,Abbe,RIndex_Measured,UVCutOff,PrismAvailability,Colour,Corridor,Fitting,LensType,F_HardCoat,F_Tintage,F_Coating,F_Decenter,F_Prism,F_Base,F_LR,F_CA,F_Pur,F_Stop,Sort1,Sort2,Transmistion1,Transmistion2,Purpose,Criterion1,Criterion2,ReformulatedPower,Ctvalue,Attachment1,PCode,Brand,Modelselect,Bagcode,Guarantee,F_StopSale,Image1,Image2,Image3,Df_SpCode)");
strSql.Append(" values (");
strSql.Append("@LensCode,@LensLevel,@LensName,@SPH1,@SPH2,@CYL1,@CYL2,@X_ADD1,@X_ADD2,@Focus,@RIndex,@Design,@DefaultCoating,@Usage,@Materials,@Material,@Density,@Abbe,@RIndex_Measured,@UVCutOff,@PrismAvailability,@Colour,@Corridor,@Fitting,@LensType,@F_HardCoat,@F_Tintage,@F_Coating,@F_Decenter,@F_Prism,@F_Base,@F_LR,@F_CA,@F_Pur,@F_Stop,@Sort1,@Sort2,@Transmistion1,@Transmistion2,@Purpose,@Criterion1,@Criterion2,@ReformulatedPower,@Ctvalue,@Attachment1,@PCode,@Brand,@Modelselect,@Bagcode,@Guarantee,@F_StopSale,@Image1,@Image2,@Image3,@Df_SpCode)");
SqlParameter[] parameters =
{
new SqlParameter("@LensCode", SqlDbType.VarChar, 50),
new SqlParameter("@LensLevel", SqlDbType.TinyInt, 1),
new SqlParameter("@LensName", SqlDbType.NVarChar, 100),
new SqlParameter("@SPH1", SqlDbType.Int, 4),
new SqlParameter("@SPH2", SqlDbType.Int, 4),
new SqlParameter("@CYL1", SqlDbType.Int, 4),
new SqlParameter("@CYL2", SqlDbType.Int, 4),
new SqlParameter("@X_ADD1", SqlDbType.Int, 4),
new SqlParameter("@X_ADD2", SqlDbType.Int, 4),
new SqlParameter("@Focus", SqlDbType.VarChar, 10),
new SqlParameter("@RIndex", SqlDbType.VarChar, 10),
new SqlParameter("@Design", SqlDbType.VarChar, 10),
new SqlParameter("@DefaultCoating", SqlDbType.VarChar, 10),
new SqlParameter("@Usage", SqlDbType.VarChar, 10),
new SqlParameter("@Materials", SqlDbType.VarChar, 10),
new SqlParameter("@Material", SqlDbType.VarChar, 30),
new SqlParameter("@Density", SqlDbType.VarChar, 10),
new SqlParameter("@Abbe", SqlDbType.Decimal, 9),
new SqlParameter("@RIndex_Measured", SqlDbType.VarChar, 10),
new SqlParameter("@UVCutOff", SqlDbType.Int, 4),
new SqlParameter("@PrismAvailability", SqlDbType.VarChar, 20),
new SqlParameter("@Colour", SqlDbType.VarChar, 10),
new SqlParameter("@Corridor", SqlDbType.VarChar, 50),
new SqlParameter("@Fitting", SqlDbType.VarChar, 50),
new SqlParameter("@LensType", SqlDbType.VarChar, 10),
new SqlParameter("@F_HardCoat", SqlDbType.Bit, 1),
new SqlParameter("@F_Tintage", SqlDbType.Bit, 1),
new SqlParameter("@F_Coating", SqlDbType.Bit, 1),
new SqlParameter("@F_Decenter", SqlDbType.Bit, 1),
new SqlParameter("@F_Prism", SqlDbType.Bit, 1),
new SqlParameter("@F_Base", SqlDbType.Bit, 1),
new SqlParameter("@F_LR", SqlDbType.Bit, 1),
new SqlParameter("@F_CA", SqlDbType.Bit, 1),
new SqlParameter("@F_Pur", SqlDbType.Bit, 1),
new SqlParameter("@F_Stop", SqlDbType.Bit, 1),
new SqlParameter("@Sort1", SqlDbType.VarChar, 50),
new SqlParameter("@Sort2", SqlDbType.VarChar, 50),
new SqlParameter("@Transmistion1", SqlDbType.VarChar, 30),
new SqlParameter("@Transmistion2", SqlDbType.VarChar, 30),
new SqlParameter("@Purpose", SqlDbType.VarChar, 50),
new SqlParameter("@Criterion1", SqlDbType.VarChar, 200),
new SqlParameter("@Criterion2", SqlDbType.VarChar, 200),
new SqlParameter("@ReformulatedPower", SqlDbType.Bit, 1),
new SqlParameter("@Ctvalue", SqlDbType.Bit, 1),
new SqlParameter("@Attachment1", SqlDbType.VarChar, 100),
new SqlParameter("@PCode", SqlDbType.VarChar, 50),
new SqlParameter("@Brand", SqlDbType.VarChar, 10),
new SqlParameter("@Modelselect", SqlDbType.VarChar, 30),
new SqlParameter("@Bagcode", SqlDbType.VarChar, 20),
new SqlParameter("@Guarantee", SqlDbType.VarChar, 30),
new SqlParameter("@F_StopSale", SqlDbType.Bit, 1),
new SqlParameter("@Image1", SqlDbType.VarChar, 50),
new SqlParameter("@Image2", SqlDbType.VarChar, 50),
new SqlParameter("@Image3", SqlDbType.VarChar, 50),
new SqlParameter("@Df_SpCode", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.LensCode;
parameters[1].Value = model.LensLevel;
parameters[2].Value = model.LensName;
parameters[3].Value = model.SPH1;
parameters[4].Value = model.SPH2;
parameters[5].Value = model.CYL1;
parameters[6].Value = model.CYL2;
parameters[7].Value = model.X_ADD1;
parameters[8].Value = model.X_ADD2;
parameters[9].Value = model.Focus;
parameters[10].Value = model.RIndex;
parameters[11].Value = model.Design;
parameters[12].Value = model.DefaultCoating;
parameters[13].Value = model.Usage;
parameters[14].Value = model.Materials;
parameters[15].Value = model.Material;
parameters[16].Value = model.Density;
parameters[17].Value = model.Abbe;
parameters[18].Value = model.RIndex_Measured;
parameters[19].Value = model.UVCutOff;
parameters[20].Value = model.PrismAvailability;
parameters[21].Value = model.Colour;
parameters[22].Value = model.Corridor;
parameters[23].Value = model.Fitting;
parameters[24].Value = model.LensType;
parameters[25].Value = model.F_HardCoat;
parameters[26].Value = model.F_Tintage;
parameters[27].Value = model.F_Coating;
parameters[28].Value = model.F_Decenter;
parameters[29].Value = model.F_Prism;
parameters[30].Value = model.F_Base;
parameters[31].Value = model.F_LR;
parameters[32].Value = model.F_CA;
parameters[33].Value = model.F_Pur;
parameters[34].Value = model.F_Stop;
parameters[35].Value = model.Sort1;
parameters[36].Value = model.Sort2;
parameters[37].Value = model.Transmistion1;
parameters[38].Value = model.Transmistion2;
parameters[39].Value = model.Purpose;
parameters[40].Value = model.Criterion1;
parameters[41].Value = model.Criterion2;
parameters[42].Value = model.ReformulatedPower;
parameters[43].Value = model.Ctvalue;
parameters[44].Value = model.Attachment1;
parameters[45].Value = model.PCode;
parameters[46].Value = model.Brand;
parameters[47].Value = model.Modelselect;
parameters[48].Value = model.Bagcode;
parameters[49].Value = model.Guarantee;
parameters[50].Value = model.F_StopSale;
parameters[51].Value = model.Image1;
parameters[52].Value = model.Image2;
parameters[53].Value = model.Image3;
parameters[54].Value = model.Df_SpCode;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public string Add(string dbCode, int lgIndex, MB_Material_Lens t)
{
return(bll.Add(dbCode, lgIndex, t));
}
protected override void PrepareUpdateMain(int lgIndex, SqlCommand cmd, object t)
{
MB_Material_Lens model = t as MB_Material_Lens;
StringBuilder strSql = new StringBuilder();
strSql.Append("update B_Material_Lens set ");
strSql.Append("LensLevel=@LensLevel,");
strSql.Append("LensName=@LensName,");
strSql.Append("SPH1=@SPH1,");
strSql.Append("SPH2=@SPH2,");
strSql.Append("CYL1=@CYL1,");
strSql.Append("CYL2=@CYL2,");
strSql.Append("X_ADD1=@X_ADD1,");
strSql.Append("X_ADD2=@X_ADD2,");
strSql.Append("Modelselect=@Modelselect,");
strSql.Append("Bagcode=@Bagcode,");
strSql.Append("Guarantee=@Guarantee,");
strSql.Append("Materials=@Materials,");
strSql.Append("RIndex=@RIndex,");
strSql.Append("Design=@Design,");
strSql.Append("Usage=@Usage,");
strSql.Append("Focus=@Focus,");
strSql.Append("Material=@Material,");
strSql.Append("Density=@Density,");
strSql.Append("Abbe=@Abbe,");
strSql.Append("UVCutOff=@UVCutOff,");
strSql.Append("PrismAvailability=@PrismAvailability,");
strSql.Append("Colour=@Colour,");
strSql.Append("Corridor=@Corridor,");
strSql.Append("Fitting=@Fitting,");
strSql.Append("LensType=@LensType,");
strSql.Append("F_HardCoat=@F_HardCoat,");
strSql.Append("F_Tintage=@F_Tintage,");
strSql.Append("F_Coating=@F_Coating,");
strSql.Append("F_Decenter=@F_Decenter,");
strSql.Append("F_Prism=@F_Prism,");
strSql.Append("F_Base=@F_Base,");
strSql.Append("F_LR=@F_LR,");
strSql.Append("F_CA=@F_CA,");
strSql.Append("F_Pur=@F_Pur,");
strSql.Append("F_Stop=@F_Stop,");
strSql.Append("Sort1=@Sort1,");
strSql.Append("Sort2=@Sort2,");
strSql.Append("Transmistion1=@Transmistion1,");
strSql.Append("Transmistion2=@Transmistion2,");
strSql.Append("Purpose=@Purpose,");
strSql.Append("Criterion1=@Criterion1,");
strSql.Append("Criterion2=@Criterion2,");
strSql.Append("PCode=@PCode,");
strSql.Append("Brand=@Brand,");
strSql.Append("ReformulatedPower=@ReformulatedPower,");
strSql.Append("Ctvalue=@Ctvalue,");
strSql.Append("Df_SpCode=@Df_SpCode,");
strSql.Append("F_StopSale=@F_StopSale");
strSql.Append(" where LensCode=@LensCode ");
SqlParameter[] parameters =
{
new SqlParameter("@LensLevel", SqlDbType.TinyInt, 1),
new SqlParameter("@LensName", SqlDbType.NVarChar, 100),
new SqlParameter("@SPH1", SqlDbType.Int, 4),
new SqlParameter("@SPH2", SqlDbType.Int, 4),
new SqlParameter("@CYL1", SqlDbType.Int, 4),
new SqlParameter("@CYL2", SqlDbType.Int, 4),
new SqlParameter("@X_ADD1", SqlDbType.Int, 4),
new SqlParameter("@X_ADD2", SqlDbType.Int, 4),
new SqlParameter("@Modelselect", SqlDbType.VarChar, 30),
new SqlParameter("@Bagcode", SqlDbType.VarChar, 20),
new SqlParameter("@Guarantee", SqlDbType.VarChar, 30),
new SqlParameter("@Materials", SqlDbType.VarChar, 10),
new SqlParameter("@RIndex", SqlDbType.VarChar, 10),
new SqlParameter("@Design", SqlDbType.VarChar, 10),
new SqlParameter("@Usage", SqlDbType.VarChar, 10),
new SqlParameter("@Focus", SqlDbType.VarChar, 10),
new SqlParameter("@Material", SqlDbType.VarChar, 30),
new SqlParameter("@Density", SqlDbType.VarChar, 10),
new SqlParameter("@Abbe", SqlDbType.Decimal, 9),
new SqlParameter("@UVCutOff", SqlDbType.Int, 4),
new SqlParameter("@PrismAvailability", SqlDbType.VarChar, 20),
new SqlParameter("@Colour", SqlDbType.VarChar, 10),
new SqlParameter("@Corridor", SqlDbType.VarChar, 50),
new SqlParameter("@Fitting", SqlDbType.VarChar, 50),
new SqlParameter("@LensType", SqlDbType.VarChar, 10),
new SqlParameter("@F_HardCoat", SqlDbType.Bit, 1),
new SqlParameter("@F_Tintage", SqlDbType.Bit, 1),
new SqlParameter("@F_Coating", SqlDbType.Bit, 1),
new SqlParameter("@F_Decenter", SqlDbType.Bit, 1),
new SqlParameter("@F_Prism", SqlDbType.Bit, 1),
new SqlParameter("@F_Base", SqlDbType.Bit, 1),
new SqlParameter("@F_LR", SqlDbType.Bit, 1),
new SqlParameter("@F_CA", SqlDbType.Bit, 1),
new SqlParameter("@F_Pur", SqlDbType.Bit, 1),
new SqlParameter("@F_Stop", SqlDbType.Bit, 1),
new SqlParameter("@Sort1", SqlDbType.VarChar, 50),
new SqlParameter("@Sort2", SqlDbType.VarChar, 50),
new SqlParameter("@Transmistion1", SqlDbType.VarChar, 30),
new SqlParameter("@Transmistion2", SqlDbType.VarChar, 30),
new SqlParameter("@Purpose", SqlDbType.VarChar, 50),
new SqlParameter("@Criterion1", SqlDbType.VarChar, 200),
new SqlParameter("@Criterion2", SqlDbType.VarChar, 200),
new SqlParameter("@PCode", SqlDbType.VarChar, 50),
new SqlParameter("@Brand", SqlDbType.VarChar, 10),
new SqlParameter("@ReformulatedPower", SqlDbType.Bit, 1),
new SqlParameter("@Ctvalue", SqlDbType.Bit, 1),
new SqlParameter("@Df_SpCode", SqlDbType.VarChar, 20),
new SqlParameter("@F_StopSale", SqlDbType.Bit, 1),
new SqlParameter("@LensCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.LensLevel;
parameters[1].Value = model.LensName;
parameters[2].Value = model.SPH1;
parameters[3].Value = model.SPH2;
parameters[4].Value = model.CYL1;
parameters[5].Value = model.CYL2;
parameters[6].Value = model.X_ADD1;
parameters[7].Value = model.X_ADD2;
parameters[8].Value = model.Modelselect;
parameters[9].Value = model.Bagcode;
parameters[10].Value = model.Guarantee;
parameters[11].Value = model.Materials;
parameters[12].Value = model.RIndex;
parameters[13].Value = model.Design;
parameters[14].Value = model.Usage;
parameters[15].Value = model.Focus;
parameters[16].Value = model.Material;
parameters[17].Value = model.Density;
parameters[18].Value = model.Abbe;
parameters[19].Value = model.UVCutOff;
parameters[20].Value = model.PrismAvailability;
parameters[21].Value = model.Colour;
parameters[22].Value = model.Corridor;
parameters[23].Value = model.Fitting;
parameters[24].Value = model.LensType;
parameters[25].Value = model.F_HardCoat;
parameters[26].Value = model.F_Tintage;
parameters[27].Value = model.F_Coating;
parameters[28].Value = model.F_Decenter;
parameters[29].Value = model.F_Prism;
parameters[30].Value = model.F_Base;
parameters[31].Value = model.F_LR;
parameters[32].Value = model.F_CA;
parameters[33].Value = model.F_Pur;
parameters[34].Value = model.F_Stop;
parameters[35].Value = model.Sort1;
parameters[36].Value = model.Sort2;
parameters[37].Value = model.Transmistion1;
parameters[38].Value = model.Transmistion2;
parameters[39].Value = model.Purpose;
parameters[40].Value = model.Criterion1;
parameters[41].Value = model.Criterion2;
parameters[42].Value = model.PCode;
parameters[43].Value = model.Brand;
parameters[44].Value = model.ReformulatedPower;
parameters[45].Value = model.Ctvalue;
parameters[46].Value = model.Df_SpCode;
parameters[47].Value = model.F_StopSale;
parameters[48].Value = model.LensCode;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
