コード例 #1
0
ファイル: HuiBao.aspx.cs プロジェクト: cnbin/HLB
 public void DataBindToGridview()
 {
     ZWL.BLL.ERPHuiBao MyModel = new ZWL.BLL.ERPHuiBao();
     ZWL.BLL.ERPBuMen BuMenModel = new ZWL.BLL.ERPBuMen();
     string Department_ID = BuMenModel.GetList("BuMenName='" + ZWL.Common.PublicMethod.GetSessionValue("Department") + "'").Tables[0].Rows[0]["ID"].ToString();
     DataSet ds = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName='******'%" + this.TextBox1.Text + "%' and CHARINDEX('" + Department_ID + "',p_depart_ids)>0 order by ID desc");
     if (ds!=null)
     {
         GVData.DataSource = ds;
         GVData.DataBind();
         LabPageSum.Text = Convert.ToString(GVData.PageCount);
         LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
         this.GoPage.Text = LabCurrentPage.Text.ToString();
     }
 }
コード例 #2
0
ファイル: BuMenInfoSerch.aspx.cs プロジェクト: cnbin/HLB
    public void DataBindToGridview()
    {
        ZWL.BLL.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen();
        string DirID = "0";
        try
        {
            DirID = Request.QueryString["DirID"].ToString();
        }
        catch { }

        GVData.DataSource = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%"+this.TextBox1.Text+"%' order by ID desc");
        GVData.DataBind();
        LabPageSum.Text = Convert.ToString(GVData.PageCount);
        LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
        this.GoPage.Text = LabCurrentPage.Text.ToString();
    }
コード例 #3
0
ファイル: HuiBao.aspx.cs プロジェクト: cnbin/HLB
    public void DataBindToGridview()
    {
        ZWL.BLL.ERPHuiBao MyModel       = new ZWL.BLL.ERPHuiBao();
        ZWL.BLL.ERPBuMen  BuMenModel    = new ZWL.BLL.ERPBuMen();
        string            Department_ID = BuMenModel.GetList("BuMenName='" + ZWL.Common.PublicMethod.GetSessionValue("Department") + "'").Tables[0].Rows[0]["ID"].ToString();
        DataSet           ds            = MyModel.GetList("TitleStr Like '%" + this.TextBox1.Text + "%' and UserName='******'%" + this.TextBox1.Text + "%' and CHARINDEX('" + Department_ID + "',p_depart_ids)>0 order by ID desc");
        if (ds != null)
        {
            GVData.DataSource = ds;
            GVData.DataBind();
            LabPageSum.Text     = Convert.ToString(GVData.PageCount);
            LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
            this.GoPage.Text    = LabCurrentPage.Text.ToString();
        }
    }
コード例 #4
0
ファイル: BuMenInfo.aspx.cs プロジェクト: YJGGIT422/OAweb
    public void DataBindToGridview()
    {
        ZWL.BLL.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen();
        string           DirID      = "0";

        try
        {
            DirID = Request.QueryString["DirID"].ToString();
        }
        catch { }


        GVData.DataSource = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%" + this.TextBox1.Text + "%' order by ID desc");
        GVData.DataBind();
        LabPageSum.Text     = Convert.ToString(GVData.PageCount);
        LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
        this.GoPage.Text    = LabCurrentPage.Text.ToString();
    }
コード例 #5
0
    public void DataBindToGridview()
    {
        GVData.PageSize  = AspNetPager1.PageSize;
        GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1;
        ZWL.BLL.ERPBuMen MyERPBuMen = new ZWL.BLL.ERPBuMen();
        string           DirID      = "0";

        try
        {
            DirID = Request.QueryString["DirID"].ToString();
        }
        catch { }


        DataSet ds = MyERPBuMen.GetList("DirID=" + DirID + " and BuMenName Like '%" + this.TextBox1.Text + "%' order by ID desc");

        GVData.DataSource = ds;
        GVData.DataBind();
        AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
    }