public void UpdateWare_Bill_Transfer(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { StringBuilder strSql = new StringBuilder(); SqlParameter[] parameters; /////////////////修改,撤销预扣////////////////////////////// strSql.Append("SP_Ware_Bill_Transfer_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_Transfer set "); strSql.Append("WhCodeOut=@WhCodeOut,"); strSql.Append("WhCodeIn=@WhCodeIn,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); parameters = new SqlParameter[] { new SqlParameter("@WhCodeOut", SqlDbType.VarChar, 10), new SqlParameter("@WhCodeIn", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.WhCodeOut; parameters[1].Value = model.WhCodeIn; parameters[2].Value = model.Remark; parameters[3].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void PrepareExtend(MWare_Bill_Transfer model) { model.Sub_Extend = new MWare_Bill_Extend() { ID = model.ID, SPHL = 0, SPHR = 0, CYLL = 0, CYLR = 0, X_ADDL = 0, X_ADDR = 0, LensCodeL = "", LensCodeR = "", SCode = "", SumQty = 0, }; switch (model.MType) { case "L": model.Sub_Extend.LensCodeR = model.Sub_PD.LensCode; model.Sub_Extend.LensCodeL = model.Sub_PD.LensCode; model.Sub_Extend.SumQty = model.Sub_PD_Detail.Sum(it => it.Qty); break; default: break; } }
public void AddWare_Bill_Transfer(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Ware_Bill_Transfer("); strSql.Append("ID,BCode,BDate,BType,MType,StCode,WhCodeIn,WhCodeOut,Remark,Maker,MName,MDate,F_Chk,CheckerIn,ChNameIn,ChDateIn,CheckerOut,ChNameOut,ChDateOut,F_Del,Deler,DelName,DelDate)"); strSql.Append(" values ("); strSql.Append("@ID,@BCode,@BDate,@BType,@MType,@StCode,@WhCodeIn,@WhCodeOut,@Remark,@Maker,@MName,@MDate,@F_Chk,@CheckerIn,@ChNameIn,@ChDateIn,@CheckerOut,@ChNameOut,@ChDateOut,@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("@WhCodeIn", SqlDbType.VarChar, 10), new SqlParameter("@WhCodeOut", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@Maker", SqlDbType.VarChar, 10), new SqlParameter("@MName", SqlDbType.NVarChar, 30), new SqlParameter("@MDate", SqlDbType.DateTime), new SqlParameter("@F_Chk", SqlDbType.Bit, 1), new SqlParameter("@CheckerIn", SqlDbType.VarChar, 10), new SqlParameter("@ChNameIn", SqlDbType.NVarChar, 30), new SqlParameter("@ChDateIn", SqlDbType.DateTime), new SqlParameter("@CheckerOut", SqlDbType.VarChar, 10), new SqlParameter("@ChNameOut", SqlDbType.NVarChar, 30), new SqlParameter("@ChDateOut", 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.WhCodeIn; parameters[7].Value = model.WhCodeOut; parameters[8].Value = model.Remark; parameters[9].Value = model.Maker; parameters[10].Value = model.MName; parameters[11].Value = System.DateTime.Now; //model.MDate; parameters[12].Value = false; //model.F_Chk; parameters[13].Value = ""; //model.CheckerIn; parameters[14].Value = ""; //model.ChNameIn; parameters[15].Value = System.DBNull.Value; //model.ChDateIn; parameters[16].Value = ""; //model.CheckerOut; parameters[17].Value = ""; //model.ChNameOut; parameters[18].Value = System.DBNull.Value; //model.ChDateOut; parameters[19].Value = false; //model.F_Del; parameters[20].Value = ""; //model.Deler; parameters[21].Value = ""; // model.DelName; parameters[22].Value = System.DBNull.Value; //model.DelDate; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
private void PreparePD(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { model.Sub_PD.ID = model.ID; _DW.AddWare_Bill_PD(lgIndex, cmd, model.Sub_PD); model.Sub_PD_Detail.ForEach(it => it.ID = model.ID); _DW.AddWare_Bill_PD_Detail(lgIndex, cmd, model.Sub_PD_Detail); }
protected override void PrepareAddSub(int lgIndex, SqlCommand cmd, object t) { MWare_Bill_Transfer model = t as MWare_Bill_Transfer; switch (model.MType) { case "L": this.PreparePD(lgIndex, cmd, model); break; default: break; } this.PrepareAddExtend(lgIndex, cmd, model); }
public void UpdateEditWare_Bill_Transfer(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Ware_Bill_Transfer 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 PrepareAddExtend(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { this.PrepareExtend(model); _DW.AddWare_Bill_Extend(lgIndex, cmd, model.Sub_Extend); }
protected override void PrepareAddMain(int lgIndex, SqlCommand cmd, object t) { MWare_Bill_Transfer model = t as MWare_Bill_Transfer; _DW.AddWare_Bill_Transfer(lgIndex, cmd, model); }
private void UpdatePD(int lgIndex, SqlCommand cmd, MWare_Bill_Transfer model) { _DW.UpdateWare_Bill_PD(lgIndex, cmd, model.Sub_PD); _DW.UpdateWare_Bill_PD_Detail(lgIndex, cmd, model.Sub_PD_Detail); }
public void UpdateEdit(string dbCode, int lgIndex, MWare_Bill_Transfer t) { bllUpdateEdit.UpdateEdit(dbCode, lgIndex, t); }
public string Add(string dbCode, int lgIndex, MWare_Bill_Transfer t) { return(bll.Add(dbCode, lgIndex, t)); }