protected void Page_Load(object sender, EventArgs e) { //删除 if (ToolManager.CheckQueryString("ids")) { string temp = ExaminationLogManager.DeleteData(ToolManager.GetQueryString("ids")); bool result = temp == "1" ? true : false; if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除员工考试成绩" + ToolManager.CheckQueryString("ids"), "删除成功"); Response.Write(temp); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除员工考试成绩" + ToolManager.CheckQueryString("ids"), "删除失败!原因" + temp); Response.Write(temp); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPageRepeater("EditExaminationLogList.aspx", "btnSearch", "320", "550"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("OrdersNumber") && ToolManager.CheckQueryString("MaterialNumber") && ToolManager.CheckQueryString("CreateTime")) { string OrdersNumber = ToolManager.GetQueryString("OrdersNumber"); string MaterialNumber = ToolManager.GetQueryString("MaterialNumber"); string CreateTime = ToolManager.GetQueryString("CreateTime"); string sql = string.Format(@"select * from AccountsPayable where OrdersNumber='{0}' and MaterialNumber='{1}' and CreateTime='{2}'", OrdersNumber, MaterialNumber, CreateTime); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; this.lblOrdersNumber.Text = dr["OrdersNumber"] == null ? "" : dr["OrdersNumber"].ToString(); this.lblMaterialNumber.Text = dr["MaterialNumber"] == null ? "" : dr["MaterialNumber"].ToString(); this.lblCreateTime.Text = dr["CreateTime"] == null ? "" : dr["CreateTime"].ToString(); this.lblSupplierMaterialNumber.Text = dr["SupplierMaterialNumber"] == null ? "" : dr["SupplierMaterialNumber"].ToString(); this.lblSupplierId.Text = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString(); this.lblQty.Text = dr["Qty"] == null ? "" : dr["Qty"].ToString(); this.lblUnitPrice.Text = dr["UnitPrice"] == null ? "" : dr["UnitPrice"].ToString(); this.lblSumPrice.Text = dr["SumPrice"] == null ? "" : dr["SumPrice"].ToString(); this.txtDeliveryDate.Text = dr["DeliveryDate"] == null ? "" : dr["DeliveryDate"].ToString(); this.txtInvoiceNumber.Text = dr["InvoiceNumber"] == null ? "" : dr["InvoiceNumber"].ToString(); this.txtInvoiceDate.Text = dr["InvoiceDate"] == null ? "" : dr["InvoiceDate"].ToString(); this.drpAccountPeriod.SelectedValue = dr["AccountPeriod"] == null ? "" : dr["AccountPeriod"].ToString(); this.txtActualPaymentsAmount.Text = dr["ActualPaymentsAmount"] == null ? "" : dr["ActualPaymentsAmount"].ToString(); this.txtActualPaymentsDate.Text = dr["ActualPaymentsDate"] == null ? "" : dr["ActualPaymentsDate"].ToString(); AmountCollected = dr["AmountCollected"] == null ? "" : dr["AmountCollected"].ToString(); IsSettle = dr["IsSettle"] == null ? "" : dr["IsSettle"].ToString(); } } } }
private void onload() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select p.ProductNumber as ProductNumber,p.Version as Version, p.ProductName as ProductName,p.Description as Description,mk.Kind as Kind,P.Type AS Type, p.RatedManhour as RatedManhour,p.QuoteManhour as QuoteManhour,p.CostPrice as CostPrice, p.SalesQuotation as SalesQuotation,p.HalfProductPosition as HalfProductPosition, p.FinishedGoodsPosition as FinishedGoodsPosition,p.Remark as Remark from Product p left join MarerialKind mk on p.Kind=mk.Id where ProductNumber='{0}' ", ToolManager.GetQueryString("Id")); Product product = ProductManager.ConvertDataTableToModel(sql); this.lbProductNumber.InnerText = product.ProductNumber; this.lbVersion.InnerText = product.Version; this.lbProductName.InnerText = product.ProductName; this.lbDescription.InnerText = product.Description; this.lbKind.InnerText = product.Kind; this.lbType.InnerText = product.Type; this.lbRatedManhour.InnerText = product.RatedManhour.ToString(); this.lbQuoteManhour.InnerText = product.QuoteManhour.ToString(); this.lbCostPrice.InnerText = product.CostPrice.ToString(); this.lbSalesQuotation.InnerText = product.SalesQuotation.ToString(); this.lbHalfProductPosition.InnerText = product.HalfProductPosition; this.lbFinishedGoodsPosition.InnerText = product.FinishedGoodsPosition; this.lbRemark.InnerText = product.Remark; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string PackageNumber = ToolManager.GetQueryString("PackageNumber"); string error = string.Empty; string sql = string.Format(" select * from PackageInfo where PackageNumber='{0}' ", PackageNumber); if (!ToolManager.CheckQueryString("PackageNumber")) { this.btnSubmit.Text = "添加"; } else { this.btnSubmit.Text = "修改"; DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtPackageNumber.Text = dr["PackageNumber"] == null ? "" : dr["PackageNumber"].ToString(); txtPackageName.Text = dr["PackageName"] == null ? "" : dr["PackageName"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("Guid")) { string error = string.Empty; string guid = ToolManager.GetQueryString("Guid"); string sql = string.Format(@" select cdd.Guid as Guid, cdd.ImportTime,cdd.CustomerId,cdd.Number, cdd.Description,cdd.AdvanceQty,cdd.ReplyDate, 10 as WipQty,cdd.NonDeliveryQty,cdd.StockQty, case when cdd.IsMeetDelivery>=0 then '满足' else '不满足' end as IsMeetDelivery, case when cdd.OrderContrast>=0 then '正常' else '不正常' end as OrderContrast,cdd.Remark from CustomerDeliveryDetail cdd where cdd.guid='{0}'", guid); DataTable dt = SqlHelper.GetTable(sql, ref error); DataRow dr = dt.Rows[0]; lbImportTime.Text = dr["ImportTime"] == null ? "" : dr["ImportTime"].ToString(); lbCustomerId.Text = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString(); lbNumber.Text = dr["Number"] == null ? "" : dr["Number"].ToString(); lbDescription.Text = dr["Description"] == null ? "" : dr["Description"].ToString(); lbAdvanceQty.Text = dr["AdvanceQty"] == null ? "" : dr["AdvanceQty"].ToString(); txtReplyDate.Text = dr["ReplyDate"] == null ? "" : dr["ReplyDate"].ToString(); lbWipQty.Text = dr["WipQty"] == null ? "" : dr["WipQty"].ToString(); lbNonDeliveryQty.Text = dr["NonDeliveryQty"] == null ? "" : dr["NonDeliveryQty"].ToString(); lbStockQty.Text = dr["StockQty"] == null ? "" : dr["StockQty"].ToString(); lbIsMeetDelivery.Text = dr["IsMeetDelivery"] == null ? "" : dr["IsMeetDelivery"].ToString(); lbOrderContrast.Text = dr["OrderContrast"] == null ? "" : dr["OrderContrast"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); btnSubmit.Text = "修改"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("sp"))//审批通过 { string error = string.Empty; string guids = ToolManager.GetQueryString("sp"); string sql = string.Format(@" update AccountsReceivable set IsApproval='是' where guid in ({0}) ", guids); string result = SqlHelper.ExecuteSql(sql, ref error) ? "1" : error; Response.Write(result); Response.End(); return; } if (ToolManager.CheckQueryString("wsp"))//审核未通过 { string error = string.Empty; string guids = ToolManager.GetQueryString("wsp"); string sql = string.Format(@" update AccountsReceivable set IsApplicationed='否' where guid in ({0}) ", guids); string result = SqlHelper.ExecuteSql(sql, ref error) ? "1" : error; Response.Write(result); Response.End(); return; } Bind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("productNumber") && ToolManager.CheckQueryString("version") && ToolManager.CheckQueryString("qty")) { string productNumber = ToolManager.GetQueryString("productNumber"); string version = ToolManager.GetQueryString("version"); string qty = ToolManager.GetQueryString("qty"); string customerProductNumber = ToolManager.GetQueryString("customerProductNumber"); string sql = string.Format(@"select Type from Product where ProductNumber ='{0}' and Version ='{1}'", productNumber, version); if (SqlHelper.GetScalar(sql).Equals("包")) { rpList.DataSource = WorkOrderManager.GetQuLiaoDetailForBao(productNumber, qty, customerProductNumber); rpList.DataBind(); show = "inline"; } else { show = "none"; rpList.DataSource = WorkOrderManager.GetQuLiaoDetail(productNumber, version, qty, customerProductNumber); rpList.DataBind(); } return; } } }
private void onload() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from Customer where CustomerId='{0}' ", ToolManager.GetQueryString("Id")); Customer customer = CustomerInfoManager.ConvertDataTableToModel(sql); this.lbCustomerId.InnerText = customer.CustomerId; this.lbCustomerName.InnerText = customer.CustomerName; this.lbRegisteredAddress.InnerText = customer.RegisteredAddress; this.lbLegalPerson.InnerText = customer.LegalPerson; this.lbContacts.InnerText = customer.Contacts; this.lbRegisteredPhone.InnerText = customer.RegisteredPhone; this.lbContactTelephone.InnerText = customer.ContactTelephone; this.lbFax.InnerText = customer.Fax; this.lbMobilePhone.InnerText = customer.MobilePhone; this.lbEmail.InnerText = customer.Email; this.lbQQ.InnerText = customer.QQ; this.lbZipCode.InnerText = customer.ZipCode; this.lbSparePhone.InnerText = customer.SparePhone; this.lbAccountBank.InnerText = customer.AccountBank; this.lbSortCode.InnerText = customer.SortCode; this.lbBankAccount.InnerText = customer.BankAccount; this.lbTaxNo.InnerText = customer.TaxNo; this.lbDeliveryAddress.InnerText = customer.DeliveryAddress; this.lbWebsiteAddress.InnerText = customer.WebsiteAddress; this.lbRemark.InnerText = customer.Remark; } }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from ProcessTestingTable where Id='{0}' ", ToolManager.GetQueryString("Id")); ProcessTestingTable processtestingtable = ProcessTestingTableManager.ConvertDataTableToModel(sql); this.lblProductionOrderNumber.Text = processtestingtable.ProductionOrderNumber; this.lblProductNumber.Text = processtestingtable.ProductNumber; this.lblCustomerProductNumber.Text = processtestingtable.CustomerProductNumber; this.txtRemark.Text = processtestingtable.Remark; this.lblVersion.Text = processtestingtable.Version; btnSubmit.Text = "修改"; txtCustomerProductNumber.Visible = false; txtProductionOrderNumber.Visible = false; txtProductNumber.Visible = false; show = "none"; } else { show = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string WarehouseNumber = Server.UrlDecode(ToolManager.GetQueryString("WarehouseNumber")); string error = string.Empty; string sql = string.Format(@" select * from ScarpWarehouseLog where WarehouseNumber='{0}' ", WarehouseNumber); if (!ToolManager.CheckQueryString("WarehouseNumber")) { this.btnSubmit.Text = "添加"; } else { this.btnSubmit.Text = "修改"; DataTable dt = SqlHelper.GetTable(sql, ref error); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; warehousenumber = dr["WarehouseNumber"] == null ? "" : dr["WarehouseNumber"].ToString(); this.drpChangeDirection.SelectedValue = dr["ChangeDirection"] == null ? "" : dr["ChangeDirection"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); this.btnSubmit.Text = "修改"; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("Guid")) { string guid = ToolManager.GetQueryString("Guid"); string sql = string.Format(@" select * from V_T_AccountsPayable_Main_ForYF where Guid ='{0}' ", guid); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtYFOneDate.Text = dr["预付一实际付款日期"] == null ? "" : dr["预付一实际付款日期"].ToString(); txtYFTwoDate.Text = dr["预付二实际付款日期"] == null ? "" : dr["预付二实际付款日期"].ToString(); drpJQ.SelectedValue = dr["是否结清"] == null ? "" : dr["是否结清"].ToString(); txtInvoiceNumber.Text = dr["发票号码"] == null ? "" : dr["发票号码"].ToString(); txtInvoiceDate.Text = dr["开票日期"] == null ? "" : dr["开票日期"].ToString(); txtRemark.Text = dr["备注"] == null ? "" : dr["备注"].ToString(); txtYFOne.Text = dr["预付一"] == null ? "" : dr["预付一"].ToString(); txtYFTwo.Text = dr["预付二"] == null ? "" : dr["预付二"].ToString(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("menuId")) { string menuId = ToolManager.GetQueryString("menuId"); string userId = ToolCode.Tool.GetUser().UserNumber; string sql = string.Format(@" select * from pm_menu_erp where (parent_id='{0}' or menu_id='{0}') and IsVisible=1 and Menu_Id in ( select MENU_ID from PM_USER_MENU_PERMISSION where APP_ID ='Rapid-Erp' and USER_ID='{1}' union select MENU_ID from PM_ROLE_MENU_PERMISSION where APP_ID ='Rapid-Erp' and ROLE_ID =(select RoleId from PM_USER where USER_ID='{1}')) order by sn asc", menuId, userId); DataTable dt = SqlHelper.GetTable(sql); DataRow drFirst = dt.Rows[0]; string firstLi = string.Format("<li><span class='folderMenu {0}'>{1}</span>", drFirst["Menu_Iconcls"], drFirst["Menu_Name"]); dt.Rows.RemoveAt(0); string tempUl = string.Empty; foreach (DataRow dr in dt.Rows) { tempUl += string.Format(" <li><a href='{0}' target='I1' class='folderMenu {1}'> {2}</a></li>", dr["Menu_Action"], dr["Menu_Iconcls"], dr["Menu_Name"]); } string result = string.Format(@" {0} <ul> {1} </ul> </li>", firstLi, tempUl); Response.Write(result); Response.End(); return; } BindMenu(); } }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Guid")) { string guid = Server.UrlDecode(ToolManager.GetQueryString("Guid")); sql = string.Format(@"select * from AvailableTwineTable where Guid='{0}'", guid); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; this.lblCustomerMaterialNumber.Text = dr["CutomerMaterialNumber"] == null ? "" : dr["CutomerMaterialNumber"].ToString(); this.lblLength.Text = dr["Length"] == null ? "" : dr["Length"].ToString(); this.txtQty.Text = dr["Qty"] == null ? "" : dr["Qty"].ToString(); this.txtDescription.Text = dr["Description"] == null ? "" : dr["Description"].ToString(); this.txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); btnSubmit.Text = "修改"; txtCustomerMaterialNumber.Visible = false; txtLength.Visible = false; } } else { btnSubmit.Text = "添加"; lblLength.Visible = false; lblCustomerMaterialNumber.Visible = false; } }
private void onload() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from SupplierInfo where SupplierId='{0}' ", ToolManager.GetQueryString("Id")); SupplierInfo supplierinfo = SupplierInfoManager.ConvertDataTableToModel(sql); this.lbSupplierId.InnerText = supplierinfo.SupplierId; this.lbSupplierName.InnerText = supplierinfo.SupplierName; this.lbRegisteredAddress.InnerText = supplierinfo.RegisteredAddress; this.lbLegalPerson.InnerText = supplierinfo.LegalPerson; this.lbContacts.InnerText = supplierinfo.Contacts; this.lbRegisteredPhone.InnerText = supplierinfo.RegisteredPhone; this.lbContactTelephone.InnerText = supplierinfo.ContactTelephone; this.lbFax.InnerText = supplierinfo.Fax; this.lbMobilePhone.InnerText = supplierinfo.MobilePhone; this.lbEmail.InnerText = supplierinfo.Email; this.lbQQ.InnerText = supplierinfo.QQ; this.lbZipCode.InnerText = supplierinfo.ZipCode; this.lbSparePhone.InnerText = supplierinfo.SparePhone; this.lbAccountBank.InnerText = supplierinfo.AccountBank; this.lbBankRowNumber.InnerText = supplierinfo.BankRowNumber; this.lbBankAccount.InnerText = supplierinfo.BankAccount; this.lbTaxNo.InnerText = supplierinfo.TaxNo; this.lbDeliveryAddress.InnerText = supplierinfo.DeliveryAddress; this.lbWebsiteAddress.InnerText = supplierinfo.WebsiteAddress; this.lbRemark.InnerText = supplierinfo.Remark; lbPaymentdays.InnerText = supplierinfo.paymentdays + "天"; lbPercentageInAdvance.InnerText = (Convert.ToDouble(supplierinfo.percentageInAdvance) * 100).ToString() + "%"; } }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; //this.trId.Visible = false; if (ToolManager.CheckQueryString("Year") || ToolManager.CheckQueryString("Month") || ToolManager.CheckQueryString("PerformanceReviewItem") || ToolManager.CheckQueryString("Name")) { sql = string.Format(@" select * from PerformanceReviewLog where Year='{0}' and Month='{1}' and PerformanceReviewItem='{2}' and Name='{3}'", ToolManager.GetQueryString("Year"), ToolManager.GetQueryString("Month"), Server.UrlDecode(ToolManager.GetQueryString("PerformanceReviewItem")), ToolManager.GetQueryString("Name")); PerformanceReviewLog performancereviewlog = PerformanceReviewLogManager.ConvertDataTableToModel(sql); lbYear.Text = performancereviewlog.Year; lbMonth.Text = performancereviewlog.Month; lbProject.Text = performancereviewlog.PerformanceReviewItem; this.txtRowNumber.Text = performancereviewlog.RowNumber.ToString(); this.txtFullScore.Text = performancereviewlog.FullScore.ToString(); this.txtScore.Text = performancereviewlog.Score.ToString(); this.txtRemark.Text = performancereviewlog.Remark; this.txtDeduction.Text = performancereviewlog.Deduction.ToString(); this.txtDescription.Text = performancereviewlog.Description; lbName.Text = performancereviewlog.Name; this.drpStatMode.SelectedValue = performancereviewlog.StatMode.ToString(); btnSubmit.Text = "修改"; txtRowNumber.ReadOnly = true; txtDescription.ReadOnly = true; drpStatMode.Enabled = false; } }
public static string FactTotalManhour = string.Empty; //实际总工时 protected void Page_Load(object FinishManhoursender, EventArgs e) { if (!IsPostBack) { if (!ToolManager.CheckQueryString("PlanNumber")) { Response.Write("未知开工单号!"); Response.End(); return; } string plannumber = ToolManager.GetQueryString("PlanNumber"); lblPlanNumber.Text = plannumber; string sql = string.Format(@"select * from V_ProductPlan where 开工单号='{0}'", plannumber); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtFactEndTime.Text = dr["实际结束时间"] == null ? "" : dr["实际结束时间"].ToString(); txtFactStartTime.Text = dr["实际开始时间"] == null ? "" : dr["实际开始时间"].ToString(); txtPlanEndTime.Text = dr["计划结束时间"] == null ? "" : dr["计划结束时间"].ToString(); txtRemark.Text = dr["备注"] == null ? "" : dr["备注"].ToString(); txtPlanStartTime.Text = dr["计划开始时间"] == null ? "" : dr["计划开始时间"].ToString(); PersonQty = dr["人数"] == null ? "" : dr["人数"].ToString(); //TargetFinishManhour = dr["目标完成工时"] == null ? "" : dr["目标完成工时"].ToString(); } } }
//删除 private void Delete() { if (ToolManager.CheckQueryString("guid")) { string guid = ToolManager.GetQueryString("guid"); string sql = string.Format(@"delete MaterialWarehouseLogDetail where guid='{0}' ", guid); string error = string.Empty; bool restult = SqlHelper.ExecuteSql(sql, ref error); if (restult) { Tool.WriteLog(Tool.LogType.Operating, "删除" + type + "明细", "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除" + type + "明细", "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } }
private void BindProductNumber(HttpContext context) { if (ToolManager.CheckQueryString("ProductNumber")) { // 查询的参数名称默认为term string query = ToolManager.GetQueryString("term"); string error = string.Empty; string sql = string.Format(@" select distinct top 10 ProductNumber from Product where ProductNumber like '{0}%' or ProductNumber like '%{0}' or ProductNumber like '%{0}%'", query); DataTable dt = SqlHelper.GetTable(sql, ref error); StringBuilder builder = new StringBuilder(); builder.Append("["); foreach (DataRow dr in dt.Rows) { builder.AppendFormat("\"{0}\",", dr[0]); } if (builder.Length > 1) { builder.Length = builder.Length - 1; } builder.Append("]"); context.Response.ContentType = "text/javascript"; context.Response.Write(builder.ToString()); context.Response.End(); return; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string appendSql = ""; if (ToolManager.CheckQueryString("isProduct")) { appendSql = string.Format(",MoveTimer='{0}'", txtMoveTime.Text.Trim()); } else { appendSql = string.Format(",MoveTime='{0}'", txtMoveTime.Text.Trim()); } string sql = string.Format(@"update {5} set Income={1}, Issue={2}, Balances={3}, Remark='{4}'{6} where guid='{0}'", ToolManager.GetQueryString("guid"), txtIncome.Text, txtIssue.Text, txtBalances.Text, txtRemark.Text , ToolManager.CheckQueryString("isProduct") ? "ProductWarehouseCurrentAccount" : "MateialWarehouseCurrentAccount" , appendSql); string error = string.Empty; lbSubmit.Text = SqlHelper.ExecuteSql(sql, ref error) ? "修改成功" : "修改失败!原因:" + error; }
private void Bind() { if (ToolManager.CheckQueryString("WarehouseNumber")) { string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber"); string sql = string.Format(@" select hpwld.*,isnull( vhq.StockQty,0) StockQty,pcp.CustomerProductNumber from HalfProductWarehouseLogDetail hpwld left join V_HalfProductStock_Qty vhq on hpwld.ProductNumber =vhq.ProductNumber and hpwld.Version =vhq.Version and hpwld.MaterialNumber =vhq.MaterialNumber inner join ProductCustomerProperty pcp on hpwld .ProductNumber =pcp.ProductNumber and pcp.Version =hpwld .Version where hpwld.WarehouseNumber ='{0}' and hpwld.qty!=0", warehouseNumber); if (!txtPlanNumber.Text.Trim().Equals("")) { sql += string.Format(" and hpwld.DocumentNumber='{0}' ", txtPlanNumber.Text.Trim()); } if (!txtCustomerProductNumber.Text.Trim().Equals("")) { sql += string.Format(" and pcp.CustomerProductNumber='{0}' ", txtCustomerProductNumber.Text.Trim()); } if (!txtQLNumber.Text.Trim().Equals("")) { sql += string.Format(" and hpwld.MaterialNumber='{0}' ", txtQLNumber.Text.Trim()); } rpList.DataSource = SqlHelper.GetTable(sql); rpList.DataBind(); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("Year") && ToolManager.CheckQueryString("Month") && ToolManager.CheckQueryString("Name")) { string year = ToolManager.GetQueryString("Year"); string month = ToolManager.GetQueryString("Month"); string name = Server.UrlDecode(ToolManager.GetQueryString("Name")); //string team = Server.UrlDecode(ToolManager.GetQueryString("Team")); string sql = string.Empty; string error = string.Empty; sql = string.Format(@"select Score,Operation,Remark from ExaminationLog where Year='{0}' and Month='{1}' and Name='{2}' ", year, month, name); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblYear.Text = year; lblMonth.Text = month; lblName.Text = name; //lblTeam.Text = team; txtScore.Text = dr["Score"] == null ? "" : dr["Score"].ToString(); txtOperation.Text = dr["Operation"] == null ? "" : dr["Operation"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); } } } }
///// <summary> ///// 绑定客户编号 ///// </summary> ///// <param name="materialNumber"></param> ///// <param name="customerMaterialNumber"></param> //private void BindCustomer(string materialNumber, string CustomerMaterialNumber) //{ // this.txtCustomerMarerial.Text = CustomerMaterialNumber; //} /// <summary> /// 检查销售订单号是否传过来 /// </summary> private void Check() { if (!ToolManager.CheckQueryString("OdersNumber")) { Response.Write("未知销售订单!"); Response.End(); return; } lblOdersNumber.Text = ToolManager.GetQueryString("OdersNumber"); string sql = string.Format(@"select OdersType from SaleOder where OdersNumber='{0}'", ToolManager.GetQueryString("OdersNumber")); DataTable dt = SqlHelper.GetTable(sql); if (dt.Rows[0]["OdersType"].ToString() == "样品订单") { txtUnitPrice.Text = "0"; // txtUnitPrice.ReadOnly = true; } 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}'", ToolManager.GetQueryString("OdersNumber")); string makecollectionsmode = SqlHelper.GetScalar(sql); if (!makecollectionsmode.Equals("YSBF")) { trReceiveTwo.Visible = false; trReceiveOne.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0310", "Add"); divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0310", "Delete"); //删除 if (ToolManager.CheckQueryString("ids")) { string ids = ToolManager.GetQueryString("ids"); string error = string.Empty; List <string> sqls = new List <string>(); string sqlOne = string.Format(@" delete PerformanceReviewLog where Guid in ({0})", ids); sqls.Add(sqlOne); bool result = SqlHelper.BatchExecuteSql(sqls, ref error); if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除员工绩效信息", "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除员工绩效信息", "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } //查询 if (ToolManager.CheckQueryString("pageIndex")) { GetPage("AddOrEditPerformanceReviewLog.aspx", "btnSearch", "440", "600"); } }
private void LoadPage() { drpType.Items.Clear(); drpType.Items.Add(new ListItem("生产", "生产")); drpType.Items.Add(new ListItem("管理", "管理")); string sql = string.Empty; string error = string.Empty; //this.trId.Visible = false; if (ToolManager.CheckQueryString("StandardName") || ToolManager.CheckQueryString("PerformanceReviewItem")) { //sql = string.Format(@" select * from MareriaType where Type='{0}' ", "类别2"); sql = string.Format(@" select * from PerformanceReviewStandard where StandardName='{0}' and PerformanceReviewItem='{1}' ", Server.UrlDecode(ToolManager.GetQueryString("StandardName")), Server.UrlDecode((ToolManager.GetQueryString("PerformanceReviewItem")))); PerformanceReviewStandard performangcereviewstandard = PerformanceReviewStandardManager.ConvertDataTableToModel(sql); this.txtStandardName.Text = performangcereviewstandard.StandardName; this.txtProject.Text = performangcereviewstandard.PerformanceReviewItem; this.txtRowNumber.Text = performangcereviewstandard.RowNumber.ToString(); this.txtDescription.Text = performangcereviewstandard.Description; this.txtRemark.Text = performangcereviewstandard.Remark; this.txtFullScore.Text = performangcereviewstandard.FullScore.ToString(); this.drpStatMode.Text = performangcereviewstandard.StatMode.ToString(); btnSubmit.Text = "修改"; this.txtStandardName.Enabled = false; this.txtProject.Enabled = false; this.drpType.SelectedValue = performangcereviewstandard.Type; // this.drpType. } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0407", "Add"); divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0407", "Delete"); divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0407", "Exp"); //删除 if (ToolManager.CheckQueryString("ids")) { string ids = ToolManager.GetQueryString("ids"); string temp = MarerialScrapLogManager.DeleteMarerialScrapLog(ToolManager.GetQueryString("ids")); bool restult = temp == "1" ? true : false; if (restult) { 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")) { GetPageOperate("btnSearch", "AddOrEditMarerialScrapLog.aspx", "MarerialScrapLogDetailedList.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //标识删除 if (ToolManager.CheckQueryString("IsDelete")) { string sql = string.Empty; string error = string.Empty; string guid = ToolManager.GetQueryString("Guid"); sql = string.Format("delete InvoiceAccountInfo where Guid ='{0}'", guid); bool result = SqlHelper.ExecuteSql(sql, ref error); if (result) { Tool.WriteLog(Tool.LogType.Operating, "删除发票信息", "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除发票信息", "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } this.labPage.Text = "1"; this.contrlRepeater(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("sq"))//选选择 { string error = string.Empty; string guids = ToolManager.GetQueryString("sq"); string sql = string.Format(@" update T_AccountsPayable_Main set IsApplicationed='是' where guid in ({0}) ", guids); string result = SqlHelper.ExecuteSql(sql, ref error) ? "1" : error; Response.Write(result); Response.End(); return; } if (Request["guid"] != null) { string ordersNumber = string.Empty; string error = string.Empty; string sql = string.Format(" select * from T_AccountsPayable_Main where guid='{0}'", Request["guid"]); DataTable db = SqlHelper.GetTable(sql); if (db != null && db.Rows.Count > 0) { ordersNumber = db.Rows[0]["OrdersNumber"].ToString(); } sql = string.Format(" delete T_AccountsPayable_Main where guid='{0}'", Request["guid"]); bool result = SqlHelper.ExecuteSql(sql, ref error); Tool.WriteLog(Tool.LogType.Operating, "删除采购预付账款申请信息" + ordersNumber, "删除" + result.ToString()); Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new { msg = error, result = result })); Response.End(); } Bind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("ProjectNumber")) { string projectnumber = ToolManager.GetQueryString("ProjectNumber"); string sql = string.Format(@"delete ProjectPackageProperty where ProjectNumber='{0}' ", projectnumber); string error = string.Empty; bool restult = SqlHelper.ExecuteSql(sql, ref error); if (restult) { Tool.WriteLog(Tool.LogType.Operating, "删除项目信息" + projectnumber, "删除成功"); Response.Write("1"); Response.End(); return; } else { Tool.WriteLog(Tool.LogType.Operating, "删除项目信息" + projectnumber, "删除失败!原因" + error); Response.Write(error); Response.End(); return; } } } }
private void LoadPage() { string sql = string.Empty; string error = string.Empty; if (ToolManager.CheckQueryString("Id")) { sql = string.Format(@" select * from MarerialScrapLog where Id='{0}' ", ToolManager.GetQueryString("Id")); //sql = string.Format(@" select * from MarerialScrapLog where Id='{0}' ", "1"); txtCreateTime.ReadOnly = true; txtMaterialNumber.ReadOnly = true; txtProductNumber.ReadOnly = true; Model.MarerialScrapLog marerialscraplog = MarerialScrapLogManager.ConvertDataTableToModel(sql); this.txtId.Text = marerialscraplog.Id; this.trId.Visible = false; this.txtCreateTime.Text = marerialscraplog.CreateTime; this.txtProductNumber.Text = marerialscraplog.ProductNumber; this.txtMaterialNumber.Text = marerialscraplog.MaterialNumber; this.txtScrapDate.Text = marerialscraplog.ScrapDate; this.txtTeam.Text = marerialscraplog.Team; this.txtCount.Text = marerialscraplog.Count; this.txtResponsiblePerson.Text = marerialscraplog.ResponsiblePerson; this.txtScrapReason.Text = marerialscraplog.ScrapReason; this.txtRemark.Text = marerialscraplog.Remark; btnSubmit.Text = "修改"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (ToolManager.CheckQueryString("sn")) { string error = string.Empty; string guid = Server.UrlDecode(ToolManager.GetQueryString("Guid")); string quoteNumber = ToolManager.GetQueryString("QuoteNumber"); string sql = string.Format("select * from TradingQuoteDetail where QuoteNumber ='{0}' and SN='{1}' and Guid='{2}'", quoteNumber, ToolManager.GetQueryString("sn"), guid); DataTable dt = SqlHelper.GetTable(sql, ref error); DataRow dr = dt.Rows[0]; txtSN.Text = dr["SN"] == null ? "" : dr["SN"].ToString(); lbMarerial.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString(); lbBrand.Text = dr["Brand"] == null ? "" : dr["Brand"].ToString(); txtUnitPrice.Text = dr["UnitPrice"] == null ? "" : dr["UnitPrice"].ToString(); txtMinPackage.Text = dr["MinPackage"] == null ? "" : dr["MinPackage"].ToString(); txtMinMOQ.Text = dr["MinMOQ"] == null ? "" : dr["MinMOQ"].ToString(); txtFixedLeadTime.Text = dr["FixedLeadTime"] == null ? "" : dr["FixedLeadTime"].ToString(); txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString(); lbCustomerMarerial.Text = dr["CustomerMaterialNumber"] == null ? "" : dr["CustomerMaterialNumber"].ToString(); lbDescription.Text = dr["MaterialDescription"] == null ? "" : dr["MaterialDescription"].ToString(); btnSubmit.Text = "修改"; } else { btnSubmit.Text = "添加"; } } }