public void UpdateWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { StringBuilder strSql = new StringBuilder(); SqlParameter[] parameters; /////////////////////////////////////////////// strSql.Append("SP_Ware_Bill_Count_EditVerify"); parameters = new SqlParameter[] { new SqlParameter("@LgIndex", SqlDbType.Int), new SqlParameter("@PKCode", SqlDbType.VarChar, 25) }; parameters[0].Value = lgIndex; parameters[1].Value = model.ID; cmd.ExecuteMySPQuery(strSql.ToString(), parameters); ///////////////////////////////////////////////////////////////// strSql.Clear(); strSql.Append("update Ware_Bill_Count set "); strSql.Append("WhCode=@WhCode,"); strSql.Append("FBCode=@FBCode,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); parameters = new SqlParameter[] { new SqlParameter("@WhCode", SqlDbType.VarChar, 10), new SqlParameter("@FBCode", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.WhCode; parameters[1].Value = model.FBCode; parameters[2].Value = model.Remark; parameters[3].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void PreparePD(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { model.Sub_PD.ID = model.ID; _DW.AddWare_Bill_PD(lgIndex, cmd, model.Sub_PD); model.Sub_PD_Detail2.ForEach(it => it.ID = model.ID); _DW.AddWare_Bill_Count_PD_Detail2(lgIndex, cmd, model.Sub_PD_Detail2); }
protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t) { MWare_Bill_Count model = t as MWare_Bill_Count; switch (model.MType) { case "L": this.PreparePD(lgIndex, cmd, model); break; default: break; } this.PrepareAddExtend(lgIndex, cmd, model); }
public void UpdateEditWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Ware_Bill_Count set "); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.Remark; parameters[1].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void PrepareExtend(MWare_Bill_Count model) { model.Sub_Extend = new MWare_Bill_Count_Extend() { ID = model.ID, SumQty1 = 0, SumQty2 = 0, SumQty = 0, }; switch (model.MType) { case "L": break; default: break; } }
private void PrepareAddExtend(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { this.PrepareExtend(model); _DW.AddWare_Bill_Count_Extend(lgIndex, cmd, model.Sub_Extend); }
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t) { MWare_Bill_Count model = t as MWare_Bill_Count; _DW.AddWare_Bill_Count(lgIndex, cmd, model); }
private void UpdatePD(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { _DW.UpdateWare_Bill_PD(lgIndex, cmd, model.Sub_PD); _DW.UpdateWare_Bill_Count_PD_Detail2(lgIndex, cmd, model.Sub_PD_Detail2); }
public void AddWare_Bill_Count(int lgIndex, SqlCommand cmd, MWare_Bill_Count model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Ware_Bill_Count("); strSql.Append("ID,BCode,BDate,BType,MType,StCode,WhCode,FBCode,Remark,KJYear,Period,Maker,MName,MDate,Starter,StartName,StartTime,Ender,EndName,EndTime,F_Del,Deler,DelName,DelDate)"); strSql.Append(" values ("); strSql.Append("@ID,@BCode,@BDate,@BType,@MType,@StCode,@WhCode,@FBCode,@Remark,@KJYear,@Period,@Maker,@MName,@MDate,@Starter,@StartName,@StartTime,@Ender,@EndName,@EndTime,@F_Del,@Deler,@DelName,@DelDate)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@BCode", SqlDbType.VarChar, 30), new SqlParameter("@BDate", SqlDbType.Date, 3), new SqlParameter("@BType", SqlDbType.VarChar, 10), new SqlParameter("@MType", SqlDbType.VarChar, 10), new SqlParameter("@StCode", SqlDbType.VarChar, 10), new SqlParameter("@WhCode", SqlDbType.VarChar, 10), new SqlParameter("@FBCode", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@KJYear", SqlDbType.Int, 4), new SqlParameter("@Period", SqlDbType.Int, 4), new SqlParameter("@Maker", SqlDbType.VarChar, 10), new SqlParameter("@MName", SqlDbType.NVarChar, 30), new SqlParameter("@MDate", SqlDbType.DateTime), new SqlParameter("@Starter", SqlDbType.VarChar, 10), new SqlParameter("@StartName", SqlDbType.NVarChar, 30), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@Ender", SqlDbType.VarChar, 10), new SqlParameter("@EndName", SqlDbType.NVarChar, 30), new SqlParameter("@EndTime", SqlDbType.DateTime), 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.BDate; parameters[3].Value = model.BType; parameters[4].Value = model.MType; parameters[5].Value = model.StCode; parameters[6].Value = model.WhCode; parameters[7].Value = model.FBCode; parameters[8].Value = model.Remark; parameters[9].Value = model.KJYear; parameters[10].Value = model.Period; parameters[11].Value = model.Maker; parameters[12].Value = model.MName; parameters[13].Value = System.DateTime.Now; //model.MDate; parameters[14].Value = ""; //model.Starter; parameters[15].Value = ""; //model.StartName; parameters[16].Value = System.DBNull.Value; // model.StartTime; parameters[17].Value = ""; //model.Ender; parameters[18].Value = ""; //model.EndName; parameters[19].Value = System.DBNull.Value; //model.EndTime; parameters[20].Value = false; // model.F_Del; parameters[21].Value = ""; // model.Deler; parameters[22].Value = ""; //model.DelName; parameters[23].Value = System.DBNull.Value; //model.DelDate; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void UpdateEdit(string dbCode, int lgIndex, MWare_Bill_Count t) { bllUpdateEdit.UpdateEdit(dbCode, lgIndex, t); }
public string Add(string dbCode, int lgIndex, MWare_Bill_Count t) { return(bll.Add(dbCode, lgIndex, t)); }