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) { ControlBindManager.BindDrp("select distinct PaymentMode from PaymentMode", this.drpPaymentMode, "PaymentMode", "PaymentMode"); 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) { 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) { 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 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) { 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(); } } }
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(); } }
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) { 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 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(); } } }
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) { 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 = "添加"; } } }
private void Bind() { string sql = "select WarehouseNumber,WarehouseName from WarehouseInfo"; ControlBindManager.BindDrp(sql, this.drpWarehouseName, "WarehouseNumber", "WarehouseName"); }
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; } } }
protected void Page_Load(object sender, EventArgs e) { string sql = string.Empty; string error = string.Empty; if (!IsPostBack) { if (!ToolManager.CheckQueryString("PlanNumber")) { Response.Write("未知开工单号!"); Response.End(); return; } plannumber = ToolManager.GetQueryString("PlanNumber"); ControlBindManager.BindDrp(@"select 班组 from V_ProductPlanSub where 开工单号='" + plannumber + "'", this.drpTeam, "班组", "班组"); string team = Server.UrlDecode(ToolManager.GetQueryString("Team")); drpTeam.SelectedValue = team; //string ordersnumber = ToolManager.GetQueryString("OrdersNumber"); //string productnumber = ToolManager.GetQueryString("ProductNumber"); //string version = ToolManager.GetQueryString("Version"); //string rownumber = ToolManager.GetQueryString("RowNumber"); Bind(); ////审核人 //sql = string.Format("select Auditor from ProductPlan where PlanNumber='{0}'", plannumber); //dt = SqlHelper.GetTable(sql); //if (dt.Rows.Count > 0) //{ // lblAuditor.Text = dt.Rows[0]["Auditor"].ToString(); //} //sql = string.Format(@"select * from V_ProductPlan where 开工单号='{0}'", plannumber); //dt = SqlHelper.GetTable(sql); //if (dt.Rows.Count > 0) //{ // DataRow dr = dt.Rows[0]; // type = dr["开工单类型"] == null ? "" : dr["开工单类型"].ToString(); //} //sql = string.Format(@"select * from V_ProductPlanSub where 开工单号='{0}' and 班组='{1}'", plannumber, team); //dt = SqlHelper.GetTable(sql); //if (dt.Rows.Count > 0) //{ // DataRow dr = dt.Rows[0]; // lblFactEndTime.Text = dr["实际结束时间"] == null ? "" : dr["实际结束时间"].ToString(); // lblFactFinishManhour.Text = dr["实际完成工时"] == null ? "" : dr["实际完成工时"].ToString(); // lblFactStartTime.Text = dr["实际开始时间"] == null ? "" : dr["实际开始时间"].ToString(); // lblFactTotalManhour.Text = dr["实际总工时"] == null ? "" : dr["实际总工时"].ToString(); // lblRatedTotalManhour.Text = dr["额定总工时"] == null ? "" : dr["额定总工时"].ToString(); // lblTargetFinishManhour.Text = dr["目标完成工时"] == null ? "" : dr["目标完成工时"].ToString(); // lblTeam.Text = dr["班组"] == null ? "" : dr["班组"].ToString(); //} // sql = string.Format(@" delete ProductPlanSubDetail where PlanNumber ='{0}' and Team='{1}' // and OrdersNumber='{2}' and ProductNumber='{3}' and Version='{4}' and RowNumber='{5}'", //plannumber, team, ordersnumber, productnumber, version, rownumber); // bool result = SqlHelper.ExecuteSql(sql, ref error); // if (result) // { // Tool.WriteLog(Tool.LogType.Operating, "删除开工单分表明细" + ToolManager.ReplaceSingleQuotesToBlank(plannumber), "删除成功"); // return; // } // else // { // Tool.WriteLog(Tool.LogType.Operating, "删除开工单分表明细" + ToolManager.ReplaceSingleQuotesToBlank(plannumber), "删除失败!原因" + error); // return; // } } }