protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Add"); //divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Delete"); if (!ToolManager.CheckQueryString("Id")) { Response.Write("请选择原材料!"); Response.End(); return; } string error = string.Empty; string sql = " select * from MarerialInfoTable where materialnumber='" + ToolManager.GetQueryString("Id") + "'"; DataTable dt = DAL.SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count <= 0) { Response.Write("已删除该原材料编号!请刷新后重新选择原材料!"); Response.End(); return; } //删除 if (ToolManager.CheckQueryString("ids")) { string temp = MaterialCustomerPropertyManager.DeleteData(ToolManager.GetQueryString("ids")); string id = ToolManager.GetQueryString("Id"); bool restult = temp == "1" ? true : false; if (restult) { Tool.WriteLog(Tool.LogType.Operating, "删除原材料客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除成功"); Response.Write(temp); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除原材料客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除失败!原因" + temp); Response.Write(temp); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPageMaterialCustomer("AddOrEditMaterialCustomerProperty.aspx", "btnSearch", "260", "600"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!ToolManager.CheckQueryString("id")) { Response.Write("请选择包编码!"); Response.End(); return; } string error = string.Empty; string sql = " select * from PackageInfo where PackageNumber='" + ToolManager.GetQueryString("id") + "'"; DataTable dt = DAL.SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count <= 0) { Response.Write("已删除该包编码!请刷新后重新选择包编码!"); Response.End(); return; } //删除 if (ToolManager.CheckQueryString("ids")) { string id = ToolManager.GetQueryString("id"); string temp = MaterialCustomerPropertyManager.Delete(id, ToolManager.GetQueryString("ids")); bool restult = temp == "1" ? true : false; if (restult) { Tool.WriteLog(Tool.LogType.Operating, "删除包客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除成功"); Response.Write(temp); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除包客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除失败!原因" + temp); Response.Write(temp); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPageMaterialCustomer("AddOrEditPackageInfoCustomerProperty.aspx", "btnSearch", "260", "600"); } } }
protected void btnSubmit_Click(object sender, EventArgs e) { Check(); HasOdersNumber(); string error = string.Empty; string sql = string.Empty; DataTable dt; string OdersNumber = ToolManager.GetQueryString("OdersNumber"); string sn = txtSN.Text.Trim(); string productNumber = string.Empty; //string customerMareial = txtCustomerMarerial.SelectedValue; string customerMareial = txtUniversalNumber.Text; //string productModel = txtProductModel.Text.Trim(); string rowNumber = txtRowNumber.Text.Trim(); string quantity = Request.Form["txtQuantity"].ToString(); int qty = string.IsNullOrEmpty(quantity) ? 0 : Convert.ToInt32(quantity); string unitPrice = txtUnitPrice.Text; decimal uprice = string.IsNullOrEmpty(unitPrice) ? 0 : Convert.ToDecimal(unitPrice); string delivery = txtDelivery.Text.Trim(); string remark = txtRemark.Text.Trim(); string receiveone = txtReceiveOne.Text.Trim().Equals("") ? "0" : txtReceiveOne.Text.Trim(); string receivetwo = txtReceiveTwo.Text.Trim().Equals("") ? "0" : txtReceiveTwo.Text.Trim(); bool result = false; decimal totalPrice = 0; try { Convert.ToDouble(receiveone); Convert.ToDouble(receivetwo); } catch (Exception ex) { lbSubmit.Text = "收款一和收款二都必须输入整数或小数!"; return; } if (btnSubmit.Text.Equals("添加")) { if (HasDbRowNumber(OdersNumber, rowNumber)) { lbSubmit.Text = "已有此行号请重新填写,行号在整个订单内不能重复"; //BindCustomer(productNumber, customerMareial); return; } if (drpType.SelectedValue == "供应商物料编号") { sql = string.Format(@"select top 1 MaterialNumber from MaterialSupplierProperty where SupplierMaterialNumber='{0}'", txtUniversalNumber.Text.Trim()); if (SqlHelper.GetScalar(sql).Equals("")) { lbSubmit.Text = "未知的供应商物料编号!"; return; } else { productNumber = SqlHelper.GetScalar(sql); } } if (drpType.SelectedValue == "客户物料编号") { string mNumber = MaterialCustomerPropertyManager.GetMaterialNumberByOderNumberAndCustomerMN( txtUniversalNumber.Text.Trim(), OdersNumber); //sql = string.Format(@"select top 1 MaterialNumber from MaterialCustomerProperty where CustomerMaterialNumber='{0}'", txtUniversalNumber.Text.Trim()); if (string.IsNullOrEmpty(mNumber)) { lbSubmit.Text = "未知的客户物料编号!"; return; } else { productNumber = mNumber; } } if (drpType.SelectedValue == "瑞普迪编号") { sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where MaterialNumber='{0}'", txtUniversalNumber.Text.Trim()); if (SqlHelper.GetScalar(sql).Equals("")) { lbSubmit.Text = "未知的瑞普迪编号!"; return; } else { productNumber = SqlHelper.GetScalar(sql); } } if (drpType.SelectedValue == "物料描述") { sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where Description='{0}'", txtUniversalNumber.Text.Trim()); if (SqlHelper.GetScalar(sql).Equals("")) { lbSubmit.Text = "未知的物料描述!"; return; } else { productNumber = SqlHelper.GetScalar(sql); } } sql = string.Format(@"select Description,Brand 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(); } sql = string.Format(@"select * from [V_FindPriceForNewForTrading] where 原材料编号='{0}' and 客户编号=( select CustomerId from SaleOder where OdersNumber='{1}')", productNumber, OdersNumber); dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { sql = string.Format(@"select 单价 from V_FindLastNewPriceForTradingQuoteDetail where 原材料编号='{0}' and customerId=( select CustomerId from SaleOder where OdersNumber='{1}')", productNumber, OdersNumber); unitPrice = SqlHelper.GetScalar(sql); qty = string.IsNullOrEmpty(quantity) ? 0 : Convert.ToInt32(quantity); txtUnitPrice.Text = unitPrice; 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, rowNumber); dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { lbSubmit.Text = "已有此记录请重新填写!"; //BindCustomer(productNumber, customerMareial); return; } sql = string.Format(@" insert into TradingOrderDetail (OdersNumber,SN,ProductNumber,RowNumber ,CustomerMaterialNumber,MaterialName ,Brand,Quantity,NonDeliveryQty,DeliveryQty,UnitPrice,TotalPrice,Delivery,CreateTime,Remark,ReceiveOne,ReceiveTwo) values('{0}',{1},'{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10},{11},'{12}','{13}','{14}','{15}','{16}')" , OdersNumber, sn, productNumber, rowNumber, customerMareial, description, brand, qty, qty, 0 , uprice, totalPrice, delivery, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), remark, receiveone, receivetwo); result = SqlHelper.ExecuteSql(sql, ref error); lbSubmit.Text = result == true ? "添加成功!" : "添加失败!原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "增加贸易销售订单明细" + OdersNumber, "增加成功"); //BindCustomer(productNumber, customerMareial); return; } else { Tool.WriteLog(Tool.LogType.Operating, "增加贸易销售订单明细" + OdersNumber, "增加失败!原因" + error); //BindCustomer(productNumber, customerMareial); return; } } else { HasDeleted(); unitPrice = txtUnitPrice.Text.Trim(); totalPrice = qty * uprice; string rownumber = ToolManager.GetQueryString("RowNumber"); sql = string.Format(@" select * from TradingOrderDetail where OdersNumber ='{0}' and ProductNumber='{1}' and rownumber='{2}' and rownumber!='{3}'", OdersNumber, productNumber, delivery, rownumber); dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { lbSubmit.Text = "已有此记录请重新填写!"; //BindCustomer(productNumber, customerMareial); return; } sql = string.Format(@" update TradingOrderDetail set SN={0}, Quantity={1},NonDeliveryQty={2},UnitPrice={3},TotalPrice ={4} ,Delivery='{5}',Remark ='{6}',ReceiveOne='{10}',ReceiveTwo='{11}' where OdersNumber ='{7}' and RowNumber='{8}' and ProductNumber='{9}' ", sn, qty, qty, uprice, totalPrice, delivery, remark, lblOdersNumber.Text, rownumber, txtMarerial.Text, receiveone, receivetwo); result = SqlHelper.ExecuteSql(sql, ref error); lbSubmit.Text = result == true ? "修改成功!" : "修改失败!原因:" + error; if (result) { Tool.WriteLog(Tool.LogType.Operating, "编辑贸易销售订单明细" + lblOdersNumber.Text, "编辑成功"); return; } else { Tool.WriteLog(Tool.LogType.Operating, "编辑贸易销售订单明细" + lblOdersNumber.Text, "编辑失败!原因" + error); //BindCustomer(productNumber, customerMareial); return; } } }
private DataTable GetTable() { Dictionary <string, Dictionary <string, string> > marerialCustomerNames = MaterialCustomerPropertyManager.GetMarerialCustomerNames(); DataTable dtResult = SqlHelper.GetTable(GetSql()); dtResult.Columns.Add("CustomerNames"); foreach (DataRow dr in dtResult.Rows) { if (marerialCustomerNames.ContainsKey(dr["原材料编号"].ToString().Trim())) { dr["CustomerNames"] = GetCustomerNames(marerialCustomerNames, dr["原材料编号"].ToString().Trim());; } } string customerName = txtCustomerName.Text.Trim(); if (!string.IsNullOrEmpty(customerName)) { DataRow[] tempRows = dtResult.Select("CustomerNames like '%" + customerName + "%'"); if (tempRows != null && tempRows.Length > 0) { dtResult = tempRows.CopyToDataTable <DataRow>(); } else { dtResult.Rows.Clear(); } } if (dtResult != null && dtResult.Rows != null && dtResult.Rows.Count > 0) { double sumStockQty = Convert.ToDouble(dtResult.Compute("sum(库存数量)", "true")); double sumStockPrice = Convert.ToDouble(dtResult.Compute("sum(库存金额)", "true")); DataRow sumRow = dtResult.NewRow(); sumRow["库存数量"] = sumStockQty; sumRow["库存金额"] = sumStockPrice; dtResult.Rows.Add(sumRow); } return(dtResult); }