public void ProcessRequest(HttpContext context) { string result = string.Empty; string sql = string.Empty; //取原材料或者产品 if (ToolManager.CheckQueryString("IsMaterial")) { //原材料 if (ToolManager.GetQueryString("IsMaterial").Equals("true")) { sql = string.Format(@" select top 20 MaterialNumber,MaterialName from MarerialInfoTable "); sql += string.Format(@" where MaterialNumber like '%{0}%' or MaterialNumber like'%{0}' or MaterialNumber like '{0}%' or MaterialName like '%{0}%' or MaterialName like'%{0}' or MaterialName like '{0}%' order by MaterialNumber asc", ToolManager.GetQueryString("MaterialNumber")); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { result += string.Format(" <tr><td>{0}</td><td>{1}</td></tr>", dr["MaterialName"], dr["MaterialNumber"]); } } } else//产品 { } } //取库存数量 if (ToolManager.CheckQueryString("TableName")) { string tableName = ToolManager.GetQueryString("TableName"); string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber"); //出入库编号 string supplierMaterialNumberStr = string.Empty; //供应商物料编号字符串 string customerMaterialNumberStr = string.Empty; //客户物料编号字符串 string qty = string.Empty; //库存数量 //原材料 if (ToolManager.GetQueryString("IsMaterialForQty").Equals("true")) { string materialNumber = ToolManager.GetQueryString("MaterialNumber"); //原材料编号 sql = string.Format(@"select SupplierMaterialNumber from MaterialSupplierProperty where MaterialNumber='{0}'", materialNumber); supplierMaterialNumberStr = ControlBindManager.GetOption(sql, "SupplierMaterialNumber", "SupplierMaterialNumber"); sql = string.Format(@" select CustomerMaterialNumber from MaterialCustomerProperty where MaterialNumber='{0}'", materialNumber); customerMaterialNumberStr = ControlBindManager.GetOption(sql, "CustomerMaterialNumber", "CustomerMaterialNumber"); qty = StoreroomToolManager.GetinventoryQty(materialNumber, "", "", warehouseNumber, tableName, ToolEnum.ProductType.Marerial); result = supplierMaterialNumberStr + "^" + customerMaterialNumberStr + "^" + qty; } else //产品 { } } context.Response.ContentType = "text/plain"; context.Response.Write(result); }
private void BindDrpProduct() { string sql = string.Format(@"select distinct (mo.ProductNumber+'^'+mo.Version) as Value, (mo.ProductName+' 【'+mo.Version+'】') as Text from Product mo order by Text asc"); ControlBindManager.BindDrp(sql, this.drpProduct, "Value", "Text"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select distinct USER_NAME,USER_ID from PM_USER", drpName, "USER_ID", "USER_NAME"); LoadPage(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string sql = string.Format(" select OdersNumber from SaleOder where ProductType ='贸易' and OdersType ='样品订单' and OrderStatus ='未完成' and ISNULL( CheckTime ,'')!='' "); ControlBindManager.BindDrp(sql, drpOrderNumber, "OdersNumber", "OdersNumber"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select distinct PaymentMode from PaymentMode", this.drpPaymentMode, "PaymentMode", "PaymentMode"); LoadPage(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lbWarehouseNumber.Text = ToolManager.GetQueryString("WarehouseNumber"); Warehouse(); ControlBindManager.BindSupplier(this.drpGYSID); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { spPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0409", "Print"); ControlBindManager.BindDrp(@"select distinct OdersNumber from SaleOder where ProductType='加工' and OrderStatus='未完成' and isnull(CheckTime,'')!=''", drpOdersNumber, "OdersNumber", "OdersNumber"); PageSearch(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select Id,PaymentMode from PaymentMode", drpPaymentMode, "Id", "PaymentMode"); ControlBindManager.BindDrp("select SupplierId,SupplierName from SupplierInfo", drpSupplierId, "SupplierId", "SupplierName"); ControlBindManager.BindDrp("select [USER_ID],[USER_NAME] from PM_USER", drpContactId, "USER_ID", "USER_NAME"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp(" select WorkSnNumber,WorkSnName from WorkSn ", drpWorkSnNumber, "WorkSnNumber", "WorkSnName"); if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version")) { string ProductNumber = ToolManager.GetQueryString("ProductNumber"); string Version = ToolManager.GetQueryString("Version"); string tempSql = string.Format(@"select CustomerProductNumber from ProductCustomerProperty where ProductNumber ='{0}' and Version ='{1}'", ProductNumber, Version); string temp = string.Empty; foreach (DataRow drT in SqlHelper.GetTable(tempSql).Rows) { temp += drT["CustomerProductNumber"] == null ? "" : drT["CustomerProductNumber"].ToString() + ","; } lbCustomerProductNumber.Text = temp.TrimEnd(','); string WorkSnNumber = Server.UrlDecode(ToolManager.GetQueryString("WorkSnNumber")); string error = string.Empty; string sql = string.Format(@" select * from ProductWorkSnProperty where ProductNumber='{0}' and Version='{1}' and WorkSnNumber='{2}'", ProductNumber, Version, WorkSnNumber); if (!ToolManager.CheckQueryString("WorkSnNumber")) { this.btnSubmit.Text = "添加"; this.lbWorkSnNumber.Visible = false; } else { this.btnSubmit.Text = "修改"; this.drpWorkSnNumber.Visible = false; this.lbWorkSnNumber.Visible = true; sql = string.Format(@" select * from ProductWorkSnProperty where ProductNumber='{0}' and Version='{1}' and WorkSnNumber='{2}'", ProductNumber, Version, WorkSnNumber); DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lbProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString(); lbVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString(); lbWorkSnNumber.Text = WorkSnNumber; txtRowNumber.Text = dr["RowNumber"] == null ? "" : dr["RowNumber"].ToString(); txtRatedManhour.Text = dr["RatedManhour"] == null ? "" : dr["RatedManhour"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } this.lbProductNumber.Text = ProductNumber; this.lbVersion.Text = Version; } else { Response.Write("请选择产成品编号、版本!"); Response.End(); return; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string getsupSql = "select SupplierId,SupplierName from SupplierInfo order by SupplierName asc"; DataTable dtSupplier = SqlHelper.GetTable(getsupSql); foreach (DataRow dr in dtSupplier.Rows) { SupplierIds += dr["SupplierName"] + ","; } SupplierIds = SupplierIds.TrimEnd(','); ControlBindManager.BindDrp("select Id,PaymentMode from PaymentMode", drpPaymentMode, "Id", "PaymentMode"); //ControlBindManager.BindDrp("select SupplierId,SupplierName from SupplierInfo order by SupplierName asc", drpSupplierId, "SupplierId", "SupplierName"); ControlBindManager.BindDrp("select [USER_ID],[USER_NAME] from PM_USER", drpContactId, "USER_ID", "USER_NAME"); if (ToolManager.CheckQueryString("OrdersNumber")) { string ordersNumber = ToolManager.GetQueryString("OrdersNumber"); if (!CheckHas(ordersNumber)) { Response.Write("该采购订单不存在!"); Response.End(); return; } string sql = string.Format(" select * from CertificateOrders where OrdersNumber='{0}' ", ordersNumber); DataTable dt = SqlHelper.GetTable(sql); DataRow dr = dt.Rows[0]; txtOrdersDate.Text = dr["OrdersDate"] == null ? "" : dr["OrdersDate"].ToString(); drpPaymentMode.SelectedValue = dr["PaymentMode"] == null ? "" : dr["PaymentMode"].ToString(); //drpSupplierId.SelectedValue = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString(); DataRow[] drs = dtSupplier.Select("SupplierId='" + dr["SupplierId"] + "'"); if (drs.Length > 0) { this.SupplierName.Value = drs[0]["SupplierName"].ToString(); } drpContactId.SelectedValue = dr["ContactId"] == null ? "" : dr["ContactId"].ToString(); drpOrderType.SelectedValue = dr["OrderType"].ToString(); txtHTNumber.Text = dr["HTNumber"] == null ? "" : dr["HTNumber"].ToString(); txtOrderNumber.Text = ordersNumber; txtOrderNumber.ReadOnly = true; txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); btnSubmit.Text = "修改"; } else { btnSubmit.Text = "添加"; txtOrderNumber.ReadOnly = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select USER_ID,USER_NAME from PM_USER", this.drpImportPerson, "USER_ID", "USER_NAME"); if (ToolManager.CheckQueryString("MaterialNumber")) { string MaterialNumber = ToolManager.GetQueryString("MaterialNumber"); string error = string.Empty; string FileName = Server.UrlDecode(ToolManager.GetQueryString("FileName")); string sql = string.Format(@" select * from MaterialBlueprintProperty where MaterialNumber='{0}' and FileName='{1}' ", MaterialNumber, FileName); if (!ToolManager.CheckQueryString("FileName")) { this.btnSubmit.Text = "添加"; this.txtFileName.Visible = true; this.lbFileName.Visible = false; this.lbMaterialNumber.Text = MaterialNumber; this.trModifyTime.Visible = false; this.trImportTime.Visible = false; this.txtImportTime.Text = DateTime.Now.ToString(); } else { this.btnSubmit.Text = "修改"; trFileUrl.Visible = false; this.txtFileName.Visible = false; this.lbFileName.Visible = true; this.trModifyTime.Visible = false; this.trImportTime.Visible = false; this.drpImportPerson.Visible = false; this.txtModifyTime.Text = DateTime.Now.ToString(); DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; this.lbFileName.Text = dr["FileName"] == null ? "" : dr["FileName"].ToString(); this.txtModifyTime.Text = dr["ModifyTime"] == null ? "" : dr["ModifyTime"].ToString(); this.txtImportTime.Text = dr["ImportTime"] == null ? "" : dr["ImportTime"].ToString(); sql = string.Format(@" select USER_NAME from PM_USER where USER_ID='{0}'", dr["ImportPerson"] == null ? "" : dr["ImportPerson"].ToString()); string importpersion = SqlHelper.GetScalar(sql); this.lblImportPerson.Text = importpersion; this.txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); } } this.lbMaterialNumber.Text = MaterialNumber; } else { Response.Write("请选择原材料!"); Response.End(); } } }
private void BindProduct(string documentNumber, string value) { string sql = string.Format(@"select distinct (mo.MaterialNumber+'^'+mo.Version) as Value, (p.ProductName+' 【'+mo.Version+'】') as Text from (select * from StockInventoryLogDetail where [Version] !='0') mo inner join Product p on mo.MaterialNumber=p.ProductNumber where mo.InventoryNumber='{0}' ", documentNumber); ControlBindManager.BindDrp(sql, this.drpProduct, "Value", "Text"); drpProduct.SelectedValue = value; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='废品库'", this.drpScrapPosition, "WarehouseNumber", "WarehouseName"); ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='原材料库'", this.drpMaterialPosition, "WarehouseNumber", "WarehouseName"); drpMaterialPosition.SelectedValue = "ycl"; drpScrapPosition.SelectedValue = "fpk"; LoadPage(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.trCheckTime.Visible = false; this.trCreateTime.Visible = false; this.trAuditor.Visible = false; string WarehouseNumber = ToolManager.GetQueryString("WarehouseNumber"); // ScarpWarehouseLogManager.BindWarehouseName(this.drpWarehouseName); ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='原材料库'", this.drpWarehouseName, "WarehouseNumber", "WarehouseName"); drpWarehouseName.SelectedValue = "ycl"; string error = string.Empty; string sql = string.Format(@" select * from MarerialWarehouseLog where WarehouseNumber='{0}' ", WarehouseNumber); if (!ToolManager.CheckQueryString("WarehouseNumber")) { this.btnSubmit.Text = "添加"; this.lbWarehouseNumber.Visible = false; trWarehouseNumber.Visible = false; } else { this.btnSubmit.Text = "修改"; DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; this.txtWarehouseNumber.Text = dr["WarehouseNumber"] == null ? "" : dr["WarehouseNumber"].ToString(); this.drpWarehouseName.SelectedValue = dr["WarehouseName"] == null ? "" : dr["WarehouseName"].ToString(); this.drpChangeDirection.SelectedValue = dr["ChangeDirection"] == null ? "" : dr["ChangeDirection"].ToString(); this.drpType.Items.Clear(); this.drpType.DataSource = bind(); this.drpType.DataValueField = "InOutType"; this.drpType.DataTextField = "InOutType"; this.drpType.DataBind(); this.drpType.SelectedValue = dr["Type"] == null ? "" : dr["Type"].ToString(); this.txtCreator.Text = dr["Creator"] == null ? "" : dr["Creator"].ToString(); this.txtCreateTime.Text = dr["CreateTime"] == null ? "" : dr["CreateTime"].ToString(); this.txtCheckTime.Text = dr["CheckTime"] == null ? "" : dr["CheckTime"].ToString(); this.txtAuditor.Text = dr["Auditor"] == null ? "" : dr["Auditor"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; this.txtWarehouseNumber.Visible = false; this.lbWarehouseNumber.Text = ToolManager.GetQueryString("WarehouseNumber"); trWarehouseNumber.Visible = true; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { drpOdersType.Items.Add("正常订单"); drpOdersType.Items.Add("加急订单"); drpOdersType.Items.Add("维修订单"); drpOdersType.Items.Add("临时订单"); drpOdersType.Items.Add("样品订单"); drpOdersType.Items.Add("MRP订单"); drpOdersType.Items.Add("包装生产订单"); ControlBindManager.BindDrp("select CustomerId,CustomerName from Customer", drpClient, "CustomerId", "CustomerName"); //用户名称 ControlBindManager.BindDrp("select user_id, USER_NAME from PM_USER", this.drpContact, "user_id", "USER_NAME"); ControlBindManager.BindDrp("select id,makecollectionsmode from MakeCollectionsMode", this.drpMakeCollectionsMode, "id", "makecollectionsmode"); if (ToolManager.CheckQueryString("id")) { string odersNumber = ToolManager.GetQueryString("id"); string error = string.Empty; string sql = string.Format(" select * from SaleOder where OdersNumber='{0}'", odersNumber); DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count <= 0) { Response.Write("未知订单,该订单不存在或已被删除!"); Response.End(); return; } DataRow dr = dt.Rows[0]; txtOrdersDate.Text = dr["OrdersDate"] == null ? "" : dr["OrdersDate"].ToString(); drpOdersType.SelectedValue = dr["OdersType"] == null ? "" : dr["OdersType"].ToString(); drpProductType.SelectedValue = dr["ProductType"] == null ? "" : dr["ProductType"].ToString(); drpIsMinusStock.SelectedValue = dr["IsMinusStock"] == null ? "" : dr["IsMinusStock"].ToString(); this.drpMakeCollectionsMode.SelectedValue = dr["MakeCollectionsMode"] == null ? "" : dr["MakeCollectionsMode"].ToString(); drpClient.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); drpContact.SelectedValue = dr["ContactId"] == null ? "" : dr["ContactId"].ToString(); drpStatus.SelectedValue = dr["OrderStatus"] == null ? "" : dr["OrderStatus"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); txtCustomerOrderNumber.Text = dr["CustomerOrderNumber"] == null ? "" : dr["CustomerOrderNumber"].ToString(); tdStatus.Visible = true; btnSubmit.Text = "修改"; //txtOrderNumber.Text = odersNumber; //txtOrderNumber.ReadOnly = true; } else { tdStatus.Visible = false; //txtOrderNumber.ReadOnly = false; btnSubmit.Text = "添加"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select WarehouseName from WarehouseInfo where Type='半成品库'", this.drpHalfProductPosition, "WarehouseName", "WarehouseName"); ControlBindManager.BindDrp("select WarehouseName from WarehouseInfo where Type='产成品库'", this.drpFinishedGoodsPosition, "WarehouseName", "WarehouseName"); drpFinishedGoodsPosition.SelectedValue = "产成品库"; drpHalfProductPosition.SelectedValue = "半成品库"; this.trRatedManhour.Visible = false; this.trCostPrice.Visible = false; LoadPage(); } }
protected void btnSearch_Click(object sender, EventArgs e) { string date = txtDate.Text; string productNumber = txtProductNumber.Text; string customerProductNumber = txtCustomerProductNumber.Text; string customername = txtCustomerName.Text.Trim(); string type = Server.UrlDecode(ToolManager.GetQueryString("Type")); string sql = string.Empty; if (type.Equals("包装销售出库")) { sql = string.Format(@"select distinct vj.OdersNumber, vj.OdersNumber +' ('+vj.CustomerOrderNumber+')' as oderName from (select * from SaleOder where ProductType ='加工' and ISNULL (CheckTime ,'')!='' and OrderStatus ='未完成') vj left join MachineOderDetail modt on vj.OdersNumber =modt.OdersNumber where vj.OdersType in('包装生产订单') "); } else { sql = string.Format(@"select distinct vj.OdersNumber, vj.OdersNumber +' ('+vj.CustomerOrderNumber+')' as oderName from (select * from SaleOder where ProductType ='加工' and ISNULL (CheckTime ,'')!='' and OrderStatus ='未完成') vj left join MachineOderDetail modt on vj.OdersNumber =modt.OdersNumber where vj.OdersType in('正常订单','加急订单') "); } if (!string.IsNullOrEmpty(date)) { sql += string.Format(" and modt.LeadTime <='{0}' ", date); } if (!string.IsNullOrEmpty(productNumber)) { sql += string.Format(" and modt.ProductNumber ='{0}' ", productNumber); } if (!string.IsNullOrEmpty(customerProductNumber)) { //sql += string.Format(" and modt.customerProductNumber='{0}' ", customerProductNumber); sql += string.Format(@"and vj.OdersNumber in (select distinct so.OdersNumber from SaleOder so inner join MachineOderDetail modt on so.OdersNumber=modt.OdersNumber where so.ProductType ='加工' and ISNULL (so.CheckTime ,'')!='' and so.OrderStatus ='未完成' and modt.CustomerProductNumber = '{0}' and modt.Status ='未完成' )", customerProductNumber); } if (!string.IsNullOrEmpty(customername)) { sql += string.Format(" and vj.CustomerId='{0}' ", customername); } sql += " order by vj.OdersNumber desc "; ControlBindManager.BindListBox(sql, drpOrdersNumber, "OdersNumber", "oderName"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version")) { ControlBindManager.BindCustomer(this.drpCustomer); string ProductNumber = Server.UrlDecode(ToolManager.GetQueryString("ProductNumber")); string Version = Server.UrlDecode(ToolManager.GetQueryString("Version")); string CustomerId = Server.UrlDecode(ToolManager.GetQueryString("CustomerId")); string error = string.Empty; string sql = string.Format(" select * from ProductCustomerProperty where ProductNumber='{0}' and Version='{1}' and CustomerId='{2}'", ProductNumber, Version, CustomerId); if (!ToolManager.CheckQueryString("CustomerId")) { this.btnSubmit.Text = "添加"; this.lbCustomerProductNumber.Visible = false; this.txtCustomerProductNumber.Visible = true; } else { this.btnSubmit.Text = "修改"; this.lbCustomerProductNumber.Visible = true; this.txtCustomerProductNumber.Visible = false; this.drpCustomer.Visible = false; DataTable dt = SqlHelper.GetTable(sql, ref error); drpCustomer.Enabled = false; if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lbProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString(); lblCustomer.Text = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); lbVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString(); lbCustomerProductNumber.Text = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } this.lbProductNumber.Text = ProductNumber; this.lbVersion.Text = Version; } else { Response.Write("请选择产成品编号、版本!"); Response.End(); return; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("ChoosedVlaue")) { string selectedValuePid = ToolManager.GetQueryString("ChoosedVlaue"); string sql = string.Format(@" select Type from MareriaType where Pid='{0}'", selectedValuePid); Response.Write(ControlBindManager.GetOption(sql, "Type", "Type")); Response.End(); return; } //divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Add"); //divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Delete"); //divImp.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Imp"); //divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Exp"); //divPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Print"); } //删除 if (ToolManager.CheckQueryString("ids")) { string temp = MarerialInfoTableManager.DeleteData(Server.UrlDecode(Server.UrlDecode(ToolManager.GetQueryString("ids")))); string ids = ToolManager.GetQueryString("ids"); bool result = temp == "1" ? true : false; if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除原材料信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除成功"); Response.Write(temp); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除原材料信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除失败!原因" + temp); Response.Write(temp); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPage("AddOrEditMarerialInfoTable.aspx", "MarerialInfoTableDetailedList.aspx", "btnSearch", "550", "600"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("MaterialNumber")) { ControlBindManager.BindDrp("select * from SupplierInfo order by SupplierName asc", drpSupplierId, "SupplierId", "SupplierName"); string MaterialNumber = ToolManager.GetQueryString("MaterialNumber"); string supplierId = Server.UrlDecode(ToolManager.GetQueryString("SupplierId")); string error = string.Empty; string sql = string.Format(@" select * from MaterialSupplierProperty where MaterialNumber='{0}' and SupplierId='{1}' ", MaterialNumber, supplierId); if (!ToolManager.CheckQueryString("SupplierId")) { this.btnSubmit.Text = "添加"; this.lbMaterialNumber.Text = MaterialNumber; this.lbSupplierMaterialNumber.Visible = false; this.txtSupplierMaterialNumber.Visible = true; } else { this.btnSubmit.Text = "修改"; this.lbSupplierMaterialNumber.Visible = true; this.txtSupplierMaterialNumber.Visible = false; this.drpSupplierId.Enabled = false; DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lbSupplierMaterialNumber.Text = dr["SupplierMaterialNumber"] == null ? "" : dr["SupplierMaterialNumber"].ToString(); drpSupplierId.SelectedValue = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString(); txtMinOrderQty.Text = dr["MinOrderQty"] == null ? "" : dr["MinOrderQty"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); txtPrice.Text = dr["Prcie"] == null ? "" : dr["Prcie"].ToString(); txtDeliveryCycle.Text = dr["DeliveryCycle"] == null ? "" : dr["DeliveryCycle"].ToString(); } } this.lbMaterialNumber.Text = MaterialNumber; } else { Response.Write("请选择原材料!"); Response.End(); } } }
private void Search() { string date = txtDate.Text; string productNumber = txtProductNumber.Text.Trim(); string customerMaterialNumber = txtCustomerMaterialNumber.Text.Trim(); string customername = txtCustomerName.Text.Trim(); string cargotype = txtCargoType.Text.Trim(); string type = Server.UrlDecode(ToolManager.GetQueryString("Type")); string sql = string.Empty; sql = string.Format(@" select distinct MY.OdersNumber,MY.OdersNumber+'___'+'('+MY.customerordernumber+')' as OdersNumber_Name, MY.CreateTime from (select * from SaleOder where ProductType ='贸易' and ISNULL (CheckTime ,'')!='' and OrderStatus ='未完成') MY left join TradingOrderDetail tod on MY.OdersNumber =tod.OdersNumber inner join MarerialInfoTable mi on tod.ProductNumber=mi.MaterialNumber where 1=1"); if (!string.IsNullOrEmpty(date)) { sql += string.Format(" and tod.Delivery <='{0}' ", date); } if (!string.IsNullOrEmpty(productNumber)) { sql += string.Format(" and tod.ProductNumber ='{0}' ", productNumber); } if (!string.IsNullOrEmpty(customerMaterialNumber)) { //sql += string.Format(" and tod.CustomerMaterialNumber='{0}' ", customerMaterialNumber); sql += string.Format(@" and my.OdersNumber in ( select distinct OdersNumber from TradingOrderDetail where CustomerMaterialNumber='{0}' and Status='未完成')" , customerMaterialNumber); } if (!string.IsNullOrEmpty(customername)) { sql += string.Format(" and my.CustomerId='{0}'", customername); } if (!string.IsNullOrEmpty(cargotype)) { sql += string.Format(" and mi.CargoType='{0}'", cargotype); } sql += " order by my.CreateTime desc "; ControlBindManager.BindListBox(sql, drpOrdersNumber, "OdersNumber", "OdersNumber_Name"); foreach (ListItem item in drpOrdersNumber.Items) { item.Selected = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { drpOdersType.Items.Add("正常订单"); drpOdersType.Items.Add("加急订单"); drpOdersType.Items.Add("维修订单"); drpOdersType.Items.Add("临时订单"); drpOdersType.Items.Add("样品订单"); drpOdersType.Items.Add("MRP订单"); drpOdersType.Items.Add("包装生产订单"); ControlBindManager.BindDrp("select CustomerId,CustomerName from Customer", drpClient, "CustomerId", "CustomerName"); //用户名称 ControlBindManager.BindDrp("select user_id, USER_NAME from PM_USER", this.drpContact, "user_id", "USER_NAME"); ControlBindManager.BindDrp("select id,makecollectionsmode from MakeCollectionsMode", this.drpMakeCollectionsMode, "id", "makecollectionsmode"); } }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; ControlBindManager.BindDrp(" select id,MakeCollectionsMode from MakeCollectionsMode ", this.drpMakeCollectionsModeId, "id", "MakeCollectionsMode"); if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from Customer where CustomerId='{0}' ", ToolManager.GetQueryString("Id")); //sql = string.Format(@" select * from Customer where CustomerId='{0}' ", "5"); this.trCustomerNuber.Visible = false; Customer customer = CustomerInfoManager.ConvertDataTableToModel(sql); this.txtCustomerNumber.Text = customer.CustomerId; this.txtCustomerName.Text = customer.CustomerName; this.txtRegisteredAddress.Text = customer.RegisteredAddress; this.txtLegalPerson.Text = customer.LegalPerson; this.txtContacts.Text = customer.Contacts; this.txtRegisteredPhone.Text = customer.RegisteredPhone; this.txtContactTelephone.Text = customer.ContactTelephone; this.txtFax.Text = customer.Fax; this.txtMobilePhone.Text = customer.MobilePhone; this.txtZipCode.Text = customer.ZipCode; this.txtSparePhone.Text = customer.SparePhone; this.txtEmail.Text = customer.Email; this.txtQQ.Text = customer.QQ; this.txtAccountBank.Text = customer.AccountBank; this.txtSortCode.Text = customer.SortCode; this.txtBankAccount.Text = customer.BankAccount; this.txtTaxNo.Text = customer.TaxNo; this.txtWebsiteAddress.Text = customer.WebsiteAddress; this.txtDeliveryAddress.Text = customer.DeliveryAddress; //this.txtPaymentdays.Text = customer.Paymentdays.ToString(); //this.drpPercentageInAdvance.SelectedValue = customer.PercentageInAdvance.ToString(); this.txtRemark.Text = customer.Remark; this.drpMakeCollectionsModeId.SelectedValue = customer.MakeCollectionsModeId; this.txtFactoryAddress.Text = customer.FactoryAddress; this.drpReceiveType.SelectedValue = customer.ReceiveType; btnSubmit.Text = "修改"; } else { btnSubmit.Text = "添加"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("PackageNumber")) { ControlBindManager.BindCustomer(this.drpCustomer); string PackageNumber = ToolManager.GetQueryString("PackageNumber"); string customerid = Server.UrlDecode(ToolManager.GetQueryString("CustomerId")); string error = string.Empty; string sql = string.Format(@" select p.PackageNumber,c.CustomerName,p.CustomerPackageInfoNumber,p.Remark from PackageInfoCustomerProperty p left join Customer c on p.CustomerId=c.CustomerId where PackageNumber='{0}' and p.CustomerId='{1}'", PackageNumber, customerid); if (!ToolManager.CheckQueryString("CustomerId")) { this.btnSubmit.Text = "添加"; this.lbPackageNumber.Text = PackageNumber; this.lbCustomer.Visible = false; } else { this.btnSubmit.Text = "修改"; this.drpCustomer.Visible = false; this.lbPackageNumber.Text = PackageNumber; DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lbPackageNumber.Text = dr["PackageNumber"] == null ? "" : dr["PackageNumber"].ToString(); lbCustomer.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString(); txtCustomerPackageInfoNumber.Text = dr["CustomerPackageInfoNumber"] == null ? "" : dr["CustomerPackageInfoNumber"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } } else { Response.Write("请选择包编码!"); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("MaterialNumber")) { ControlBindManager.BindCustomer(this.drpCustomer); string MaterialNumber = ToolManager.GetQueryString("MaterialNumber"); string customerid = Server.UrlDecode(ToolManager.GetQueryString("CustomerId")); string error = string.Empty; string sql = string.Format(@" select * from MaterialCustomerProperty where MaterialNumber='{0}' and CustomerId='{1}'", MaterialNumber, customerid); if (!ToolManager.CheckQueryString("CustomerId")) { this.btnSubmit.Text = "添加"; this.lbMaterialNumber.Text = MaterialNumber; this.lbCustomerMaterialNumber.Visible = false; this.txtCustomerMaterialNumber.Visible = true; } else { this.btnSubmit.Text = "修改"; this.lbCustomerMaterialNumber.Visible = true; this.txtCustomerMaterialNumber.Visible = false; drpCustomer.Enabled = false; DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lbCustomerMaterialNumber.Text = dr["CustomerMaterialNumber"] == null ? "" : dr["CustomerMaterialNumber"].ToString(); drpCustomer.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } this.lbMaterialNumber.Text = MaterialNumber; } else { Response.Write("请选择原材料!"); Response.End(); } } }
private void BindCustomerNumber(HttpContext context) { if (ToolManager.CheckQueryString("versionP") && ToolManager.CheckQueryString("productNumberP")) { string error = string.Empty; string sql = string.Format(@" select CustomerProductNumber from ProductCustomerProperty where ProductNumber='{0}' and Version='{1}'", ToolManager.GetQueryString("productNumberP"), ToolManager.GetQueryString("versionP")); string result = ControlBindManager.GetOption(sql, "CustomerProductNumber", "CustomerProductNumber").Trim(); sql = string.Format("select ProductName from Product where ProductNumber='{0}' and Version ='{1}'", ToolManager.GetQueryString("productNumberP"), ToolManager.GetQueryString("versionP")); DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { string temp = dt.Rows[0]["ProductName"] == null ? "" : dt.Rows[0]["ProductName"].ToString(); result += "^" + temp; } context.Response.ContentType = "text/plain"; context.Response.Write(result); context.Response.End(); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select distinct USER_ID,USER_NAME from PM_USER", this.drpDeliveryPerson, "USER_ID", "USER_NAME"); if (ToolManager.CheckQueryString("id")) { ControlBindManager.BindDrp(@"select CustomerId,CustomerName from Customer", this.drpCustomerName, "CustomerId", "CustomerName"); string deliveryNumber = ToolManager.GetQueryString("id"); string error = string.Empty; string sql = string.Format("select * from DeliveryBill where DeliveryNumber='{0}'", deliveryNumber); DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count <= 0) { Response.Write("未知送货单,该送货单不存在或已被删除!"); Response.End(); return; } DataRow dr = dt.Rows[0]; drpDeliveryPerson.SelectedValue = dr["DeliveryPerson"] == null ? "" : dr["DeliveryPerson"].ToString(); txtDeliveryDate.Text = dr["DeliveryDate"] == null ? "" : dr["DeliveryDate"].ToString(); drpIsConfirm.SelectedValue = dr["IsConfirm"] == null ? "" : dr["IsConfirm"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); drpCustomerName.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); txtTel.Text = dr["Tel"] == null ? "" : dr["Tel"].ToString(); txtContactsName.Text = dr["ContactsName"] == null ? "" : dr["ContactsName"].ToString(); drpIsConfirm.Enabled = true; btnSubmit.Text = "修改"; } else { drpIsConfirm.Enabled = false; btnSubmit.Text = "添加"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindCustomer(drpCustomer); // ControlBindManager.BindDrp(" select distinct (USER_NAME) ,User_Id from PM_USER ", this.drpCustomerContact, "User_Id", "USER_NAME"); if (ToolManager.CheckQueryString("id")) { string error = string.Empty; string sql = string.Format(" select * from QuoteInfo where QuoteNumber='{0}'", ToolManager.GetQueryString("id")); DataTable dt = SqlHelper.GetTable(sql, ref error); DataRow dr = dt.Rows[0]; txtQuoteTime.Text = dr["QuoteTime"] == null ? "" : dr["QuoteTime"].ToString(); drpType.SelectedValue = dr["QuoteType"] == null ? "" : dr["QuoteType"].ToString(); drpCustomer.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); //用户名 //ControlBindManager.BindDrp(" select distinct (USER_NAME) ,User_Id from PM_USER ", this.drpCustomerContact, "User_Id", "USER_NAME"); txtCustomerContact.Text = dr["ContactId"] == null ? "" : dr["ContactId"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); btnSubmit.Text = "修改"; } } }
private void LoadPage() { if (!ToolManager.CheckQueryString("WarehouseNumber")) { Response.Write("未知出入库单"); Response.End(); return; } string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber"); lbWarehouseNumber.Text = warehouseNumber; string type = Server.UrlDecode(ToolManager.GetQueryString("Type")); titleName = type; var existNumbers = GetExistDocumentNumbers(warehouseNumber); switch (type) { case "采购入库": documentName = "采购订单"; ControlBindManager.BindListBox("select OrdersNumber,OrdersNumber+' ('+HTNumber+')' as text from CertificateOrders where OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' order by CreateTime asc", drpOrdersNumber, "OrdersNumber", "text", existNumbers); trSaleOrder.Visible = false; break; case "采购退料出库": documentName = "采购订单"; ControlBindManager.BindListBox("select OrdersNumber from CertificateOrders where OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' order by CreateTime desc", drpOrdersNumber, "OrdersNumber", "OrdersNumber", existNumbers); break; case "盘盈入库": documentName = "盘点编号"; ControlBindManager.BindListBox(@"select InventoryNumber from StockInventoryLog where ISNULL ( AuditeTime ,'')!=''", drpOrdersNumber, "InventoryNumber", "InventoryNumber", existNumbers); break; case "盘亏出库": documentName = "盘点编号"; ControlBindManager.BindListBox(@"select InventoryNumber from StockInventoryLog where ISNULL ( AuditeTime ,'')!=''", drpOrdersNumber, "InventoryNumber", "InventoryNumber", existNumbers); break; case "销售出库(贸易)": documentName = "销售订单"; ControlBindManager.BindListBox(@"select OdersNumber,OdersNumber+' ('+customerordernumber+')' customerordernumber from SaleOder where ProductType ='贸易' and OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' and OdersType in ('加急订单','正常订单')", drpOrdersNumber, "OdersNumber", "customerordernumber", existNumbers); break; case "包装出库": documentName = "销售订单"; ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易' and OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' and OdersType in ('加急订单','正常订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers); break; case "维修出库": documentName = "维修订单"; ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易' and OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' and OdersType in ('维修订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers); break; case "样品出库": documentName = "样品订单"; ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易' and OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' and OdersType in ('样品订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers); break; case "生产退料入库": documentName = "开工单号"; break; case "生产出库": documentName = "开工单号"; break; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ControlBindManager.BindDrp("select USER_ID,USER_NAME from PM_USER", this.drpName, "USER_ID", "USER_NAME"); ControlBindManager.BindCustomer(this.drpCustomerId); this.trReportTime.Visible = false; if (ToolManager.CheckQueryString("ReportTime") && ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version")) { DataTable dt = HasDeleted(); if (dt != null) { DataRow dr = dt.Rows[0]; lblCustomerId.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString(); lbReportTime.Text = dr["ReportTime"] == null ? "" : dr["ReportTime"].ToString(); lblProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString(); lblVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString(); txtCustomerProductNumber.Text = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString(); txtQty.Text = dr["Qty"] == null ? "" : dr["Qty"].ToString(); txtRepairReason.Text = dr["RepairReason"] == null ? "" : dr["RepairReason"].ToString(); txtRepairDate.Text = dr["RepairDate"] == null ? "" : dr["RepairDate"].ToString(); txtRepairInspectionDate.Text = dr["RepairInspectionDate"] == null ? "" : dr["RepairInspectionDate"].ToString(); drpName.Text = dr["Name"] == null ? "" : dr["Name"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); BindCustomer(txtProductNumber.Text, txtVersion.Text, drpCustomerId.Text, dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString()); } btnSubmit.Text = "修改"; this.txtReportTime.Visible = false; this.lbReportTime.Visible = true; this.txtProductNumber.Enabled = false; this.txtVersion.Enabled = false; this.drpCustomerId.Visible = false; this.txtProductNumber.Visible = false; this.txtVersion.Visible = false; } else { btnSubmit.Text = "添加"; this.lbReportTime.Visible = false; this.txtReportTime.Visible = true; this.lblCustomerId.Visible = false; if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version") && ToolManager.CheckQueryString("CustomerId")) { string productnumber = ToolManager.GetQueryString("ProductNumber"); string version = ToolManager.GetQueryString("Version"); string customerid = ToolManager.GetQueryString("CustomerId"); string sql = string.Format(@" select CustomerProductNumber from ProductCustomerProperty where ProductNumber='{0}' and Version ='{1}' and CustomerId='{2}'", productnumber, version, customerid); Response.Write(SqlHelper.GetScalar(sql)); Response.End(); } } if (ToolManager.CheckQueryString("m")) { string result = string.Empty; string sql = string.Format(@" select top 20 ProductNumber,[Version] ,ProductName from Product "); if (ToolManager.CheckQueryString("contion")) { sql += string.Format(@" where ProductNumber like '%{0}%' or ProductNumber like'%{0}' or ProductNumber like '{0}%' or ProductName like '%{0}%' or ProductName like'%{0}' or ProductName like '{0}%' order by ProductNumber asc", ToolManager.GetQueryString("contion")); } DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { result += string.Format(" <tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>", dr["ProductName"], dr["ProductNumber"], dr["Version"]); } } Response.Write(result); Response.End(); return; } } }