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