public void AddPrice(string dbCode, int lgIndex, MB_Lens t) { var model = t.Sub_Price; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into B_Lens_Price("); strSql.Append("ID,LensCode,SPH1,SPH2,CYL1,CYL2,ADD1,ADD2,Dia,P1,P2)"); strSql.Append(" values ("); strSql.Append("(select HKOERP.dbo.SF_GetID()),@LensCode,@SPH1,@SPH2,@CYL1,@CYL2,@ADD1,@ADD2,@Dia,@P1,@P2)"); SqlParameter[] parameters = { new SqlParameter("@LensCode", SqlDbType.VarChar, 30), 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("@ADD1", SqlDbType.Int, 4), new SqlParameter("@ADD2", SqlDbType.Int, 4), new SqlParameter("@Dia", SqlDbType.Int, 4), new SqlParameter("@P1", SqlDbType.Decimal, 9), new SqlParameter("@P2", SqlDbType.Decimal, 9) }; parameters[0].Value = model.LensCode; parameters[1].Value = model.SPH1; parameters[2].Value = model.SPH2; parameters[3].Value = model.CYL1; parameters[4].Value = model.CYL2; parameters[5].Value = model.ADD1; parameters[6].Value = model.ADD2; parameters[7].Value = model.Dia; parameters[8].Value = model.P1; parameters[9].Value = model.P2; DALHelper.ExecuteSql(dbCode, strSql.ToString(), parameters); }
public void AddProCost(string dbCode, int lgIndex, MB_Lens t) { var model = t.Sub_ProCost; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into B_Lens_ProCost("); strSql.Append("ID,LensCode,F_Set,InvTitle,JY,UV,JS,RS,CS,SY,CB,ChB,KK,ZK,PiH,PG,JJ,OP,P1,P2)"); strSql.Append(" values ("); strSql.Append("(select HKOERP.dbo.SF_GetID()),@LensCode,@F_Set,@InvTitle,@JY,@UV,@JS,@RS,@CS,@SY,@CB,@ChB,@KK,@ZK,@PiH,@PG,@JJ,@OP,@P1,@P2)"); SqlParameter[] parameters = { new SqlParameter("@LensCode", SqlDbType.VarChar, 30), new SqlParameter("@F_Set", SqlDbType.Bit, 1), new SqlParameter("@InvTitle", SqlDbType.NVarChar, 40), 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("@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("@P1", SqlDbType.Decimal, 9), new SqlParameter("@P2", SqlDbType.Decimal, 9) }; parameters[0].Value = model.LensCode; parameters[1].Value = model.F_Set; parameters[2].Value = model.InvTitle; parameters[3].Value = model.JY; parameters[4].Value = model.UV; parameters[5].Value = model.JS; parameters[6].Value = model.RS; parameters[7].Value = model.CS; parameters[8].Value = model.SY; parameters[9].Value = model.CB; parameters[10].Value = model.ChB; parameters[11].Value = model.KK; parameters[12].Value = model.ZK; parameters[13].Value = model.PiH; parameters[14].Value = model.PG; parameters[15].Value = model.JJ; parameters[16].Value = model.OP; parameters[17].Value = model.P1; parameters[18].Value = model.P2; DALHelper.ExecuteSql(dbCode, strSql.ToString(), parameters); }
private void AddPrice() { if (this.ViewErrList != null && this.ViewErrList.Value.Count > 0) { return; } var model = new MB_Lens(); model.Sub_ProCost = new MB_Lens_ProCost() { CB = this.CB, ChB = this.ChB, CS = this.CS, F_Set = this.F_Set, InvTitle = this.InvTitle, JJ = this.JJ, JS = this.JS, JY = this.JY, KK = this.KK, OP = this.OP, PG = this.PG, PiH = this.PiH, RS = this.RS, SY = this.SY, UV = this.UV, ZK = this.ZK, ID = "", LensCode = this.SKeyCode, P1 = this.P1, P2 = this.P2 }; DSB_Lens _DS = new DSB_Lens(); this.IsBusy = true; _DS.AddProCost(USysInfo.DBCode, USysInfo.LgIndex, model, geted => { this.IsBusy = false; if (geted.HasError) { MessageErp.ErrorMessage(geted.Error.Message.GetErrMsg()); geted.MarkErrorAsHandled(); return; } this.Search(); }, null); }
private void AddPrice() { if (this.ViewErrList != null && this.ViewErrList.Value.Count > 0) { return; } var s1 = this.SPH1; var s2 = this.SPH2; var c1 = this.CYL1; var c2 = this.CYL2; var a1 = this.ADD1; var a2 = this.ADD2; var dia = this.Dia; var p1 = this.P1; var p2 = this.P2; var model = new MB_Lens(); model.Sub_Price = new MB_Lens_Price() { ADD1 = a1, ADD2 = a2, CYL1 = c1, CYL2 = c2, Dia = dia, ID = "", LensCode = this.SKeyCode, P1 = p1, P2 = p2, SPH1 = s1, SPH2 = s2 }; DSB_Lens _DS = new DSB_Lens(); this.IsBusy = true; _DS.AddPrice(USysInfo.DBCode, USysInfo.LgIndex, model, geted => { this.IsBusy = false; if (geted.HasError) { MessageErp.ErrorMessage(geted.Error.Message.GetErrMsg()); geted.MarkErrorAsHandled(); return; } this.Search(); }, null); }