Esempio n. 1
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            List <SearchField> list1 = search1.SearchConditon;
            list1.Add(new SearchField(String.Format("(zeren1='{0}' or zeren2='{0}')", User.Identity.Name), "", SearchOperator.用户定义));

            U_ZCBU  Zc1  = new U_ZCBU();
            DataSet ds1  = Zc1.GetMyZcInfo(list1);
            string  zcid = "";
            if (ds1.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        zcid = ds1.Tables[0].Rows[i]["id"].ToString();
                    }
                    else
                    {
                        zcid = zcid + "," + ds1.Tables[0].Rows[i]["id"].ToString();
                    }
                }
            }
            Session["Myzcid"]         = zcid;
            this.GridView1.DataSource = ds1;
            this.GridView1.DataBind();
            ds1.Dispose();
            Zc1.Close();
        }
    }
Esempio n. 2
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            int totalRow = 0;
            int curpage  = 1;

            List <SearchField> list1 = search1.SearchConditon;

            U_ZCBU   Zc1 = new U_ZCBU();
            DataSet  ds1 = Zc1.GetZcBaoList(list1, curpage, -1, out totalRow);
            DataView dv1 = ds1.Tables[0].DefaultView;
            dv1.Sort = "num2";

            this.GridView1.DataSource = dv1;
            this.GridView1.DataBind();
            ds1.Dispose();
            Zc1.Close();

            this.PageNavigator1.TotalRows   = totalRow;
            this.PageNavigator1.CurrentPage = curpage;
        }
    }
Esempio n. 3
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            List <SearchField> list1 = search1.SearchConditon;

            U_ZCTimeBU time1 = new U_ZCTimeBU();
            DataSet    ds1   = time1.GetMyDepartTimeListInfo(list1, User.Identity.Name, this.danwei.Text.Trim());
            this.GridView1.DataSource = ds1;
            this.GridView1.DataBind();
            time1.Close();
            ds1.Dispose();
        }
    }
Esempio n. 4
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            List <SearchField> list1 = search1.SearchConditon;

            U_ZCBU  zc1 = new U_ZCBU();
            DataSet ds1 = zc1.GetMyShenPiZcInfo(list1, User.Identity.Name, this.danwei.Text, 0);
            this.GridView1.DataSource = ds1;
            this.GridView1.DataBind();
            zc1.Close();
            ds1.Dispose();
        }
    }
Esempio n. 5
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            List <SearchField> list1 = search1.SearchConditon;
            list1.Add(new SearchField("zeren", "null", SearchOperator.空值));

            U_ZCBU  Zc1 = new U_ZCBU();
            DataSet ds1 = Zc1.GetSearchResult(list1);
            this.GridView1.DataSource = ds1;
            this.GridView1.DataBind();
            ds1.Dispose();
            Zc1.Close();
        }
    }
Esempio n. 6
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            int totalRow = 0;
            int curpage  = 1;

            List <SearchField> list1 = search1.SearchConditon;
            list1.Add(new SearchField("zeren", "null", SearchOperator.非空值));

            U_ZCBU   Zc1 = new U_ZCBU();
            DataSet  ds1 = Zc1.GetSearchResult(list1);
            DataView dv  = ds1.Tables[0].DefaultView;
            dv.Sort = "num2";
            this.GridView1.DataSource = dv;
            this.GridView1.DataBind();
            ds1.Dispose();
            Zc1.Close();
        }
    }
Esempio n. 7
0
    void AdvanceSearch1_OnMySearchClick(object sender, EventArgs e)
    {
        ZcMng1_AdvanceSearch search1 = sender as ZcMng1_AdvanceSearch;

        if (search1 != null)
        {
            int totalRow = 0;
            int curpage  = 1;

            List <SearchField> list1 = search1.SearchConditon;
            list1.Add(new SearchField("zeren", User.Identity.Name, SearchOperator.等于));

            U_ZCBU  Zc1 = new U_ZCBU();
            DataSet ds1 = Zc1.GetZcUserkingList(list1, curpage, -1, out totalRow);
            this.GridView1.DataSource = ds1;
            this.GridView1.DataBind();
            ds1.Dispose();
            Zc1.Close();

            this.PageNavigator1.TotalRows   = totalRow;
            this.PageNavigator1.CurrentPage = curpage;
        }
    }