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