/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
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();
}
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);
}
}
string sql = string.Empty;
if (paymentid > 0)
{
sql = "SELECT case sxf when '' then null else sxf end as sxf1,isnull(Price,0) as Price1,* FROM [dbo].[CompCollection_view] where pretype=" + pretype + " and paymentid=" + paymentid + " and status=1 order by Date desc";
}
else
{
sql = "SELECT case sxf when '' then null else sxf end as sxf1,isnull(Price,0) as Price1,* FROM [dbo].[CompCollection_view] where OrderID in(select ID from Dis_Order where ISNULL(dr,0)=0 and (Otype<>9) and CompID=" + this.CompID + ") and status=1 and CompID=" + this.CompID + strwhere
+ " order by Date desc";
}
Pagger pagger = new Pagger(sql);
Pager.RecordCount = pagger.GetDataCount(sql);
DataTable dt = pagger.getData(Pager.PageSize, Pager.StartRecordIndex - 1);
this.rptOrder.DataSource = dt;
this.rptOrder.DataBind();
page = Pager.CurrentPageIndex.ToString();
}
/// <summary>
/// 绑定数据
/// </summary>
public void Bind()
{
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();
}
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);
}
}
string sql = "SELECT * FROM [dbo].[CompCollection_view] " + " where OrderID in(select ID from Dis_Order where ISNULL(dr,0)=0 and Otype=9 and CompID=" + this.CompID + ") and CompID=" + this.CompID + strwhere
+ " order by Date desc";
Pagger pagger = new Pagger(sql);
Pager.RecordCount = pagger.GetDataCount(sql);
DataTable dt = pagger.getData(Pager.PageSize, Pager.StartRecordIndex - 1);
DataTable ds = SqlHelper.Query(SqlHelper.LocalSqlServer, sql).Tables[0];
for (int i = 0; i < ds.Rows.Count; i++)
{
ta += Convert.ToDecimal(ds.Rows[i]["Price"].ToString() == "" ? "0" : ds.Rows[i]["Price"].ToString()) - Convert.ToDecimal(ds.Rows[i]["sxf"].ToString() == "" ? "0" : ds.Rows[i]["sxf"].ToString());
}
this.rptOrder.DataSource = dt;
this.rptOrder.DataBind();
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 ID in(select ID from BD_Distributor where smid in(" + IDlist + "))";
}
else
{
strwhere = "and ID in(select ID from BD_Distributor where smid = " + DisSalesManID + ")";
}
}
strwhere += " and dr=0 and AuditState=2 and CompID =" + CompID;
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);
}
}
List <Hi.Model.BD_Distributor> dis = new Hi.BLL.BD_Distributor().GetList(Pager.PageSize, Pager.CurrentPageIndex, "shortindex", true, strwhere, out pageCount, out Counts);
this.rptDis.DataSource = dis;
this.rptDis.DataBind();
Pager.RecordCount = Counts;
page = Pager.CurrentPageIndex.ToString();
}
/// <summary>
/// 查询条件
/// </summary>
/// <returns></returns>
public string SearchWhere()
{
string where = " and cu.compid=" + CompID + " and cu.IsAudit>0 and isnull(cu.dr,0)=0 and isnull(dis.dr,0)=0";
string IDlist = string.Empty;//销售经理下属 员工ID集合
if (DisSalesManID != 0)
{
if (Common.GetDisSalesManType(DisSalesManID.ToString(), out IDlist))
{
//销售经理
where += "and cu.DisID in(select ID from BD_Distributor where smid in(" + IDlist + "))";
}
else
{
where += "and cu.DisID in(select ID from BD_Distributor where smid = " + DisSalesManID + ")";
}
}
if (!string.IsNullOrEmpty(txtDisName.Value.Trim()))
{
where += " and (dis.DisCode like '%" + txtDisName.Value.Trim().Replace("'", "''") + "%' or dis.DisName like '%" + txtDisName.Value.Trim().Replace("'", "''") + "%')";
}
//if (!string.IsNullOrEmpty(txtDisArea.areaId))
//{
// where += " and areaid='" + txtDisArea.areaId + "'";
//}
if (!string.IsNullOrEmpty(txtPhone.Value.Trim()))
{
where += " and dis.Phone like '%" + txtPhone.Value.Trim().Replace("'", "''") + "%'";
}
if (!string.IsNullOrEmpty(txtPrincipal.Value.Trim()))
{
where += " and dis.Principal like '%" + txtPrincipal.Value.Trim().Replace("'", "''") + "%'";
}
if (ddlAUState.SelectedValue != "-1")
{
where += " and cu.IsAudit='" + ddlAUState.SelectedValue + "'";
}
if (ddlState.SelectedValue != "-1")
{
where += " and cu.IsEnabled='" + ddlState.SelectedValue + "'";
}
if (txtCreateDate.Value.Trim() != "")
{
where += " and dis.createdate>='" + txtCreateDate.Value.Trim() + "' ";
}
if (txtEndCreateDate.Value.Trim() != "")
{
where += " and dis.createdate<='" + txtEndCreateDate.Value.Trim() + "' ";
}
return(where);
}
/// <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;
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 = 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();
}
if (this.ddrState.Value != "-2")
{
strwhere += " and ReturnState=" + Common.NoHTML(this.ddrState.Value.Trim().ToString());
}
string type = Request.QueryString["type"] + "";
if (type == "")
{
this.Ostate1.Attributes.Add("style", "display:block;");
this.Ostate2.Attributes.Add("style", "display:block;");
strwhere += "and CompID=" + this.CompID + " and (ReturnState>" + (int)Enums.AuditState.未提交 + " or ReturnState=" + (int)Enums.AuditState.退回 + ") and isnull(dr,0)=0"; //IsDel=1 订单已删除
}
else
{
this.Ostate1.Attributes.Add("style", "display:none;");
this.Ostate2.Attributes.Add("style", "display:none;");
strwhere += "and CompID=" + this.CompID + " and ReturnState>=" + (int)Enums.AuditState.已审 + " and OrderID in (select Id from DIS_Order where PayState=" + (int)Enums.PayState.已支付 + ") 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_OrderReturn> l = OrderReturnBll.GetList(Pager.PageSize, Pager.CurrentPageIndex, "ReturnDate", false, strwhere, out pageCount, out Counts);
this.rptOrder.DataSource = l;
this.rptOrder.DataBind();
Pager.RecordCount = Counts;
page = Pager.CurrentPageIndex.ToString();
}
