public bool EditAdd(List <Model.jxc_ProcurementPlanItem> insertList, List <Model.jxc_ProcurementPlanItem> updateList, List <Model.jxc_ProcurementPlanItem> delList, long id, Model.jxc_ProcurementPlan ppmodel) { ArrayList arr = new ArrayList(); StringBuilder sbSql = new StringBuilder(); Model.jxc_ProcurementPlan modelPlan = ppmodel; sbSql.Append("update jxc_ProcurementPlan set Odd='" + modelPlan.Odd + "',OrderDate='" + modelPlan.OrderDate + "',Buyer='" + modelPlan.Buyer + "',Supplier='" + modelPlan.Supplier + "',SupplierHandled='" + modelPlan.SupplierHandled + "',DeliveryDate='" + modelPlan.DeliveryDate + "',Currency='" + modelPlan.Currency + "',ExchangeRate='" + modelPlan.ExchangeRate + "',PriceReduction='" + modelPlan.PriceReduction + "',PayTerm='" + modelPlan.PayTerm + "',DiscountRate='" + modelPlan.DiscountRate + "',Deposit='" + modelPlan.Deposit + "',AccountsMode='" + modelPlan.AccountsMode + "',TaxRate='" + modelPlan.TaxRate + "',OtherFees='" + modelPlan.OtherFees + "',PlansFactoryDate='" + modelPlan.PlansFactoryDate + "',FactoryDate='" + modelPlan.FactoryDate + "',Transport='" + modelPlan.Transport + "',DeliveryAddress='" + modelPlan.DeliveryAddress + "',state='" + modelPlan.state + "',Directions='" + modelPlan.Directions + "',remark='" + modelPlan.remark + "',"); sbSql.Append(" update_person='" + id + "',update_date=getdate()"); sbSql.Append(" where ID=" + modelPlan.ID); sbSql.Append(";select @@IDENTITY"); long planID = (long)DbHelperSQL.GetSingle(sbSql.ToString()); //ID for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlanItem model = delList[i]; sbSql.Append("delete from jxc_ProcurementPlanItem where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlanItem model = updateList[i]; sbSql.Append("update jxc_ProcurementPlanItem set Item='" + model.Item + "',Odd='" + model.Odd + "',PID='" + model.PID + "',ProductID='" + model.ProductID + "',PlanAmount='" + model.PlanAmount + "',PurchasedAmount='" + model.PurchasedAmount + "',ExpectedPrice='" + model.ExpectedPrice + "',Discount='" + model.Discount + "',PlansPurchaseDate='" + model.PlansPurchaseDate + "',PlansFactoryDate='" + model.PlansFactoryDate + "',ExpectedArrivalDate='" + model.ExpectedArrivalDate + "',PlansSupplier='" + model.PlansSupplier + "',Supplier='" + model.Supplier + "',ProductOdd='" + model.ProductOdd + "',OrderItem='" + model.OrderItem + "',state='" + model.state + "',Directions='" + model.Directions + "',remark='" + model.remark + "',status='" + model.status + "',update_person='" + id + "',update_date=getdate() "); sbSql.Append(" where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlanItem model = insertList[i]; sbSql.Append("insert into jxc_ProcurementPlanItem "); sbSql.Append("Item,Odd,PID,ProductID,PlanAmount,PurchasedAmount,ExpectedPrice,Discount,PlansPurchaseDate,PlansFactoryDate,ExpectedArrivalDate,PlansSupplier,Supplier,ProductOdd,OrderItem,state,Directions,,remark,status,create_person,create_date) "); sbSql.Append(" values ( "); sbSql.Append("'" + model.Item + "','" + model.Odd + "','" + planID + "','" + model.ProductID + "','" + model.PlanAmount + "','" + model.PurchasedAmount + "','" + model.ExpectedPrice + "','" + model.Discount + "','" + model.PlansPurchaseDate + "','" + model.PlansFactoryDate + "','" + model.ExpectedArrivalDate + "','" + model.PlansSupplier + "','" + model.Supplier + "','" + model.ProductOdd + "','" + model.OrderItem + "','" + model.state + "','" + model.Directions + "','" + model.remark + "','" + model.status + "','" + id + "',getdate()"); sbSql.Append(" ) "); arr.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(arr); return(true); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "jxc_ProcurementPlan"; * parameters[1].Value = "ID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod public bool EditStock(List <Model.jxc_ProcurementPlan> insertList, List <Model.jxc_ProcurementPlan> updateList, List <Model.jxc_ProcurementPlan> delList, long id) { ArrayList arr = new ArrayList(); StringBuilder sbSql = new StringBuilder(); for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlan model = delList[i]; sbSql.Append("delete from jxc_ProcurementPlan where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlan model = updateList[i]; sbSql.Append("update jxc_ProcurementPlan set Odd='" + model.Odd + "',OrderDate='" + model.OrderDate + "',Buyer='" + model.Buyer + "',Supplier='" + model.Supplier + "',SupplierHandled='" + model.SupplierHandled + "',DeliveryDate='" + model.DeliveryDate + "',Currency='" + model.Currency + "',ExchangeRate='" + model.ExchangeRate + "',PriceReduction='" + model.PriceReduction + "',PayTerm='" + model.PayTerm + "',DiscountRate='" + model.DiscountRate + "',Deposit='" + model.Deposit + "',AccountsMode='" + model.AccountsMode + "',TaxRate='" + model.TaxRate + "',OtherFees='" + model.OtherFees + "',PlansFactoryDate='" + model.PlansFactoryDate + "',FactoryDate='" + model.FactoryDate + "',Transport='" + model.Transport + "',DeliveryAddress='" + model.DeliveryAddress + "',state='" + model.state + "',Directions='" + model.Directions + "',remark='" + model.remark + "'"); sbSql.Append(",update_person='" + id + "',update_date=getdate()"); sbSql.Append(" where ID=" + model.ID); arr.Add(sbSql.ToString()); } for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); Model.jxc_ProcurementPlan model = insertList[i]; sbSql.Append("insert into jxc_ProcurementPlan "); sbSql.Append("Odd,OrderDate,Buyer,Supplier,SupplierHandled,DeliveryDate,Currency,ExchangeRate,PriceReduction,PayTerm,DiscountRate,Deposit,AccountsMode,TaxRate,OtherFees,PlansFactoryDate,FactoryDate,Transport,DeliveryAddress,state,Directions,remark,create_person,create_date,update_person,update_date) "); sbSql.Append(" values ( "); sbSql.Append("'" + model.Odd + "','" + model.OrderDate + "','" + model.Buyer + "','" + model.Supplier + "','" + model.SupplierHandled + "','" + model.DeliveryDate + "','" + model.Currency + "','" + model.ExchangeRate + "','" + model.PriceReduction + "','" + model.PayTerm + "','" + model.DiscountRate + "','" + model.Deposit + "','" + model.AccountsMode + "','" + model.TaxRate + "','" + model.OtherFees + "','" + model.PlansFactoryDate + "','" + model.FactoryDate + "','" + model.Transport + "','" + model.DeliveryAddress + "','" + model.state + "','" + model.Directions + "',remark='" + model.remark + "','" + id + "',getdate()"); sbSql.Append(" ) "); arr.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(arr); return(true); }
//save all the add procurement plan public string SaveAdd(HttpContext context) { string txtOdd = context.Request["txtOdd"].ToString(); string txtOrderDate = context.Request["txtOrderDate"].ToString(); string txtSupplier = context.Request["txtSupplier"].ToString(); string txtBuyer = context.Request["txtBuyer"].ToString(); string txtSupplierHandled = context.Request["txtSupplierHandled"].ToString(); string txtDeliveryDate = context.Request["txtDeliveryDate"].ToString(); string txtCurrency = context.Request["txtCurrency"].ToString(); string txtExchangeRate = context.Request["txtExchangeRate"].ToString(); string txtPriceReduction = context.Request["txtPriceReduction"].ToString(); string txtPayTerm = context.Request["txtPayTerm"].ToString(); string txtDiscountRate = context.Request["txtDiscountRate"].ToString(); string txtDeposit = context.Request["txtDeposit"].ToString(); string txtAccountsMode = context.Request["txtAccountsMode"].ToString(); string txtTaxRate = context.Request["txtTaxRate"].ToString(); string txtOtherFees = context.Request["txtOtherFees"].ToString(); string txtPlansFactoryDate = context.Request["txtPlansFactoryDate"].ToString(); string txtFactoryDate = context.Request["txtFactoryDate"].ToString(); string txtTransport = context.Request["txtTransport"].ToString(); string txtDeliveryAddress = context.Request["txtDeliveryAddress"].ToString(); string txtDirections = context.Request["txtDirections"].ToString(); string txtRemark = context.Request["txtRemark"].ToString(); Model.jxc_ProcurementPlan model = new Model.jxc_ProcurementPlan(); model.Odd = txtOdd; model.OrderDate = Convert.ToDateTime(txtOrderDate); model.Supplier = txtSupplier; model.SupplierHandled = txtSupplierHandled; model.DeliveryDate = Convert.ToDateTime(txtDeliveryDate); model.Currency = txtCurrency; model.ExchangeRate = Convert.ToDecimal(txtExchangeRate); model.PriceReduction = Convert.ToDecimal(txtPriceReduction); model.PayTerm = txtPayTerm; model.DiscountRate = Convert.ToDecimal(txtDiscountRate); model.Deposit = Convert.ToDecimal(txtDeposit); model.AccountsMode = txtAccountsMode; model.TaxRate = Convert.ToDecimal(txtTaxRate); model.OtherFees = Convert.ToDecimal(txtOtherFees); model.PlansFactoryDate = Convert.ToDateTime(txtPlansFactoryDate); model.FactoryDate = Convert.ToDateTime(txtFactoryDate); model.Transport = txtTransport; model.DeliveryAddress = txtDeliveryAddress; model.Directions = txtDirections; model.remark = txtRemark; string addSrt = context.Request["addstr"]; string updatestr = context.Request["updatestr"]; string delstr = context.Request["delstr"]; List <Model.jxc_ProcurementPlanItem> insertList = new List <Model.jxc_ProcurementPlanItem>(); insertList = JsonSerializerHelper.JSONStringToList <Model.jxc_ProcurementPlanItem>(addSrt); List <Model.jxc_ProcurementPlanItem> updateList = new List <Model.jxc_ProcurementPlanItem>(); updateList = JsonSerializerHelper.JSONStringToList <Model.jxc_ProcurementPlanItem>(updatestr); List <Model.jxc_ProcurementPlanItem> delList = new List <Model.jxc_ProcurementPlanItem>(); delList = JsonSerializerHelper.JSONStringToList <Model.jxc_ProcurementPlanItem>(delstr); string result = new BLL.jxc_ProcurementPlanItem().EditStock(insertList, updateList, delList, ((Model.BaseUser)context.Session["login"]).UserID, model); if (result == "success") { return("success!"); } else { return("操作失败!"); } }
public string EditStock(List <Model.jxc_ProcurementPlanItem> insertList, List <Model.jxc_ProcurementPlanItem> updateList, List <Model.jxc_ProcurementPlanItem> delList, long id, Model.jxc_ProcurementPlan ppmodel) { if (dal.EditStock(insertList, updateList, delList, id, ppmodel)) { return("success"); } else { return("编辑失败!"); } }