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 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 bindGrid() { pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); //控制其不出现当前页码大于尾页情况 while (dt.Rows.Count == 0 && pager.PageIndex > 1) { pager.PageIndex = UCPaging1.CurrentPage - 1; UCPaging1.CurrentPage = pager.PageIndex; dt = CommonFun.GetDataByPagerQueryParam(pager); } CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } bindControl(); SetRadioButtonTip(); }
private void bindGrid() { //DataTable dt = DBCProcPageing.Projects_Select(UCPaging1.CurrentPage, UCPaging1.PageSize); pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, Reproject1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } foreach (RepeaterItem e_id in Reproject1.Items) { Label lbstate = (Label)e_id.FindControl("lbstate"); switch (lbstate.Text) { case "0": lbstate.Text = "进行中"; break; case "1": lbstate.Text = "完工"; break; case "2": lbstate.Text = "停工"; break; } } }
private void bindGrid(string ym) { pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager); CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel); GridView1.Visible = true; if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } if (ym == "year") { GridView1.Columns[3].Visible = false; } else if (ym == "month") { GridView1.Columns[3].Visible = true; } }
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"; sqlwhere += " and KQ_DATE='" + dplYear.SelectedValue + "-" + dplMoth.SelectedValue + "' "; if (txtSCZH.Text != "") { sqlwhere += " and (ST_NAME='" + txtSCZH.Text + "' or KQ_PersonID='" + txtSCZH.Text + "') "; } InitPager(sqlwhere); pager_org.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); if (palNoData.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
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 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> /// 分页初始化 /// </summary> private void bindGrid() { pager.TableName = "VIEW_TBDS_PS"; pager.PrimaryKey = "ST_ID"; pager.ShowFields = "*"; pager.OrderField = "ST_ZDSJ"; pager.StrWhere = strWhere(); pager.OrderType = 1; //按时间升序序排列 pager.PageSize = 12; UCPaging1.PageSize = pager.PageSize; //每页显示的记录数 //pager.PageIndex = 1; pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, grvSP, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 } }
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 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(); } }
private void bindGrid(Repeater ParamRepeater) { pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, ParamRepeater, UCPaging1, NoDataPanel); ParamRepeater.Visible = true; if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } if (ParamRepeater.Equals(rpt_monthMar)) { rpt_monthType.DataSource = null; rpt_monthType.DataBind(); rpt_monthType.Visible = false; } else { rpt_monthMar.DataSource = null; rpt_monthMar.DataBind(); rpt_monthMar.Visible = false; } }
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() { 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 = "View_TM_TaskAssign as a left join (select MS_ENGID,MS_MAP,MS_CHILDENGNAME,MS_SUBMITTM,ROW_NUMBER() over(partition by MS_ENGID,MS_MAP order by MS_SUBMITTM desc) as rows from TBPM_MSFORALLRVW) as b on a.TSA_ID=b.MS_ENGID"; pager.PrimaryKey = "TSA_ID"; pager.ShowFields = "TSA_ID,TSA_PJID,CM_PROJ,TSA_ENGNAME,TSA_CONTYPE,TSA_TCCLERKNM,TSA_REVIEWER,TSA_STARTDATE,TSA_MSFINISHTIME,TSA_MPCOLLECTTIME,TSA_TECHTIME,TSA_TUZHUANGTIME,TSA_ZHUANGXIANGDANTIME,substring(MS_SUBMITTM,0,11)MS_SUBMITTM,rows,MS_MAP,MS_CHILDENGNAME"; //2018年1月18修改将MS_SUBMITTM时间段改为精确到日 pager.OrderField = ddlSort.SelectedValue; pager.StrWhere = CreateWhere(); pager.PageSize = 20; pager.PageIndex = UCPaging1.CurrentPage; UCPaging1.PageSize = pager.PageSize; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); //dt.Columns.Add("EndTime"); //for (int i = 0; i < dt.Rows.Count; i++) //{ // string taskId = dt.Rows[i]["TSA_ID"]; // string sql = "select MS_SUBMITTM from TBPM_MSFORALLRVW where MS_ENGID='"+taskId+"' order by MS_SUBMITTM"; // DataTable dtTime = DBCallCommon.GetDTUsingSqlText(sql); // if (dtTime.Rows.Count>0) // { // } //} CommonFun.Paging(dt, gr, UCPaging1, NoDataPanel); if (NoDataPanel.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() { if (name.Text.ToString().Trim() != "") { string sqltext; sqltext = "select * from EQU_tzsb where Name LIKE'%" + name.Text.ToString().Trim() + "%' order by Id"; setpagerparm("EQU_tzsb", "Id", "Id*1 as Id,Code,Name,Type,Specification,Ocode,Rcode,Ucode,Manufa,Position,Ustate,Redate,Remark", "", "Name LIKE'%" + name.Text.ToString().Trim() + "%'", 0, 10); } else { string sqltext; sqltext = "select * from EQU_tzsb order by Id"; setpagerparm("EQU_tzsb", "Id", "Id*1 as Id,Code,Name,Type,Specification,Ocode,Rcode,Ucode,Manufa,Position,Ustate,Redate,Remark", "", "Name LIKE'%" + name.Text.ToString().Trim() + "%'", 0, 10); DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); } pager.PageIndex = UCPaging1.CurrentPage; DataTable dt1 = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt1, tzsbRepeater, UCPaging1, NoDataPane); if (NoDataPane.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //CheckUser(ControlFinder); } }
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 databind() { pager.TableName = "View_TBDS_STAFFINFO_record"; pager.PrimaryKey = "ST_ID"; pager.ShowFields = "*"; pager.OrderField = "ST_ID"; pager.StrWhere = StrWhere(); pager.OrderType = 0; pager.PageSize = int.Parse(ddl_pageno.SelectedValue); UCPaging1.PageSize = pager.PageSize; pager.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, SmartGridView1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false;//如果筛选结果没有,则UCPaging不显示 //deletebt.Visible = false;//如果筛选结果没有,则删除按钮不显示 } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //deletebt.Visible = true; } string sql = "select ST_ID from View_TBDS_STAFFINFO_record where " + StrWhere(); lb_People.Text = DBCallCommon.GetDTUsingSqlText(sql).Rows.Count.ToString();//多少行就有多少人 }
private void bindGrid() { string shwhere = ""; if (ddlSearch.SelectedValue != "-请选择-") { shwhere = "CL_CODE like '" + ddlSearch.SelectedValue + "%'"; } else { shwhere = "CL_FATHERCODE='root'"; } sqlText = " CL_CODE,CL_NAME,CL_FATHERCODE,CL_MANCLERK,CL_FILLDATE,CL_NOTE "; InitPager1("TBCS_LOCINFO", "CL_CODE", sqlText, "CL_CODE", shwhere); pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, Reproject1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 CheckUser(ControlFinder); } }
/// <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 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 bindGrid() { pager_org.PageIndex = UCPaging1.CurrentPage; System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager_org); CommonFun.Paging(dt, rptProNumCost, UCPaging1, palNoData); int zongji = 0; if (palNoData.Visible) { UCPaging1.Visible = false; heji.Visible = false; zonge.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); //分页控件中要显示的控件 heji.Visible = true; zonge.Visible = true; } for (int i = 0; i < dt.Rows.Count; i++) { zongji += (CommonFun.ComTryInt(dt.Rows[i]["CB_HeJihj"].ToString())); } heji.Text = zongji.ToString(); }
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 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(); //分页控件中要显示的控件 } }
/// <summary> /// 翻页事件处理程序 /// </summary> /// <param name="i">判读是否用代码触发,如果i=1,则是用代码触发</param> private void UCPaging_PageChanged(int i) { switch (i) { case 1: pager.PageIndex = 1; break; default: pager.PageIndex = UCPaging.CurrentPage; break; } CommonFun.Paging(rpt_task_list, CommonFun.GetDataByPagerQueryParam(pager), UCPaging, pal_container, NoDataPanel); }
protected void GetBoundData() { pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } foreach (GridViewRow gr in GridView1.Rows) { Label applyer = (Label)gr.FindControl("lblManapl"); if (applyer.Text.Trim() == Session["UserName"].ToString()) { gr.FindControl("hplmod").Visible = true; gr.FindControl("lnkDelete").Visible = true; } else { gr.FindControl("hplmod").Visible = false; gr.FindControl("lnkDelete").Visible = false; } Label tcstate = (Label)gr.FindControl("tcstate"); Label code = (Label)gr.FindControl("lblCode"); string sqltext = "select SC_CHECK1,SC_CHECK2 from ViewOM_SEAL where CODE='" + code.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); if (dr.Read()) { check1 = dr["SC_CHECK1"].ToString(); check2 = dr["SC_CHECK2"].ToString(); } dr.Close(); if (tcstate.Text.Trim() == "已审批" | tcstate.Text.Trim() == "已驳回") { gr.FindControl("hplreview").Visible = false; } else { if (Session["UserName"].ToString() == check1 | Session["UserName"].ToString() == check2) { gr.FindControl("hplreview").Visible = true; } else { gr.FindControl("hplreview").Visible = false; } } } }
private void bindGrid() { pager.PageIndex = UCPaging1.CurrentPage; DataTable dt = CommonFun.GetDataByPagerQueryParam(pager); CommonFun.Paging(dt, Repeater1, UCPaging1, NoDataPanel); if (NoDataPanel.Visible) { UCPaging1.Visible = false; } else { UCPaging1.Visible = true; UCPaging1.InitPageInfo(); } foreach (RepeaterItem e_id in Repeater1.Items) { Label lbstate = (Label)e_id.FindControl("lbstate"); int n = Convert.ToInt32(lbstate.Text); switch (n) { case 0: lbstate.Text = "正在跟踪"; break; case 1: lbstate.Text = "中标"; break; case 2: lbstate.Text = "项目未定"; break; case 3: lbstate.Text = "未中标"; break; case 4: lbstate.Text = "未参加投标"; break; case 5: lbstate.Text = "正在投标"; break; case 6: lbstate.Text = "转公司"; break; case 7: lbstate.Text = "取消报价"; break; } } }