private void bindrpt() { pager_org.TableName = "(select c.*,d.DEP_PZRS ,(DEP_PZRS-DEP_YDRS)as DEP_QBRS from (select ST_DEPID,DEP_NAME,ST_POSITION,DEP_POSITION,count(ST_NAME) as DEP_YDRS, stuff((select ','+ST_NAME from TBDS_STAFFINFO as b where (b.ST_POSITION=a.ST_POSITION and b.ST_POSITION is not null and b.ST_PD='0' ) for xml path('')),1,1,'') as ST_PEAPLE from View_TBDS_STAFFINFO as a where ST_PD='0' and ST_DEPID is not null and ST_POSITION is not null group by ST_DEPID,DEP_NAME,ST_POSITION,DEP_POSITION)as c left join TBDS_DEPINFO as d on c.ST_POSITION = d.DEP_CODE)t"; pager_org.PrimaryKey = "ST_POSITION"; pager_org.ShowFields = "* "; pager_org.OrderField = "ST_DEPID"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 0;//升序排列 pager_org.PageSize = 100; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptRYPZ, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } BindFooter(); }
private void bindrpt() { pager_org.TableName = "CM_SHCLD "; pager_org.PrimaryKey = "CLD_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "CLD_ID"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 1;//升序排列 pager_org.PageSize = 15; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptSHFWCLD, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } BindRbl(); }
private void bindGrid() { string sqlwhere = "1=1 and ST_PD in('0','2','4')"; if (txtname.Text != "") { sqlwhere += " and (ST_NAME like '%" + txtname.Text.ToString().Trim() + "%' or ST_WORKNO like '%" + txtname.Text.ToString().Trim() + "%') "; } if (ddl_Depart.SelectedValue != "00") { sqlwhere += " and ST_DEPID='" + ddl_Depart.SelectedValue + "'"; } InitPager(sqlwhere); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
/// <summary> /// 绑定repeater,分页控件,palNoData控件 /// </summary> private void BindData() { InitPager(); UCPaging1.PageSize = pager_org.PageSize; //每页显示的记录数 pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptLZSQJSX, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } if (Session["UserDeptID"].ToString() == "02") { sz_shr_an.Visible = true; } else { sz_shr_an.Visible = false; } }
private void bindrpt() { pager_org.TableName = "View_TM_TASKDQO"; pager_org.PrimaryKey = "MS_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "MS_ZONGXU"; //pager_org.OrderField = "dbo.f_formatstr(MS_ZONGXU, '.')"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 0;//升序排列 pager_org.PageSize = 20; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptZZMX, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
public void BindData() { if (Request["id"] == null) { int page = Convert.ToInt32(Request["page"]); int rows = Convert.ToInt32(Request["rows"]); InitPager(rows, page); DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); string sql = "select count(A.LXD_ID) from CM_GZLXD as A left join CM_GZLXD_NR as B on A.LXD_ID=B.NR_FATHERID"; DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql); int num = 0; if (dt1.Rows[0][0].ToString() != "" && dt1.Rows[0][0].ToString() != null) { num = Convert.ToInt32(dt1.Rows[0][0].ToString()); } string json = JsonHelper.CreateJsonParameters(dt, true, num); Response.Write(json); } else { string sql = "select a.*,b.* from CM_GZLXD as a left join CM_GZLXD_NR as b on a.LXD_ID=b.NR_FATHERID where a.LXD_ID=" + Request["id"].ToString(); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); string json = JsonHelper.CreateJsonOne(dt, true); Response.Write(json); } }
private void bindGrid() { InitPager(strWhere()); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } string sqlText = "select sum(cast(MONTH_MAX as float)),sum(cast(SLJE as float)),sum(cast(CE as float)) from (select a.*,b.SLJE,a.MONTH_MAX-b.SLJE as CE from dbo.TBOM_BGYP_Month_max as a left join (select sum(GET_MONEY) as SLJE,ST_DEPID,year,month from View_TBOM_BGYPAPPLY where WLBM not like '3-%' and IsCalculate='0' group by ST_DEPID,year,month)b on a.year=b.year and a.month=b.month and a.DEP_CODE=b.ST_DEPID and a.type='1')e where " + strWhere(); dt = DBCallCommon.GetDTUsingSqlText(sqlText); if (dt.Rows.Count > 0) { lblEDU.Text = dt.Rows[0][0].ToString(); lblSLTotal.Text = dt.Rows[0][1].ToString(); lblCE.Text = dt.Rows[0][2].ToString(); } }
private void bindGrid() { InitPager(strWhere()); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } string sqlText = "select sum(cast(GangWeiXiShu as float)),sum(cast(Money as float)) from (select Year, Month, State, DepId, Zonghe,b.Id, Score, DepartScore, GangWeiXiShu, Money, PosName, b.ST_ID, b.ST_NAME,b.DEP_NAME,ST_WORKNO,ST_SEQUEN,b.DEP_ID from TBDS_KaoHe_JXList as a left join dbo.TBDS_KaoHe_JXDetail as b on a.Context=b.Context left join TBDS_STAFFINFO as d on b.ST_ID=d.ST_ID where a.State='2')e where " + strWhere(); dt = DBCallCommon.GetDTUsingSqlText(sqlText); if (dt.Rows.Count > 0) { lblXiShuTotal.Text = dt.Rows[0][0].ToString(); lblGZTotal.Text = dt.Rows[0][1].ToString(); } }
private void bindrpt() { pager_org.TableName = "OM_RYPZ_JL"; pager_org.PrimaryKey = "ST_POSITION"; pager_org.ShowFields = "*,(DEP_PZRS - DEP_YDRS) as DEP_QBRS "; pager_org.OrderField = "ST_DEPID"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 0;//升序排列 pager_org.PageSize = 20; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptRYPZ, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } BindFooter(); }
private void databind() { pager.TableName = "TBOM_BGYPPCHZ"; pager.PrimaryKey = "Id"; pager.ShowFields = "*"; pager.OrderField = ""; pager.StrWhere = strWhere(); pager.OrderType = 1; pager.PageSize = 30; UCPaging1.PageSize = pager.PageSize; pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); if (dt.Rows.Count > 0) { double jine = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (!String.IsNullOrEmpty(dt.Rows[i]["TOTALPRICE"].ToString())) { jine += Convert.ToDouble(dt.Rows[i]["TOTALPRICE"].ToString().Trim()); } } totalprice.Text = jine.ToString(); } CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void BindrptZZMX() { pager_org.TableName = "(select a.*,b.MS_ID,b.MS_TUHAO,b.MS_ZONGXU,b.MS_NAME,b.MS_GUIGE,b.MS_CAIZHI,b.MS_UNUM,b.MS_NUM,b.MS_TUWGHT,b.MS_TUTOTALWGHT,b.MS_MASHAPE,b.MS_TECHUNIT,b.MS_YONGLIANG,b.MS_MATOTALWGHT,b.MS_LEN,b.MS_WIDTH,b.MS_NOTE,b.MS_XIALIAO,b.MS_PROCESS,b.MS_KU,b.MS_ALLBEIZHU from PM_SCDYTZ_MX as a left join View_TM_TASKDQO as b on (a.MX_MS_ID=b.MS_ID and a.MX_MS_ZONGXU=b.MS_ZONGXU) where MX_FATHERID='" + hidTZD_SJID.Value + "')t"; pager_org.PrimaryKey = "TZD_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "MS_ZONGXU"; //pager_org.OrderField = "dbo.f_formatstr(MS_ZONGXU, '.')"; pager_org.StrWhere = ""; pager_org.OrderType = 0;//升序排列 pager_org.PageSize = 20; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptZZMX, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void bindrpt() { pager_org.TableName = "OM_PXJH_SQ as a left join OM_SP as b on a.PX_SJID=b.SPFATHERID "; pager_org.PrimaryKey = "PX_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "PX_SJID,PX_BM,PX_FS"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 1;//升序排列 pager_org.PageSize = 15; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptPXJH, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } if (IsPostBack) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "aa", "aa()", true); } }
private void bindrpt() { asd.dt = new DataTable(); pager_org.TableName = "(select * from OM_PXJH_SQ as a left join OM_SP as b on a.PX_SJID=b.SPFATHERID where SPZT='y' and SPLX='LSPX' union all select * from OM_PXJH_SQ as a left join OM_SP as b on a.PX_SJID1=b.SPFATHERID where SPZT='y' and SPLX='NDPXJH')t"; pager_org.PrimaryKey = "PX_ID"; pager_org.ShowFields = "*"; pager_org.OrderField = "PX_ZJR"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 1;//升序排列 pager_org.PageSize = 15; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptPXJH, UCPaging1, palNoData); asd.dt = dt; if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void Databind() { pager.TableName = "OM_TravelDelay"; pager.PrimaryKey = "ID"; pager.ShowFields = "*"; pager.OrderField = "ID"; pager.StrWhere = strWhere(); pager.OrderType = 1; pager.PageSize = 15; UCPaging1.PageSize = pager.PageSize; pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, rptTravelDelay, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } //序号列翻页自增 for (int j = 0; j < rptTravelDelay.Items.Count; j++) { Label s = (Label)rptTravelDelay.Items[j].FindControl("lbXuhao"); s.Text = (j + 1 + (pager.PageIndex - 1) * UCPaging1.PageSize).ToString(); } }
private void Databind() { pager.TableName = "(select a.*,b.TA_SHLevel,b.TA_ZDRID,b.TA_SHRIDA,b.TA_SHRIDB,b.TA_SHRIDC from OM_TravelApplyDetail as a left join OM_TravelApply as b on a.TA_Code=b.TA_Code)t"; pager.PrimaryKey = ""; pager.ShowFields = "*"; pager.OrderField = "TA_Code"; pager.StrWhere = strWhere(); pager.OrderType = 1; pager.PageSize = 15; UCPaging1.PageSize = pager.PageSize; pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, rptTravel, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } //序号列翻页自增 for (int j = 0; j < rptTravel.Items.Count; j++) { Label s = (Label)rptTravel.Items[j].FindControl("lbXuhao"); s.Text = (j + 1 + (pager.PageIndex - 1) * UCPaging1.PageSize).ToString(); } }
private void bindrpt() { pager_org.TableName = "EQU_GXHT"; pager_org.PrimaryKey = "HT_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "HT_HTBH"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 1;//升序排列 pager_org.PageSize = PageSize(); UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptGXHT, UCPaging1, NoDataPane); int num = 0; double money = 0; foreach (RepeaterItem item in rptGXHT.Controls) { if (item.ItemType == ListItemType.Footer) { string sql = "select HT_ID,HT_HTBH,HT_HTZJ,HT_GF,HT_DH from EQU_GXHT where " + pager_org.StrWhere; DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql); foreach (DataRow dr in dt1.Rows) { string[] a = dr["HT_HTZJ"].ToString().Split(new char[] { '(', '元' }, StringSplitOptions.None); for (int i = 0, length = a.Length; i < length; i++) { money += CommonFun.ComTryDouble(a[i]); } } num = dt1.Rows.Count; ((Label)item.FindControl("lbNUM")).Text = num.ToString(); ((Label)item.FindControl("lbMONEY")).Text = money.ToString(); //if (num <= 1) //{ // btnBatchDelete.Visible = false; // quanxianKJ.Visible = false; //} break; } } for (int j = 0; j < rptGXHT.Items.Count; j++) { Label s = (Label)rptGXHT.Items[j].FindControl("lblXuHao"); s.Text = (j + 1 + (pager_org.PageIndex - 1) * UCPaging1.PageSize).ToString(); } if (NoDataPane.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } BindrblSP(); }
private void bindGrid() { string sqlwhere = "1=1"; if (txtCode.Text.Trim() != "") { sqlwhere += " and AFI_ID like '%" + txtCode.Text.Trim() + "%'"; } if (txtPTC.Text.Trim() != "") { sqlwhere += " and PTC like '%" + txtPTC.Text.Trim() + "%'"; } if (txtDep.Text.Trim() != "") { sqlwhere += " and AFI_TSDEP like '%" + txtDep.Text.Trim() + "%'"; } if (txtBJR.Text.Trim() != "") { sqlwhere += " and AFI_MANNM like '%" + txtBJR.Text.Trim() + "%'"; } if (txtStart.Text.Trim() != "") { sqlwhere += " and AFI_RQSTCDATE > '" + txtStart.Text.Trim() + "'"; } if (txtEnd.Text.Trim() != "") { sqlwhere += " and AFI_RQSTCDATE < '" + txtEnd.Text.Trim() + "'"; } if (txtZJR.Text.Trim() != "") { sqlwhere += " and AFI_QCMANNM like '%" + txtZJR.Text.Trim() + "%'"; } if (txtCS.Text.Trim() != "") { sqlwhere += " and AFI_ASSGSTATE like '%" + txtCS.Text.Trim() + "%'"; } if (ddlResult.SelectedValue != "") { sqlwhere += " and AFI_ENDRESLUT = '" + ddlResult.SelectedValue + "'"; } InitPager(sqlwhere); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
public void BindData() { if (Request["id"] == null) { int page = Convert.ToInt32(Request["page"]); int rows = Convert.ToInt32(Request["rows"]); InitPager(rows, page); DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); DataTable dt2 = new DataTable(); for (int i = 0, length = dt.Columns.Count; i < length; i++) { dt2.Columns.Add(dt.Columns[i].ColumnName); } for (int j = 0, length1 = dt.Rows.Count; j < length1; j++) { DataRow dr = dt2.NewRow(); for (int i = 0, length = dt.Columns.Count; i < length; i++) { dr[dt.Columns[i].ColumnName] = dt.Rows[j][i].ToString().Replace(" ", "").Trim().Replace("\r\n", "").Replace("\n", "").Replace("</br>", "").Replace("<br/>", ""); } dt2.Rows.Add(dr); } string sql = "select count(A.TZD_ID) from CM_TZTHTZD as A left join CM_TZTHTZD_NR as B on A.TZD_SJID=B.NR_FATHERID"; DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql); int num = 0; if (dt1.Rows[0][0].ToString() != "" && dt1.Rows[0][0].ToString() != null) { num = Convert.ToInt32(dt1.Rows[0][0].ToString()); } string json = JsonHelper.CreateJsonParameters(dt2, true, num); Response.Write(json); } else { string sql = "select a.*,b.* from CM_TZTHTZD as a left join CM_TZTHTZD_NR as b on a.TZD_SJID=b.NR_FATHERID where a.TZD_ID=" + Request["id"].ToString(); DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); DataTable dt2 = new DataTable(); for (int i = 0, length = dt.Columns.Count; i < length; i++) { dt2.Columns.Add(dt.Columns[i].ColumnName); } for (int j = 0, length1 = dt.Rows.Count; j < length1; j++) { DataRow dr = dt2.NewRow(); for (int i = 0, length = dt.Columns.Count; i < length; i++) { dr[dt.Columns[i].ColumnName] = dt.Rows[j][i].ToString().Replace(" ", "").Trim().Replace("\r\n", "").Replace("\n", "").Replace("</br>", "").Replace("<br/>", ""); } dt2.Rows.Add(dr); } string json = JsonHelper.CreateJsonOne(dt2, true); Response.Write(json); } }
private void bindrpt() { pager_org.TableName = "PC_CGHT"; pager_org.PrimaryKey = "HT_ID"; pager_org.ShowFields = "* "; pager_org.OrderField = "HT_ID"; pager_org.StrWhere = StrWhere(); pager_org.OrderType = 1;//升序排列 pager_org.PageSize = 15; UCPaging1.PageSize = pager_org.PageSize; pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptCGHTGL, UCPaging1, palNoData); foreach (RepeaterItem item in rptCGHTGL.Controls) { if (item.ItemType == ListItemType.Footer) { double money = 0; int num = 0; string sql = "select * from PC_CGHT "; if (pager_org.StrWhere.Trim() != "") { sql += " where " + pager_org.StrWhere; } DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql); foreach (DataRow dr in dt1.Rows) { string[] a = dr["HT_HTZJ"].ToString().Split(new char[] { '(', ')' }, StringSplitOptions.None); for (int i = 0, length = a.Length; i < length; i++) { money += CommonFun.ComTryDouble(a[i]); } } num = dt1.Rows.Count; ((Label)item.FindControl("lbNUM")).Text = num.ToString(); ((Label)item.FindControl("lbMONEY")).Text = money.ToString(); break; } } if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } BindrblSP(); }
private void bindGrid() { pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
/// <summary> /// 绑定PM_GongShi_List_Repeater数据 /// </summary> private void bindRepeater() { pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, PM_GongShi_List_Repeater, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
private void bindGrid() { pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, purchaseplan_start_list_Repeater, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
/// <summary> /// 给PM_GongShi_Detial_List_Repeater绑定数据,并初始化分页控件的属性 /// </summary> private void bindRepeater() { pager.PageIndex = UCPaging1.CurrentPage; //当前页数 System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); //分页查询 CommonFun.Paging(dt, PM_GongShi_Detial_List_Repeater, UCPaging1, NoDataPanel); //绑定数据 if (NoDataPanel.Visible) { UCPaging1.Visible = false;//如果无数据则分页控件不显示 } else { UCPaging1.Visible = true; //否则显示分页控件 UCPaging1.InitPageInfo(); //同时显示出分页控件中要显示的控件 } }
private void bindGrid() { string sqlwhere = "1=1"; if (dplYear.SelectedIndex != 0) { sqlwhere += " and Year='" + dplYear.SelectedValue + "' "; } if (dplMoth.SelectedIndex != 0) { sqlwhere += " and Month='" + dplMoth.SelectedValue + "' "; } if (txtname.Text != "") { sqlwhere += " and (ST_NAME like '%" + txtname.Text.ToString().Trim() + "%' or ST_WORKNO like '%" + txtname.Text.ToString().Trim() + "%') "; } if (ddl_Depart.SelectedValue != "00") { sqlwhere += " and DEP_CODE='" + ddl_Depart.SelectedValue + "'"; } InitPager(sqlwhere); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } string sqlText = "select sum(cast(ST_GANGWEIXISHU as float)),sum(cast(Money as float)) from (select * from View_TBDS_JXGZ as a inner join View_TBDS_KaoheDepartMonth as b on a.DEP_CODE=b.DepartId and a.Year=b.DepMonth_Year and a.Month=b.DepMonth_Month where b.state='2')c where " + sqlwhere; dt = DBCallCommon.GetDTUsingSqlText(sqlText); if (dt.Rows.Count > 0) { lblXiShuTotal.Text = dt.Rows[0][0].ToString(); lblGZTotal.Text = dt.Rows[0][1].ToString(); } }
private void bindrpt1() { InitPager1(); pager_org1.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt1 = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org1); CommonFun.Paging(dt1, rptKQTJ1, UCPaging1, palNoData1); if (palNoData1.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void bindGrid() { pager_gen.PageIndex = UCPagingGen.CurrentPage; DataTable dtGen = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_gen); CommonFun.Paging(dtGen, GridView2, UCPagingGen, NoDataPanelGen); if (NoDataPanelGen.Visible) { UCPagingGen.Visible = false; } else { UCPagingGen.Visible = true; UCPagingGen.InitPageInfo(); //分页控件中要显示的控件 } }
protected void GetBoundData() { pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, Repeater1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void bindGrid() { pager.PageIndex = ucPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, GridView2, ucPaging1, NoDataPanelGen); if (NoDataPanelGen.Visible) { ucPaging1.Visible = false; } else { ucPaging1.Visible = true; ucPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
private void bindrpt() { InitPager(); pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org); CommonFun.Paging(dt, rptGDGZrecord, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } }
private void bindGrid() { pager.PageIndex = UCPaging.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager); CommonFun.Paging(dt, GridView1, UCPaging, NoDataPanel); if (NoDataPanel.Visible) { UCPaging.Visible = false; } else { UCPaging.Visible = true; UCPaging.InitPageInfo(); //分页控件中要显示的控件 } }