private void PrepareDetail(int lgIndex, SqlCommand cmd, MWare_Stocks_Base_Lens model)
{
StringBuilder strSql = new StringBuilder();
SqlParameter[] parameters = null;
///////////////////////////////////////////////////////////////////////////////////////
foreach (var model_Detail in model.Sub_Detail)
{
strSql.Clear();
strSql.Append("insert into Ware_Stocks_Base_Lens_Detail(");
strSql.Append("ID,SubID,SPH,CYL,X_ADD,Qty)");
strSql.Append(" values (");
strSql.Append("@ID,@SubID,@SPH,@CYL,@X_ADD,@Qty)");
parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@SubID", SqlDbType.Int, 4),
new SqlParameter("@SPH", SqlDbType.Int, 4),
new SqlParameter("@CYL", SqlDbType.Int, 4),
new SqlParameter("@X_ADD", SqlDbType.Int, 4),
new SqlParameter("@Qty", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model_Detail.SubID;
parameters[2].Value = model_Detail.SPH;
parameters[3].Value = model_Detail.CYL;
parameters[4].Value = model_Detail.X_ADD;
parameters[5].Value = model_Detail.Qty;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
}
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t)
{
MWare_Stocks_Base_Lens model = t as MWare_Stocks_Base_Lens;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Ware_Stocks_Base_Lens(");
strSql.Append("ID,BCode,WhCode,LensCode,F_LR,BDate,BType,Maker,MName,MDate,Checker,ChName,ChDate,StCode,Remark,SumQty,F_Del,Deler,DelName,DelDate)");
strSql.Append(" values (");
strSql.Append("@ID,@BCode,@WhCode,@LensCode,@F_LR,@BDate,@BType,@Maker,@MName,@MDate,@Checker,@ChName,@ChDate,@StCode,@Remark,@SumQty,@F_Del,@Deler,@DelName,@DelDate)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 25),
new SqlParameter("@BCode", SqlDbType.VarChar, 30),
new SqlParameter("@WhCode", SqlDbType.VarChar, 10),
new SqlParameter("@LensCode", SqlDbType.VarChar, 50),
new SqlParameter("@F_LR", SqlDbType.VarChar, 1),
new SqlParameter("@BDate", SqlDbType.Date, 3),
new SqlParameter("@BType", SqlDbType.VarChar, 10),
new SqlParameter("@Maker", SqlDbType.VarChar, 10),
new SqlParameter("@MName", SqlDbType.NVarChar, 30),
new SqlParameter("@MDate", SqlDbType.DateTime),
new SqlParameter("@Checker", SqlDbType.NVarChar, 10),
new SqlParameter("@ChName", SqlDbType.NVarChar, 30),
new SqlParameter("@ChDate", SqlDbType.DateTime),
new SqlParameter("@StCode", SqlDbType.VarChar, 6),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@SumQty", SqlDbType.Int, 4),
new SqlParameter("@F_Del", SqlDbType.Bit, 1),
new SqlParameter("@Deler", SqlDbType.VarChar, 10),
new SqlParameter("@DelName", SqlDbType.NVarChar, 30),
new SqlParameter("@DelDate", SqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BCode;
parameters[2].Value = model.WhCode;
parameters[3].Value = model.LensCode;
parameters[4].Value = model.F_LR;
parameters[5].Value = model.BDate;
parameters[6].Value = model.BType;
parameters[7].Value = model.Maker;
parameters[8].Value = model.MName;
parameters[9].Value = System.DateTime.Now; //model.MDate;
parameters[10].Value = ""; //model.Checker;
parameters[11].Value = ""; //model.ChName;
parameters[12].Value = System.DBNull.Value; //model.ChDate;
parameters[13].Value = model.StCode;
parameters[14].Value = model.Remark;
parameters[15].Value = model.SumQty;
parameters[16].Value = 0; // model.F_Del;
parameters[17].Value = ""; //model.Deler;
parameters[18].Value = ""; // model.DelName;
parameters[19].Value = System.DBNull.Value; // model.DelDate;
cmd.ExecuteMyQuery(strSql.ToString(), parameters);
}
protected override string GetPKCodeValue <T>(T t)
{
MWare_Stocks_Base_Lens model = t as MWare_Stocks_Base_Lens;
return(model.WhCode + model.LensCode + model.F_LR);
}
public void UpdateEdit(string dbCode, int lgIndex, MWare_Stocks_Base_Lens t)
{
bllUpdateEdit.UpdateEdit(dbCode, lgIndex, t);
}
public string Add(string dbCode, int lgIndex, MWare_Stocks_Base_Lens t)
{
return(bll.Add(dbCode, lgIndex, t));
}
protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t)
{
MWare_Stocks_Base_Lens model = t as MWare_Stocks_Base_Lens;
this.PrepareDetail(lgIndex, cmd, model);
}
