protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SaleOderManager.DatatRecovery(); if (Request["isEditQty"] != null && Request["isEditQty"] != "")//编辑数量 { string ordersNumber = Request["ordersNumber"]; string productnumber = Request["productnumber"]; string version = Request["Version"]; string rowNumber = Request["RowNumber"]; string qty = Request["qty"]; //检查数量是否小于已交数量 string sqlCheck = string.Format(@" select COUNT(0) from MachineOderDetail where {0}<DeliveryQty and OdersNumber='{1}' and ProductNumber='{2}' and Version='{3}' and RowNumber='{4}' ", qty, ordersNumber, productnumber, version, rowNumber); if (!SqlHelper.GetScalar(sqlCheck).Equals("0")) { Response.Write("数量不能小于已交货数量"); Response.End(); return; } string errorEdit = ""; List <string> sqlEdits = new List <string>(); string sqlEdit = string.Format(@" update MachineOderDetail set Qty={0}, NondeliveryQty={0}-DeliveryQty, SumPrice=UnitPrice*{0} where OdersNumber='{1}' and ProductNumber='{2}' and Version='{3}' and RowNumber='{4}' ", qty, ordersNumber, productnumber, version, rowNumber); sqlEdits.Add(sqlEdit); sqlEdits.AddRange(GetChangeQtySqlList()); //更新 bool result = SqlHelper.BatchExecuteSql(sqlEdits, ref errorEdit); Response.Write(result ? "1" : errorEdit); Response.End(); return; } //ordersNumber: ordersNumber, ProductNumber: productnumber, Version: version, RowNumber: rownumber,qty:qty if (Request["isEditYJ"] != null && Request["isEditYJ"] != "")//编辑已交数量 { string ordersNumber = Request["ordersNumber"]; string productnumber = Request["productnumber"]; string version = Request["Version"]; string rowNumber = Request["RowNumber"]; string qty = Request["qty"]; string errorEdit = ""; List <string> sqlEdits = new List <string>(); string sqlEdit = string.Format(@" update MachineOderDetail set DeliveryQty={0} ,NondeliveryQty=Qty-{0} where OdersNumber='{1}' and ProductNumber='{2}' and Version='{3}' and RowNumber='{4}' ", qty, ordersNumber, productnumber, version, rowNumber); sqlEdits.Add(sqlEdit); sqlEdits.AddRange(GetChangeQtySqlList()); bool result = SqlHelper.BatchExecuteSql(sqlEdits, ref errorEdit); Response.Write(result ? "1" : errorEdit); Response.End(); return; } if (ToolManager.CheckQueryString("NewNumber")) { string oldNumber = ToolManager.GetQueryString("OldNumber"); string newNumber = ToolManager.GetQueryString("NewNumber"); hasEdit = ToolCode.Tool.GetUserMenuFuncStr("L0103", "Edit"); hasDelete = ToolCode.Tool.GetUserMenuFuncStr("L0103", "Delete"); string result = SaleOderManager.ConvertNumber(oldNumber, newNumber); if (result.Equals("1")) { Tool.WriteLog(Tool.LogType.Operating, "加工临时销售订单" + oldNumber + "转成正式订单" + newNumber, "转换成功"); } else { Tool.WriteLog(Tool.LogType.Operating, "加工临时销售订单" + oldNumber + "转成正式订单" + newNumber, "转换失败!原因:" + result); } Response.Write(result); Response.End(); return; } string sql = string.Empty; spAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Add"); spPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Print"); if (!ToolManager.CheckQueryString("id")) { Response.Write("未知销售订单"); Response.End(); return; } string odersnumber = ToolManager.GetQueryString("Id"); sql = string.Format(@"select c.MakeCollectionsModeId from SaleOder so inner join Customer c on so.CustomerId=c.CustomerId inner join MakeCollectionsMode mcm on c.MakeCollectionsModeId=mcm.Id where so.OdersNumber='{0}'", odersnumber); string makecollectionsmode = SqlHelper.GetScalar(sql); if (makecollectionsmode.Equals("YSBF")) { rp = "inline"; } else { rp = "none"; } string error = string.Empty; if (ToolManager.CheckQueryString("isDelete")) { string productnumber = ToolManager.GetQueryString("ProductNumber"); string version = ToolManager.GetQueryString("Version"); string rownumber = ToolManager.GetQueryString("RowNumber"); sql = string.Format("delete MachineOderDetail where OdersNumber='{0}' and ProductNumber='{1}' and Version='{2}' and RowNumber='{3}'", odersnumber, productnumber, version, rownumber); bool result = SqlHelper.ExecuteSql(sql, ref error); if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除加工销售订单明细" + odersnumber, "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除加工销售订单明细" + odersnumber, "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } sql = string.Format(@"select cu.CustomerName,cu.ContactTelephone,cu.Contacts,so.CustomerOrderNumber,cu.Fax,so.OrdersDate,so.OdersNumber,pu.USER_NAME from SaleOder so left join PM_USER pu on so.ContactId=pu.USER_ID left join Customer cu on so.CustomerId=cu.CustomerId where so.OdersNumber='{0}'", odersnumber); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblContacts.Text = dr["Contacts"] == null ? "" : dr["Contacts"].ToString(); lblCustomerName.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString(); lblCutomerId.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString(); lblOrdersDate.Text = dr["OrdersDate"] == null ? "" : dr["OrdersDate"].ToString(); lblOdersNumber.Text = dr["CustomerOrderNumber"] == null ? "" : dr["CustomerOrderNumber"].ToString(); lblFax.Text = dr["Fax"] == null ? "" : dr["Fax"].ToString(); lblUserName.Text = dr["USER_NAME"] == null ? "" : dr["USER_NAME"].ToString(); lblContactTelephone.Text = dr["ContactTelephone"] == null ? "" : dr["ContactTelephone"].ToString(); } Bind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //删除 if (ToolManager.CheckQueryString("ids")) { string error = string.Empty; List <string> sqls = new List <string>(); string orderNumbers = ToolManager.GetQueryString("ids"); string sql = string.Format(" delete TradingOrderDetail where OdersNumber in ({0}) ", orderNumbers); sqls.Add(sql); sql = string.Format("delete MachineOderDetail where OdersNumber in ({0})", orderNumbers); sqls.Add(sql); sql = string.Format(" delete SaleOder where OdersNumber in ({0})", orderNumbers); sqls.Add(sql); bool result = SqlHelper.BatchExecuteSql(sqls, ref error); if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除销售订单" + ToolManager.ReplaceSingleQuotesToBlank(orderNumbers), "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除销售订单" + ToolManager.ReplaceSingleQuotesToBlank(orderNumbers), "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } //转成正式订单 if (ToolManager.CheckQueryString("IsChangeType")) { string orderNumbers = ToolManager.GetQueryString("id"); string sql = string.Format(@"update SaleOder set OdersType='正常订单' ,CustomerOrderNumber='{1}' where OdersNumber ='{0}' ", orderNumbers, ToolManager.GetQueryString("CustomerOrderNumber")); string error = string.Empty; if (SqlHelper.ExecuteSql(sql, ref error)) { Response.Write("ok"); Response.End(); return; } else { Response.Write(error); Response.End(); return; } } //审核 if (ToolManager.CheckQueryString("check")) { string orderNumbers = ToolManager.GetQueryString("check"); Response.Write(SaleOderManager.CheckSaleOrder(ToolCode.Tool.GetUser().UserNumber, orderNumbers)); Response.End(); return; } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPage("AddOrEditSaleOder2.aspx", "Transfer", "btnSearch", "350", "900"); } divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Add"); divCheck.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Audit"); divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Delete"); divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0103", "Exp"); hasEdit = ToolCode.Tool.GetUserMenuFuncStr("L0103", "Edit"); } }
protected void btnUpload_Click(object sender, EventArgs e) { string odersnumber = "XS" + DateTime.Now.ToString("yyyyMMddHHmmss"); string error = string.Empty; string sql = string.Empty; string ordersDate = txtOrdersDate.Text.Trim(); string odersType = drpOdersType.SelectedValue; string productType = drpProductType.SelectedValue; string isMinusStock = drpIsMinusStock.SelectedValue; string makeCollectionsMode = this.drpMakeCollectionsMode.SelectedValue; string customerId = drpClient.SelectedValue; string contactId = drpContact.SelectedValue; string remark = txtRemark.Text.Trim(); string customerordernumber = txtCustomerOrderNumber.Text; string khddH = txtKhddH.Text; // List<string> sqls = new List<string>(); string brand = string.Empty; string description = string.Empty; string unitPrice = string.Empty; string quantity = string.Empty; string name = string.Empty; SaleOder so = new SaleOder(); so.OrdersNumber = odersnumber; so.OrdersDate = ordersDate; so.OdersType = odersType; so.ProductType = productType; so.MakeCollectionsMode = makeCollectionsMode; so.CustomerId = customerId; so.ContactId = contactId; so.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); so.CustomerOrderNumber = customerordernumber; so.KhddH = khddH; so.Remark = remark; so.CustomerName = drpClient.SelectedItem.Text.Trim(); string userId = ToolCode.Tool.GetUser().UserNumber; bool result = SaleOderManager.BacthAddSaleOrderNew(so, FU_Excel, Server, userId, ref error); if (result == true) { lbMsg.Text = "导入成功"; Tool.WriteLog(Tool.LogType.Operating, "导入销售订单", "导入成功!"); return; } else { lbMsg.Text = error; Tool.WriteLog(Tool.LogType.Operating, "导入销售订单", "导入失败!原因" + lbSubmit.Text); return; } // sql = string.Format(@"insert into SaleOder (OdersNumber ,OrdersDate,OdersType,ProductType //,IsMinusStock,MakeCollectionsMode,CustomerId,ContactId ,OrderStatus,CreateTime ,Remark,CustomerOrderNumber ,KhddH) //values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','未完成','{8}','{9}','{10}','{11}')", odersnumber, // ordersDate, odersType, productType, isMinusStock, makeCollectionsMode, customerId, contactId // , DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), remark, customerordernumber, khddH); // sqls.Add(sql); //DataSet ds = ToolManager.ImpExcel(this.FU_Excel, Server); //if (ds == null) //{ // lbMsg.Text = "选择的文件为空或不是标准的Excel文件!"; // return; //} // foreach (DataRow dr in ds.Tables[0].Rows) // { // quantity =dr["订单数量"].ToString(); // sql = string.Format(@"select count(*) from MaterialCustomerProperty where CustomerMaterialNumber='{0}'", dr["客户物料编号"]); // string num = SqlHelper.GetScalar(sql); // if (num == "0") // { // lbSubmit.Text += string.Format("贸易销售订单{0}添加失败!原因:该原材料不存在客户物料编号<br/>", dr["客户物料编号"]); // i++; // continue; // } // sql = string.Format(@" select MaterialNumber from MaterialCustomerProperty where CustomerMaterialNumber='{0}' and CustomerId=(select CustomerId from SaleOder where OdersNumber='{1}') //", dr["客户物料编号"], odersnumber); // string productNumber = SqlHelper.GetScalar(sql); // if (productNumber.Equals("")) // { // lbSubmit.Text += string.Format("贸易销售订单{0}添加失败!原因:该客户原材料编号不存在<br/>", dr["客户物料编号"]); // i++; // continue; // } // sql = string.Format(@"select Description,Brand,ProcurementPrice,MaterialName from MarerialInfoTable where MaterialNumber='{0}'", productNumber); // dt = SqlHelper.GetTable(sql, ref error); // if (dt.Rows.Count > 0) // { // brand = dt.Rows[0]["Brand"].ToString(); // description = dt.Rows[0]["Description"].ToString(); // unitPrice = dt.Rows[0]["ProcurementPrice"].ToString(); // name=dt.Rows[0]["MaterialName"].ToString(); // qty = string.IsNullOrEmpty(quantity) ? 0 : Convert.ToInt32(quantity); // uprice = string.IsNullOrEmpty(unitPrice) ? 0 : Convert.ToDecimal(unitPrice); // totalPrice = qty * uprice; // } // sql = string.Format(@" //select * from TradingOrderDetail where OdersNumber ='{0}' and ProductNumber='{1}' and RowNumber='{2}'", odersnumber, productNumber, dr["行号"]); // dt = SqlHelper.GetTable(sql, ref error); // if (dt.Rows.Count > 0) // { // lbSubmit.Text += string.Format("贸易销售订单{0}添加失败!原因:此记录已存在<br/>", odersnumber); // i++; // continue; // } // sql = string.Format(@" insert into TradingOrderDetail (OdersNumber,SN,ProductNumber,RowNumber ,CustomerMaterialNumber,MaterialName //,Brand,Quantity,NonDeliveryQty,DeliveryQty,UnitPrice,TotalPrice,Delivery,CreateTime,Remark,Status,ProductModel) //values('{0}',{1},'{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10},{11},'{12}','{13}','{14}','{15}','{16}')" // , odersnumber, dr["序号"], productNumber, dr["行号"], dr["客户物料编号"], description, brand, qty, qty, 0 // , uprice, totalPrice, dr["交期"], DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), remark,"未完成",name); // sqls.Add(sql); // } // bool result = false; // if (i == 0) // { // result = true; // } // if (result == true) // { // lbMsg.Text = "导入成功!"; // } // else // { // lbMsg.Text = "导入失败!<br/>" + lbSubmit.Text; // } //if (result == true) //{ // Tool.WriteLog(Tool.LogType.Operating, "导入贸易销售订单", "导入成功!"); // return; //} //else //{ // Tool.WriteLog(Tool.LogType.Operating, "导入贸易销售订单", "导入失败!原因" + lbSubmit.Text); // return; //} }