/// <summary> /// 绑定数据 /// </summary> public void Bind() { int Counts = 0; string strwhere = " and isnull(dr,0)=0"; if (SalesManID > 0 || OrgID > 0) { string whereIn = string.Empty; if (OrgID > 0) { whereIn += " and OrgID=" + OrgID + ""; } if (SalesManID > 0) { whereIn += " and SalesManID=" + SalesManID + ""; } strwhere = " and CompID in (select ID from [dbo].[BD_Company] where isnull(dr,0)=0 " + whereIn + ")"; } if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } if (this.txtPager.Value.Trim().ToString() != "") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } //if (this.txtCreateDate.Value.Trim() == "" && this.txtECreateDate.Value.Trim() == "") //{ // strwhere += " and CreateDate>='" + DateTime.Now.AddDays(1 - DateTime.Now.Day).ToShortDateString() + " 0:0:0' "; //} strwhere += "and Otype!=9 and isnull(dr,0)=0 and OState in(2,4,5) "; List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); List <Hi.Model.DIS_Order> dis = OrderInfoBLL.GetList("", "isnull(dr,0)=0 and Otype!=9 and OState in(2,4,5)" + strwhere, ""); for (int i = 0; i < dis.Count; i++) { ta += dis[i].AuditAmount; tb += dis[i].PayedAmount; } this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); this.Org.SelectedValue = this.OrgID == 0 ? Org.SelectedValue : this.OrgID.ToString(); }
/// <summary> /// 绑定销售订单信息列表 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strwhere = string.Empty; if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } strwhere += "and CompID=" + CompID + " and Otype!=9 and OState in (2,3,4,5,7) and isnull(vdef1,0) in (0,1) and isnull(dr,0)=0 and (PayState in (0,1) or (PayState=2 and ID in (select OrderID from pay_prepayment where PreType=7)))"; //IsDel=1 订单已删除 if (this.txtPager.Value.Trim().ToString() != "" && this.txtPager.Value.Trim().ToString() != "0") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 绑定数据 /// </summary> public void Bind() { int Counts = 0; string strwhere = string.Empty; if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } if (this.txtPager.Value.Trim().ToString() != "") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } strwhere += "and Otype!=9 and isnull(dr,0)=0 and OState in(2,4,5) and compID=" + this.CompID; List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); List <Hi.Model.DIS_Order> dis = OrderInfoBLL.GetList("", "Otype!=9 and isnull(dr,0)=0 and OState in(2,4,5) " + strwhere, ""); for (int i = 0; i < dis.Count; i++) { ta += dis[i].AuditAmount; tb += dis[i].PayedAmount; } this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 绑定销售订单信息列表 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strwhere = string.Empty; string IDlist = string.Empty;//销售经理下属 员工ID集合 if (DisSalesManID != 0) { if (Common.GetDisSalesManType(DisSalesManID.ToString(), out IDlist)) { //销售经理 strwhere = "and DisID in(select ID from BD_Distributor where smid in(" + IDlist + "))"; } else { strwhere = "and DisID in(select ID from BD_Distributor where smid = " + DisSalesManID + ")"; } } if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } strwhere += "and CompID=" + CompID + " and Otype=9 and OState in (2,3,4,5,6,7) and isnull(vdef1,0) in (0,1) and isnull(dr,0)=0 and (PayState in (0,1) or (PayState=2 and ID in (select OrderID from pay_prepayment where PreType=8)))"; //IsDel=1 订单已删除 if (this.txtPager.Value.Trim().ToString() != "" && this.txtPager.Value.Trim().ToString() != "0") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 绑定销售订单信息列表 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strwhere = string.Empty; if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } if (Request.QueryString["type"] + "" == "2") { //待收款订单 strwhere += " and (( Otype=1 and OState not in (-1,0,1) and PayState in(0,1) ) or( Otype<>1 and OState in (2,4,5) and PayState in(0,1))) and OState<>6 and CompID='" + this.CompID + "' and ReturnState=0 and isnull(dr,0)=0"; //IsDel=1 订单已删除 this.ddrPayState.Value = "0"; } else { strwhere += "and CompID=" + this.CompID + " and OState>=" + (int)Enums.OrderState.待审核 + " and otype=9 and isnull(dr,0)=0"; //IsDel=1 订单已删除 } if (this.txtPager.Value.Trim().ToString() != "" && this.txtPager.Value.Trim().ToString() != "0") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 绑定销售订单信息列表 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strwhere = string.Empty; string IDlist = string.Empty;//销售经理下属 员工ID集合 if (DisSalesManID != 0) { if (Common.GetDisSalesManType(DisSalesManID.ToString(), out IDlist)) { //销售经理 strwhere = "and DisID in(select ID from BD_Distributor where smid in(" + IDlist + "))"; } else { strwhere = "and DisID in(select ID from BD_Distributor where smid = " + DisSalesManID + ")"; } } if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } #region if (Request.QueryString["type"] + "" == "2") { //待收款订单 strwhere += " and (( Otype=1 and OState not in (-1,0,1) and PayState in(0,1) ) or( Otype<>1 and OState in (2,4,5) and PayState in(0,1))) and OState<>6 and CompID='" + this.CompID + "' and ReturnState=0 and Otype!=9 and isnull(dr,0)=0"; //IsDel=1 订单已删除 this.ddrPayState.Value = "0"; ddrOState.Attributes["disabled"] = "false"; } else if (Request.QueryString["type"] + "" == "1") { //待审核 strwhere += " and OState=1 and Otype<>9 and isnull(dr,0)=0 and CompID='" + this.CompID + "'"; ddrOState.Value = "0"; ddrOState.Attributes["disabled"] = "false"; } else if (Request.QueryString["type"] + "" == "3") { //待发货 strwhere += " and (OState=" + (int)Enums.OrderState.已审 + " or (OState=" + (int)Enums.OrderState.已发货 + " and IsOutState in (0,1,2))) and Otype<>9 and isnull(dr,0)=0 and CompID='" + this.CompID + "'"; ddrOState.Value = "0"; ddrOState.Attributes["disabled"] = "false"; } else { strwhere += "and CompID=" + this.CompID + " and OState>=" + (int)Enums.OrderState.待审核 + "and Otype!=9 and isnull(dr,0)=0"; //IsDel=1 订单已删除 } #endregion if (this.txtPager.Value.Trim().ToString() != "" && this.txtPager.Value.Trim().ToString() != "0") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { PageSize = Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); foreach (var item in l) { oId += item.ID + ","; } oId += "0"; this.rptOrder.DataSource = l; this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 绑定销售订单信息列表 /// </summary> public void Bind() { int pageCount = 0; int Counts = 0; string strwhere = " and isnull(dr,0)=0 "; //if (SalesManID != null && SalesManID != 0) //{ // strwhere += " and CompID in (select ID from [dbo].[BD_Company] where orgid=" + OrgID + " and SalesManID=" + SalesManID + " and isnull(dr,0)=0)"; //} if (SalesManID > 0 || OrgID > 0) { string whereIn = string.Empty; if (OrgID > 0) { whereIn += " and OrgID=" + OrgID + ""; } if (SalesManID > 0) { whereIn += " and SalesManID=" + SalesManID + ""; } strwhere += " and CompID in (select ID from [dbo].[BD_Company] where isnull(dr,0)=0 " + whereIn + ")"; } if (ViewState["strwhere"] != null) { strwhere += ViewState["strwhere"].ToString(); } strwhere += "and Otype!=9 and isnull(dr,0)=0"; //IsDel=1 订单已删除 if (this.txtPager.Value.Trim().ToString() != "") { if (this.txtPager.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPager.Value = "100"; } else { Pager.PageSize = this.txtPager.Value.Trim().ToInt(0); } } List <Hi.Model.DIS_Order> l = OrderInfoBLL.GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, strwhere, out pageCount, out Counts); this.rptOrder.DataSource = l; //查询制单人列表 List <int> ids = l.Select(T => T.CreateUserID).Distinct().ToList(); if (ids != null && ids.Count > 0) { userList = new Hi.BLL.SYS_Users().GetList("TrueName,ID", " ID in(" + string.Join(",", ids) + ") ", ""); } this.rptOrder.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); this.Org.SelectedValue = (this.OrgID == 0 ? Org.SelectedValue : this.OrgID.ToString()); }