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;
//}
}
