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("编辑失败！");
}
}
