protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t)
{
MPur_Quote model = t as MPur_Quote;
StringBuilder strSql = new StringBuilder();
/////////////////////////////////////////////////////////////////////////////
strSql.Append("Delete Pur_Quote where Maker=@Maker ;");
////////////////////////////////////////////////////////////////////////////
strSql.Append("insert into Pur_Quote(");
strSql.Append("ID,BType,SpCode,Maker,MName,MDate,BCodePC)");
strSql.Append(" values (");
strSql.Append("@ID,@BType,@SpCode,@Maker,@MName,@MDate,@BCodePC)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BType", SqlDbType.VarChar, 5),
new SqlParameter("@SpCode", SqlDbType.VarChar, 10),
new SqlParameter("@Maker", SqlDbType.VarChar, 10),
new SqlParameter("@MName", SqlDbType.VarChar, 30),
new SqlParameter("@MDate", SqlDbType.DateTime),
new SqlParameter("@BCodePC", SqlDbType.VarChar, 25)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BType;
parameters[2].Value = model.SpCode;
parameters[3].Value = model.Maker;
parameters[4].Value = model.MName;
parameters[5].Value = System.DateTime.Now;
parameters[6].Value = model.BCodePC;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t)
{
MPur_Quote model = t as MPur_Quote;
MPur_Quote_SD modelSD = model.Sub_SD;
StringBuilder strSql = new StringBuilder();
strSql.Append("Delete Pur_Quote_SD where ID not in (select ID from Pur_Quote with (nolock)); ");
///////////////////////////////////////////////////////////////
strSql.Append("insert into Pur_Quote_SD(");
strSql.Append("ID,Dia,LensCode,SPH,CYL,Axis,X_ADD,Qty,BASE,CT,DB,D1,D2,D3,D4,P1,P2,P3,P4,Price,PriceJM,ProCost,InvTitle,ProReport,ProCostReport)");
strSql.Append(" values (");
strSql.Append("@ID,@Dia,@LensCode,@SPH,@CYL,@Axis,@X_ADD,@Qty,@BASE,@CT,@DB,@D1,@D2,@D3,@D4,@P1,@P2,@P3,@P4,@Price,@PriceJM,@ProCost,@InvTitle,@ProReport,@ProCostReport)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 30),
new SqlParameter("@Dia", SqlDbType.Int, 4),
new SqlParameter("@LensCode", 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("@Price", SqlDbType.Decimal, 9),
new SqlParameter("@PriceJM", 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.Dia;
parameters[2].Value = modelSD.LensCode;
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 = modelSD.Price;
parameters[20].Value = modelSD.PriceJM;
parameters[21].Value = modelSD.ProCost;
parameters[22].Value = modelSD.InvTitle;
parameters[23].Value = modelSD.ProReport;
parameters[24].Value = modelSD.ProCostReport;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
MPur_Quote_SD_Process modelSD_Process = model.Sub_SD_Process;
strSql.Clear();
strSql.Append("Delete Pur_Quote_SD_Process where ID not in (select ID from Pur_Quote with (nolock)); ");
///////////////////////////////////////////////////////////////
strSql.Append("insert into Pur_Quote_SD_Process(");
strSql.Append("ID,JY,UV,JS,RS,RSName,CS,SY,CB,ChB,KK,ZK,PiH,PG,JJ,OP)");
strSql.Append(" values (");
strSql.Append("@ID,@JY,@UV,@JS,@RS,@RSName,@CS,@SY,@CB,@ChB,@KK,@ZK,@PiH,@PG,@JJ,@OP)");
parameters = new SqlParameter[] {
new SqlParameter("@ID", 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, 30),
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)
};
parameters[0].Value = model.ID;
parameters[1].Value = modelSD_Process.JY;
parameters[2].Value = modelSD_Process.UV;
parameters[3].Value = modelSD_Process.JS;
parameters[4].Value = modelSD_Process.RS;
parameters[5].Value = modelSD_Process.RSName;
parameters[6].Value = modelSD_Process.CS;
parameters[7].Value = modelSD_Process.SY;
parameters[8].Value = modelSD_Process.CB;
parameters[9].Value = modelSD_Process.ChB;
parameters[10].Value = modelSD_Process.KK;
parameters[11].Value = modelSD_Process.ZK;
parameters[12].Value = modelSD_Process.PiH;
parameters[13].Value = modelSD_Process.PG;
parameters[14].Value = modelSD_Process.JJ;
parameters[15].Value = modelSD_Process.OP;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
public string Add(string dbCode, int lgIndex, MPur_Quote t)
{
return(bll.Add(dbCode, lgIndex, t));
}
