protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //扩展属性 GetBillExAttrControl1.TableName = "officedba.SellBack"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); DataTable dt = SellBackBus.GetReasonType(); if (dt.Rows.Count > 0) { ddlReasonType.DataSource = dt; ddlReasonType.DataTextField = "CodeName"; ddlReasonType.DataValueField = "ID"; ddlReasonType.DataBind(); } ddlReasonType.Items.Insert(0, new ListItem("请选择", "")); btnImport.Attributes["onclick"] = "return fnIsSearch();"; // 小数位数 _selPoint = int.Parse(UserInfo.SelPoint); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //新建模块ID hidModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGEOUTRED_ADD; GetBillExAttrControl1.TableName = "officedba.StorageOutRed"; HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;//小数位 if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice) { IsDisplayPrice.Value = "true"; } else { IsDisplayPrice.Value = "false"; } //返回处理 string requestParam = Request.QueryString.ToString(); //从列表过来时 int firstIndex = requestParam.IndexOf("&"); //返回回来时 if (firstIndex > 0) { //获取是否查询的标识 string flag = Request.QueryString["Flag"]; //点击查询时,设置查询的条件,并执行查询 if ("1".Equals(flag)) { txtOutNo.Value = Request.QueryString["OutNo"]; txtTitle.Value = Request.QueryString["Title"]; sltFromType.Value = Request.QueryString["FromType"]; txtFromBillID.Attributes.Add("title", Request.QueryString["FromOutID"]); hidFromBillID.Value = Request.QueryString["FromOutID"]; sltBillStatus.Value = Request.QueryString["BillStatus"]; txtOuterID.Value = Request.QueryString["Transactor"]; txtOutDateStart.Value = Request.QueryString["OutDateStart"]; txtOutDateEnd.Value = Request.QueryString["OutDateEnd"]; txtFromBillID.Value = Request.QueryString["FromOutNo"]; UserOuter.Value = Request.QueryString["UserOuter"]; txtBatchNo.Value = Request.QueryString["BatchNo"]; //获取当前页 string pageIndex = Request.QueryString["pageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["pageCount"]; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //执行查询 ClientScript.RegisterStartupScript(this.GetType(), "DoSearch" , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");DoSearch('" + pageIndex + "');</script>"); } } } }
protected void Page_Load(object sender, EventArgs e) { companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (!IsPostBack) { BindCom(); HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;//小数位 GetBillExAttrControl1.TableName = "officedba.Productinfo"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); StorageModel model = new StorageModel(); model.CompanyCD = companyCD; model.UsedStatus = "1"; DataTable dt1 = StorageBus.GetStorageListBycondition(model); if (dt1.Rows.Count > 0) { ddlStorage.DataSource = dt1; ddlStorage.DataTextField = "StorageName"; ddlStorage.DataValueField = "ID"; ddlStorage.DataBind(); ddlStorage.Items.Insert(0, new ListItem("--请选择--", "")); } //this.txtStartDate.Text = System.DateTime.Now.AddDays(1 - System.DateTime.Now.Day).ToString("yyyy-MM-dd"); //this.txtEndDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); this.hidModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGEJOURNAL; //点击查询时,设置查询的条件,并执行查询 if (Request.QueryString["Flag"] != null) { this.ddlStorage.SelectedValue = Request.QueryString["ddlStorage"].ToString(); this.txtProductNo.Value = Request.QueryString["txtProductNo"].ToString(); //this.txtProductName.Value = Request.QueryString["txtProductName"].ToString(); this.txtStartDate.Text = Request.QueryString["StartDate"].ToString(); this.txtEndDate.Text = Request.QueryString["EndDate"].ToString(); this.hiddenProductID.Value = Request.QueryString["ProductID"].ToString(); //获取当前页 string pageIndex = Request.QueryString["pageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["pageCount"]; //执行查询 //ClientScript.RegisterStartupScript(this.GetType(), "Fun_Search_StorageInfo" // , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");Fun_Search_StorageInfo('" + pageIndex + "');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;// if (!IsPostBack) { GetBillExAttrControl1.TableName = "officedba.PurchaseAskPrice"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadDepot(); GetBillExAttrControl1.TableName = "officedba.StorageReturn"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); } MoudleID.Value = ConstUtil.MODULE_ID_STORAGE_RETURN_SAVE; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindStorageInfo(); //扩展属性 GetBillExAttrControl1.TableName = "officedba.StorageTransfer"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); hidSelPoint.Value = UserInfo.SelPoint; } MoudleID.Value = ConstUtil.MODULE_ID_STORAGE_TRANSFER_SAVE; ModuleInOutID.Value = ConstUtil.MODULE_ID_STORAGE_TRANSFER_LIST; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //扩展属性 GetBillExAttrControl1.TableName = "officedba.SellGathering"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); btnImport.Attributes["onclick"] = "return fnIsSearch();"; // 小数位数 _selPoint = int.Parse(UserInfo.SelPoint); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadDepot(); //扩展属性 GetBillExAttrControl1.TableName = "officedba.StorageBorrow"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); hidSelPoint.Value = UserInfo.SelPoint; } MoudleID.Value = ConstUtil.MODULE_ID_STORAGE_BORROW_SAVE; }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { //设置行为参数 string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "desc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "GatheringNo"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_a")) { order = "asc"; //排序:升序 } int pageCount = int.Parse(hiddExpTotal.Value); //每页显示记录数 int pageIndex = 1; //当前页 int TotalCount = 0; //总记录数 string ord = orderBy + " " + order; //排序字段 DataTable dt = new DataTable(); SellGatheringModel sellGatheringModel = new SellGatheringModel(); GetSellGatheringModel(sellGatheringModel); string PlanPrice0 = hiddExpPlanPrice0.Value.Trim(); //计划回款金额 PlanPrice0 = PlanPrice0.Length == 0 ? null : PlanPrice0; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); dt = SellGatheringBus.GetSellGathering(sellGatheringModel, PlanPrice0, EFIndex, EFDesc, pageIndex, pageCount, ord, ref TotalCount); //导出标题 string headerTitle = "单据编号|主题|客户|回款状态|源单类型|源单编号|业务员|总金额|期次|计划日期"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "GatheringNo|Title|CustName|stateName|fromTypeName|BillNo|EmployeeName|PlanPrice|GatheringTime|PlanGatherDate"; //string columnFiled = "CreateDate|strUsedStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "回款计划列表"); }
protected void Page_Load(object sender, EventArgs e) { BindTree(); if (!IsPostBack) { BindColor(); this.hidModuleID.Value = ConstUtil.Menu_AddProduct; GetBillExAttrControl1.TableName = "officedba.ProductInfo"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); string requestParam = Request.QueryString.ToString(); //从列表过来时 int firstIndex = requestParam.IndexOf("&"); //返回回来时 if (firstIndex > 0) { //获取是否查询的标识 string flag = Request.QueryString["Flag"]; //点击查询时,设置查询的条件,并执行查询 if ("1".Equals(flag)) { this.txt_TypeID.Value = Request.QueryString["txt_TypeID"]; txt_ProdNo.Value = Request.QueryString["ProdNo"]; txt_PYShort.Value = Request.QueryString["PYShort"]; txt_ProductName.Text = Request.QueryString["ProductName"]; txt_BarCode.Value = Request.QueryString["BarCode"]; this.selCorlor.SelectedValue = Request.QueryString["Color"]; this.txt_Specification.Value = Request.QueryString["Specification"]; this.UsedStatus.Value = Request.QueryString["UsedStatus"]; this.CheckStatus.Value = Request.QueryString["CheckStatus"]; //获取当前页 string pageIndex = Request.QueryString["PageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["PageCount"]; //执行查询 ClientScript.RegisterStartupScript(this.GetType(), "DoSearch" , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");Fun_Search_ProductInfo('" + pageIndex + "');</script>"); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TakeType.TypeFlag = ConstUtil.SELL_TYPE_SELL; //交货方式 TakeType.TypeCode = ConstUtil.SELL_TYPE_TAKETYPE; //交 TakeType.IsInsertSelect = true; //扩展属性 GetBillExAttrControl1.TableName = "officedba.SellSend"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); btnImport.Attributes["onclick"] = "return fnIsSearch();"; // 小数位数 _selPoint = int.Parse(UserInfo.SelPoint); } }
protected void Page_Load(object sender, EventArgs e) { UserInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil; // 小数位数 _selPoint = int.Parse(UserInfo.SelPoint); if (!Page.IsPostBack) { //新建修改采购合同模块ID hidModuleID.Value = ConstUtil.MODULE_ID_PurchaseReject_Add; BinddrpTypeID(); GetBillExAttrControl1.TableName = "officedba.PurchaseReject"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindCom(); BindTree(); HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;//小数位 //扩展属性 GetBillExAttrControl1.TableName = "officedba.ProductInfo"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //获取仓库列表 StorageModel model = new StorageModel(); model.CompanyCD = UserInfo.CompanyCD; model.UsedStatus = "1"; DataTable dt1 = StorageBus.GetStorageListBycondition2(model); if (dt1.Rows.Count > 0) { ddlStorage.DataSource = dt1; ddlStorage.DataTextField = "StorageName"; ddlStorage.DataValueField = "ID"; ddlStorage.DataBind(); ddlStorage.Items.Insert(0, new ListItem("--请选择--", "")); } //获取材质列表 string typeflag = "5"; string typecode = "5"; DataTable dt2 = XBase.Business.Office.SystemManager.CodePublicTypeBus.GetCodePublicByCode(typeflag, typecode); if (dt2.Rows.Count > 0) { ddlMaterial.DataSource = dt2; ddlMaterial.DataTextField = "TypeName"; ddlMaterial.DataValueField = "ID"; ddlMaterial.DataBind(); ddlMaterial.Items.Insert(0, new ListItem("--请选择--", "")); } } }
protected void Page_Load(object sender, EventArgs e) { HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;// if (!IsPostBack) { GetBillExAttrControl1.TableName = "officedba.PurchaseOrder"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); #region 采购类别 ddlTypeID.TypeCode = "5"; ddlTypeID.TypeFlag = "7"; ddlTypeID.IsInsertSelect = true; #endregion } }
protected void Page_Load(object sender, EventArgs e) { string CompanyCD = ""; CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;// if (!IsPostBack) { GetBillExAttrControl1.TableName = "officedba.PurchaseContract"; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //新建修改采购合同模块ID hidModuleID.Value = ConstUtil.MODULE_ID_PurchaseContract_Add; BindDrpTypeID(); } }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { //设置行为参数 string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "desc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "SttlDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_a")) { order = "asc"; //排序:升序 } int pageCount = int.Parse(hiddExpTotal.Value); //每页显示记录数 int pageIndex = 1; //当前页 int TotalCount = 0; //总记录数 string ord = orderBy + " " + order; //排序字段 DataTable dt = new DataTable(); string strorderNo = hiddExpOrderNo.Value.Trim(); string strTitle = hiddExpTitle.Value.Trim(); string strCustID = hiddExpCustID.Value.Trim(); string strSeller = hiddExpSeller.Value.Trim(); string strBillStatus = hiddExpBillStatus.Value.Trim(); string strSttlDate1 = hiddExpOfferDate1.Value.Trim(); string strSttlDate = hiddExpOfferDate.Value.Trim(); string strFlowStatus = hiddExpFlowStatus.Value.Trim(); string strFromBillID = hiddExpFromBillID.Value.Trim(); string orderNo = strorderNo.Length == 0 ? null : strorderNo; string Title = strTitle.Length == 0 ? null : strTitle; int? CustID = strCustID.Length == 0 ? null : (int?)Convert.ToInt32(strCustID); int? Seller = strSeller.Length == 0 ? null : (int?)Convert.ToInt32(strSeller); string BillStatus = strBillStatus.Length == 0 ? null : strBillStatus; DateTime?date = strSttlDate.Length == 0 ? null : (DateTime?)Convert.ToDateTime(strSttlDate); DateTime?date1 = strSttlDate1.Length == 0 ? null : (DateTime?)Convert.ToDateTime(strSttlDate1); int? FlowStatus = strFlowStatus.Length == 0 ? null : (int?)Convert.ToInt32(strFlowStatus); int? FromBillID = strFromBillID.Length == 0 ? null : (int?)Convert.ToInt32(strFromBillID); //扩展属性 string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); SellChannelSttlModel model = new SellChannelSttlModel(); model.SttlNo = orderNo; model.Title = Title; model.CustID = CustID; model.Seller = Seller; model.BillStatus = BillStatus; model.SttlDate = date; model.FromBillID = FromBillID; dt = SellChannelSttlBus.GetOrderList(model, date1, FlowStatus, EFIndex, EFDesc, pageIndex, pageCount, ord, ref TotalCount); //导出标题 string headerTitle = "结算单编号|结算单主题|销售发货单|客户|业务员|结算日期|结算金额|单据状态|审批状态"; //string headerTitle = "建档日期|启用状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "SttlNo|Title|OrderNo|CustName|SellerName|SttlDate|SttlTotal|BillStatusText|FlowInstanceText"; //string columnFiled = "CreateDate|strUsedStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "委托代销单列表"); }
protected void imgOutput_Click(object sender, ImageClickEventArgs e) { StorageBorrow borrow = new StorageBorrow(); borrow.BorrowNo = string.IsNullOrEmpty(tboxBorrowNo.Value.Trim())?string.Empty:("%" + tboxBorrowNo.Value.Trim() + "%"); borrow.Title = string.IsNullOrEmpty(tboxTitle.Value.Trim()) ? string.Empty : ("%" + tboxTitle.Value.Trim() + "%"); borrow.Borrower = Convert.ToInt32(string.IsNullOrEmpty(txtBorrower.Value.Trim())?"-1":txtBorrower.Value.Trim()); borrow.DeptID = Convert.ToInt32(string.IsNullOrEmpty(txtBorrowDeptID.Value.Trim())?"-1":txtBorrowDeptID.Value.Trim()); borrow.OutDeptID = Convert.ToInt32(string.IsNullOrEmpty(txtOutDept.Value.Trim())?"-1":txtOutDept.Value.Trim()); borrow.StorageID = Convert.ToInt32(string.IsNullOrEmpty(ddlDepot.SelectedItem.Value)?"-1":ddlDepot.SelectedItem.Value); borrow.Transactor = Convert.ToInt32(string.IsNullOrEmpty(txtTransactor.Value.Trim())?"-1":txtTransactor.Value.Trim()); borrow.BillStatus = string.IsNullOrEmpty(ddlBillStatus.SelectedItem.Value)?string.Empty:ddlBillStatus.SelectedItem.Value; borrow.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; DateTime start = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowStartTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowStartTime.Text.Trim()); DateTime end = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowEndTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowEndTime.Text.Trim()); int SubmitStatus = Convert.ToInt32(string.IsNullOrEmpty(ddlSubmitStatus.SelectedItem.Value)?"-1":ddlSubmitStatus.SelectedItem.Value); string orderString = (string.IsNullOrEmpty(txtOrderBy.Value.Trim()) ? string.Empty : txtOrderBy.Value.Trim()); //排序 string order = "DESC"; //排序:升序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_a")) { order = "ASC";//排序:降序 } //扩展属性 string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); orderBy = orderBy + " " + order; DataTable dt = XBase.Business.Office.StorageManager.StorageBorrowBus.GetStorageList(EFIndex, EFDesc, borrow, orderBy, start, end, SubmitStatus); foreach (DataRow row in dt.Rows) { if (row["FlowStatus"] == null || row["FlowStatus"].ToString() == "") { row["FlowStatus"] = ""; } else if (row["FlowStatus"].ToString() == "1") { row["FlowStatus"] = "待审批"; } else if (row["FlowStatus"].ToString() == "2") { row["FlowStatus"] = "审批中"; } else if (row["FlowStatus"].ToString() == "3") { row["FlowStatus"] = "审批通过"; } else if (row["FlowStatus"].ToString() == "4") { row["FlowStatus"] = "审批不通过"; } else if (row["FlowStatus"].ToString() == "5") { row["FlowStatus"] = "撤销审批"; } } OutputToExecl.ExportToTableFormat(this, dt, new string[] { "借货单编号", "借货单主题", "借货部门", "借货人", "被借部门", "被借仓库", "借货数量", "借货金额", "出库人", "出库时间", "单据状态", "审批状态" }, new string[] { "BorrowNo", "Title", "DeptID", "Borrower", "OutDeptID", "StorageID", "CountTotal", "TotalPrice", "Transactor", "OutDate", "BillStatus", "FlowStatus" }, "借货单列表"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;//小数位 DataTable dt = CodeReasonTypeBus.GetReasonType(companyCD); if (dt.Rows.Count > 0) { ddlReason.DataSource = dt; ddlReason.DataTextField = "CodeName"; ddlReason.DataValueField = "ID"; ddlReason.DataBind(); } ddlReason.Items.Insert(0, new ListItem("--请选择--", "")); //新建模块ID hidModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGEOUTOTHER_ADD; GetBillExAttrControl1.TableName = "officedba.StorageOutOther"; if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice) { IsDisplayPrice.Value = "true"; } else { IsDisplayPrice.Value = "false"; } //返回处理 string requestParam = Request.QueryString.ToString(); //从列表过来时 int firstIndex = requestParam.IndexOf("&"); //返回回来时 if (firstIndex > 0) { //获取是否查询的标识 string flag = Request.QueryString["Flag"]; //点击查询时,设置查询的条件,并执行查询 if ("1".Equals(flag)) { txtOutNo.Value = Request.QueryString["OutNo"]; txtTitle.Value = Request.QueryString["Title"]; sltFromType.Value = Request.QueryString["FromType"]; ddlReason.SelectedValue = Request.QueryString["ReasonType"]; sltBillStatus.Value = Request.QueryString["BillStatus"]; txtOuterID.Value = Request.QueryString["Transactor"]; txtOutDateStart.Value = Request.QueryString["OutDateStart"]; txtOutDateEnd.Value = Request.QueryString["OutDateEnd"]; UserOuter.Value = Request.QueryString["UserOuter"]; txtBatchNo.Value = Request.QueryString["BatchNo"]; HiddenProjectID.Value = Request.QueryString["ProjectID"]; SelectProject.Value = Request.QueryString["ProjectName"]; //获取当前页 string pageIndex = Request.QueryString["pageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["pageCount"]; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //执行查询 ClientScript.RegisterStartupScript(this.GetType(), "DoSearch" , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");DoSearch('" + pageIndex + "');</script>"); } } } }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { //设置行为参数 string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "desc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "OrderDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_a")) { order = "asc"; //排序:升序 } int pageCount = int.Parse(hiddExpTotal.Value); //每页显示记录数 int pageIndex = 1; //当前页 int TotalCount = 0; //总记录数 string ord = orderBy + " " + order; //排序字段 DataTable dt = new DataTable(); string strorderNo = hiddExpOrderNo.Value.Trim(); string strTitle = hiddExpTitle.Value.Trim(); string strTotalPrice = hiddExpTotalPrice.Value.Trim(); string strTotalPrice1 = hiddExpTotalPrice1.Value.Trim(); string strFromType = hiddExpFromType.Value.Trim(); string strBillStatus = hiddExpBillStatus.Value.Trim(); string strCustID = hiddExpCustID.Value.Trim(); string strSeller = hiddExpSeller.Value.Trim(); string strisOpenbill = hiddExpIsOpenbill.Value.Trim(); string strFlowStatus = hiddExpFlowStatus.Value.Trim(); string strFromBillID = hiddExpFromBillID.Value.Trim(); string strSendPro = hiddExpSendPro.Value.Trim(); string strProjectID = hiddProjectID.Value.Trim(); string orderNo = strorderNo.Length == 0 ? null : strorderNo; string Title = strTitle.Length == 0 ? null : strTitle; decimal?TotalPrice = strTotalPrice.Length == 0 ? null : (decimal?)Convert.ToDecimal(strTotalPrice); decimal?TotalPrice1 = strTotalPrice1.Length == 0 ? null : (decimal?)Convert.ToDecimal(strTotalPrice1); string FromType = strFromType.Length == 0 ? null : strFromType; string BillStatus = strBillStatus.Length == 0 ? null : strBillStatus; int? CustID = strCustID.Length == 0 ? null : (int?)Convert.ToInt32(strCustID); int? Seller = strSeller.Length == 0 ? null : (int?)Convert.ToInt32(strSeller); string isOpenbill = strisOpenbill.Length == 0 ? null : strisOpenbill; int? FlowStatus = strFlowStatus.Length == 0 ? null : (int?)Convert.ToInt32(strFlowStatus); int? FromBillID = strFromBillID.Length == 0 ? null : (int?)Convert.ToInt32(strFromBillID); string SendPro = strSendPro.Length == 0 ? null : strSendPro; int? ProjectID = strProjectID.Length == 0 ? null : (int?)Convert.ToInt32(strProjectID); //扩展属性 string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); SellOrderModel model = new SellOrderModel(); model.OrderNo = orderNo; model.Title = Title; model.TotalPrice = TotalPrice; model.FromType = FromType; model.FromBillID = FromBillID; model.BillStatus = BillStatus; model.CustID = CustID; model.Seller = Seller; model.isOpenbill = isOpenbill; model.ProjectID = ProjectID; dt = SellOrderBus.GetOrderList(model, TotalPrice1, SendPro, FlowStatus, EFIndex, EFIndex, pageIndex, pageCount, ord, ref TotalCount); //导出标题 string headerTitle = "订单编号|订单主题|客户|源单类型|源单编号|订单日期|总金额|是否已建单|发货情况|回款金额|单据状态|审批状态"; //string headerTitle = "建档日期|启用状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "OrderNo|Title|CustName|FromTypeText|FromBillNo|OrderDate|RealTotal|isOpenbillText|isSendText|YAccounts|BillStatusText|FlowInstanceText"; //string columnFiled = "CreateDate|strUsedStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "销售订单列表"); }
protected void Page_Load(object sender, EventArgs e) { companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint;//小数位 if (!IsPostBack) { DataTable dt = CodeReasonTypeBus.GetReasonTypeByFlag(companyCD, "5"); if (dt.Rows.Count > 0) { ddlReason.DataSource = dt; ddlReason.DataTextField = "CodeName"; ddlReason.DataValueField = "ID"; ddlReason.DataBind(); ddlReason.Items.Insert(0, new ListItem("--请选择--", "")); } StorageModel model = new StorageModel(); model.CompanyCD = companyCD; model.UsedStatus = "1"; DataTable dt1 = StorageBus.GetStorageListBycondition(model); if (dt1.Rows.Count > 0) { ddlStorage.DataSource = dt1; ddlStorage.DataTextField = "StorageName"; ddlStorage.DataValueField = "ID"; ddlStorage.DataBind(); ddlStorage.Items.Insert(0, new ListItem("--请选择--", "")); } //新建模块ID hidModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGELOSS_ADD; ListModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGELOSS_LIST; GetBillExAttrControl1.TableName = "officedba.StorageLoss"; //返回处理 string requestParam = Request.QueryString.ToString(); //从列表过来时 int firstIndex = requestParam.IndexOf("&"); //返回回来时 if (firstIndex > 0) { //获取是否查询的标识 string flag = Request.QueryString["Flag"]; //点击查询时,设置查询的条件,并执行查询 if ("1".Equals(flag)) { txtLossNo.Value = Request.QueryString["LossNo"]; txtTitle.Value = Request.QueryString["Title"]; txtDeptID.Value = Request.QueryString["Dept"]; ddlStorage.SelectedValue = Request.QueryString["StorageID"]; txtExecutorID.Value = Request.QueryString["Executor"]; sltFlowStatus.Value = Request.QueryString["FlowStatus"]; ddlReason.SelectedValue = Request.QueryString["ReasonType"]; sltBillStatus.Value = Request.QueryString["BillStatus"]; txtLossDateStart.Value = Request.QueryString["LossDateStart"]; txtLossDateEnd.Value = Request.QueryString["LossDateEnd"]; txtTotalPriceStart.Value = Request.QueryString["TotalPriceStart"]; txtTotalPriceEnd.Value = Request.QueryString["TotalPriceEnd"]; DeptName.Value = Request.QueryString["DeptName"]; UserExecutor.Value = Request.QueryString["UserExecutor"]; txtBatchNo.Value = Request.QueryString["BatchNo"]; //获取当前页 string pageIndex = Request.QueryString["pageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["pageCount"]; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //执行查询 ClientScript.RegisterStartupScript(this.GetType(), "DoSearch" , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");DoSearch('" + pageIndex + "');</script>"); } } } }
protected void Page_Load(object sender, EventArgs e) { //启用小数位数,默认2位 hidSelPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint; companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (!IsPostBack) { StorageModel model = new StorageModel(); model.CompanyCD = companyCD; model.UsedStatus = "1"; DataTable dt = StorageBus.GetStorageListBycondition(model); if (dt.Rows.Count > 0) { ddlStorageID.DataSource = dt; ddlStorageID.DataTextField = "StorageName"; ddlStorageID.DataValueField = "ID"; ddlStorageID.DataBind(); } ddlStorageID.Items.Insert(0, new ListItem("--请选择--", "")); //新建模块ID hidModuleID.Value = ConstUtil.MODULE_ID_STORAGE_STORAGEINPROCESS_ADD; GetBillExAttrControl1.TableName = "officedba.StorageInProcess"; //返回处理 string requestParam = Request.QueryString.ToString(); //从列表过来时 int firstIndex = requestParam.IndexOf("&"); //返回回来时 if (firstIndex > 0) { //获取是否查询的标识 string flag = Request.QueryString["Flag"]; //点击查询时,设置查询的条件,并执行查询 if ("1".Equals(flag)) { txtInNo.Value = Request.QueryString["InNO"]; txtTitle.Value = Request.QueryString["Title"]; txtFromBillID.Value = Request.QueryString["FromBillNo"]; txtDeptProcessID.Value = Request.QueryString["ProcessDept"]; UserProcessor.Value = Request.QueryString["Processor"]; txtDeptID.Value = Request.QueryString["InPutDept"]; sltBillStatus.Value = Request.QueryString["sltBillStatus"]; UserExecutor.Value = Request.QueryString["Executor"]; txtEnterDateStart.Value = Request.QueryString["EnterDateStart"]; txtEnterDateEnd.Value = Request.QueryString["EnterDateEnd"]; ddlStorageID.SelectedValue = Request.QueryString["StorageID"]; DeptProcessName.Value = Request.QueryString["DeptProcessName"]; UserProcessor.Value = Request.QueryString["UserProcessor"]; DeptName.Value = Request.QueryString["DeptName"]; UserExecutor.Value = Request.QueryString["UserExecutor"]; //txtInNo.Attributes.Add("title", Request.QueryString["InNO"]); //获取当前页 string pageIndex = Request.QueryString["pageIndex"]; //获取每页显示记录数 string pageCount = Request.QueryString["pageCount"]; string EFIndex = Request.QueryString["EFIndex"]; string EFDesc = Request.QueryString["EFDesc"]; GetBillExAttrControl1.ExtIndex = EFIndex; GetBillExAttrControl1.ExtValue = EFDesc; GetBillExAttrControl1.SetExtControlValue(); //执行查询 ClientScript.RegisterStartupScript(this.GetType(), "DoSearch" , "<script language=javascript>this.pageCount = parseInt(" + pageCount + ");DoSearch('" + pageIndex + "');</script>"); } } } }