예제 #1
0
    protected void QueryWhere(string number, int volume, string condition, string compare, string content)
    {
        string strwhere = " and assister='" + Session["Member"].ToString() + "' and isagain=0 and  DefrayState>-2 ";


        BLL.Registration_declarations.PagerParmsInit model = bll.GetMemberOrderList(condition, compare, content, strwhere);

        if (type == 1)
        {
            if (Request.QueryString["dd"] != null)
            {
                model.SqlWhere = model.SqlWhere + " and Convert(varchar,RegisterDate,23) ='" + Request.QueryString["dd"].ToString() + "'";
            }
        }
        else
        {
            model.SqlWhere = model.SqlWhere + " and B.OrderExpectNum=" + volume + "";
        }

        if (model.ErrInfo != null)
        {
            ScriptHelper.SetAlert(Page, model.ErrInfo);
        }
        else
        {
        }
    }
예제 #2
0
    protected void QueryWhere(string number, int volume, string condition, string compare, string content)
    {
        string strwhere = " and assister='" + Session["Member"].ToString() + "' and isagain=0 and  DefrayState>-2 ";

        //if (rdbtnType.SelectedValue != "-1")
        //{
        //    strwhere += " and  DefrayState=" + rdbtnType.SelectedValue + " ";
        //}

        //this.Pager1.Visible = true;
        BLL.Registration_declarations.PagerParmsInit model = bll.GetMemberOrderList(condition, compare, content, strwhere);

        if (type == 1)
        {
            if (Request.QueryString["dd"] != null)
            {
                model.SqlWhere = model.SqlWhere + " and Convert(varchar,RegisterDate,23) ='" + Request.QueryString["dd"].ToString() + "'";
            }
        }
        else
        {
            model.SqlWhere = model.SqlWhere + " and B.OrderExpectNum=" + volume + "";
        }

        if (model.ErrInfo != null)
        {
            ScriptHelper.SetAlert(Page, model.ErrInfo);
        }
        else
        {
            //this.Pager1.ControlName = "rep";
            //this.Pager1.key = model.Key;
            //this.Pager1.PageColumn = model.PageColumn;

            //this.Pager1.Pageindex = 0;
            //this.Pager1.PageTable = model.PageTable;
            //this.Pager1.Condition = model.SqlWhere;
            //this.Pager1.PageSize = model.PageSize;
            //this.Pager1.PageCount = 0;
            //this.Pager1.PageBind();
        }

        //Translate();
    }