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);
}
public bool EditStock(List <Model.jxc_ProcurementPlanItem> insertList, List <Model.jxc_ProcurementPlanItem> updateList, List <Model.jxc_ProcurementPlanItem> delList, long id)
{
ArrayList arr = new ArrayList();
StringBuilder sbSql = new StringBuilder();
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 + "','" + model.PID + "','" + 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);
}
