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(); } }
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; } }
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(); } }
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(); } }
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(); } }
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(); } }
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; } }