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);
}
}
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 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 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 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);
}
}
/// <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 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()
{
//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()
{
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();
}
/// <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);
}
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;
}
}
}
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 databind()
{
string sqltext;
string str1 = DDlpartment.SelectedValue;
string str2 = DDlgroup.SelectedValue;
if (DDlpartment.SelectedValue == "00")//部门选择“全部”，此时岗位/班组为“全部”
{
#region
sqltext = "select distinct a.*,b.DEP_NAME from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE order by a.ST_ID";//选择所有部门人员
setpagerparm(" TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE", " ST_ID ", "a.*,b.DEP_NAME", "", "a.ST_PD=0", 0, 10);
#endregion
}
else//DropDownList1.SelectedValue != "00"
{
#region
if (DDlgroup.SelectedValue == "00")
{
sqltext = "select distinct a.*,b.DEP_NAME,d.DEP_NAME from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE where a.ST_CODE LIKE'" + str1 + "%' and a.ST_PD=0 order by a.ST_CODE";//查看所有选定部门的人员
setpagerparm(" TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE", " ST_CODE ", " a.*,b.DEP_NAME,d.DEP_NAME as DEP_NAME1 ", "", " a.ST_DEPID LIKE'" + str1 + "%' and a.ST_PD=0 ", 0, 10);
}
else//DropDownListgroup.SelectedValue != "00"
{
sqltext = "select distinct a.*,b.DEP_NAME,d.DEP_NAME from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE where a.ST_CODE LIKE'" + str2 + "%' and a.ST_PD=0 order by a.ST_CODE";//查看选定班组/岗位的人员
setpagerparm(" TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE", " ST_CODE ", " a.*,b.DEP_NAME,d.DEP_NAME as DEP_NAME1", "", " a.ST_DEPID LIKE'" + str2 + "%' and a.ST_PD=0 ", 0, 10);
}
#endregion
}
if (name.Text.ToString().Trim() != "")
{
#region
sqltext = "select distinct a.*,b.DEP_NAME,d.DEP_NAME from TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE where a.ST_NAME LIKE'%" + name.Text.ToString().Trim() + "%' and a.ST_PD=0 order by a.ST_CODE";
setpagerparm(" TBDS_STAFFINFO as a left join TBDS_DEPINFO as b on a.ST_DEPID=b.DEP_CODE left join TBDS_DEPINFO as d on left(a.ST_CODE,4)=d.DEP_CODE", " ST_CODE ", " a.*,b.DEP_NAME,d.DEP_NAME as DEP_NAME1 ", "", " a.ST_NAME LIKE'%" + name.Text.ToString().Trim() + "%' and a.ST_PD=0 ", 0, 10);
#endregion
}
#region
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, tbds_staffinfoRepeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
//CheckUser(ControlFinder);
}
#endregion
//Lnumber.Text = "共" + Convert.ToString(dt.Rows.Count) + "条记录";
}
private void databind()
{
pager.TableName = "OM_StaffChange";
pager.PrimaryKey = "";
pager.ShowFields = "SC_STDepID,SC_STDep,SC_DepNum,SC_YearMonth,SC_IncNum,SC_DecNum,SC_IncPersonInfo,SC_DecPersonInfo,SC_ChangeInfo,SC_Note";
pager.OrderField = "SC_STDepID,SC_YearMonth";
pager.StrWhere = StrWhere();
pager.OrderType = 0;
pager.PageSize = int.Parse(ddl_pageno.SelectedValue);
UCPaging1.PageSize = pager.PageSize;
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, rptstaffchange, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;//如果筛选结果没有，则UCPaging不显示
prow.Visible = false;
}
else
{
UCPaging1.Visible = true;
prow.Visible = true;
UCPaging1.InitPageInfo();
}
int lbnownum = 0;
int lbincnum = 0;
int lbdecnum = 0;
Label lb_lastnum = (Label)rptstaffchange.Controls[rptstaffchange.Controls.Count - 1].FindControl("lb_lastnum");
Label lb_nownum = (Label)rptstaffchange.Controls[rptstaffchange.Controls.Count - 1].FindControl("lb_nownum");
Label lb_incnum = (Label)rptstaffchange.Controls[rptstaffchange.Controls.Count - 1].FindControl("lb_incnum");
Label lb_decnum = (Label)rptstaffchange.Controls[rptstaffchange.Controls.Count - 1].FindControl("lb_decnum");
for (int i = 0; i < rptstaffchange.Items.Count; i++)
{
Label s = (Label)rptstaffchange.Items[i].FindControl("lbXuHao");
Label lbSC_DepNum = (Label)rptstaffchange.Items[i].FindControl("lbSC_DepNum");
Label lbSC_IncNum = (Label)rptstaffchange.Items[i].FindControl("lbSC_IncNum");
Label lbSC_DecNum = (Label)rptstaffchange.Items[i].FindControl("lbSC_DecNum");
s.Text = (i + 1 + (pager.PageIndex - 1) * UCPaging1.PageSize).ToString();
lbnownum += CommonFun.ComTryInt(lbSC_DepNum.Text.ToString().Trim());
lbincnum += CommonFun.ComTryInt(lbSC_IncNum.Text.ToString().Trim());
lbdecnum += CommonFun.ComTryInt(lbSC_DecNum.Text.ToString().Trim());
}
lb_nownum.Text = lbnownum.ToString();
lb_incnum.Text = lbincnum.ToString();
lb_decnum.Text = lbdecnum.ToString();
lb_lastnum.Text = (lbnownum - lbincnum + lbdecnum).ToString();
CellsMerge(rptstaffchange);
}
private void bindGrid()
{
pager_org.PageIndex = UCPaging1.CurrentPage;
System.Data.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 bindRepeater()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, details_repeater, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
}
private void bindGrid()
{
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;
}
}
protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void GetBoundData()
{
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();
}
}
private void bindGrid()
{
pager_org.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager_org);
CommonFun.Paging(dt, grv, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
}
private void bindGrid(UCPaging ParamUCPaging, GridView ParamGridView, Panel ParamPanel)
{
pager_org.PageIndex = ParamUCPaging.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager_org);
CommonFun.Paging(dt, ParamGridView, ParamUCPaging, ParamPanel);
if (ParamPanel.Visible)
{
ParamUCPaging.Visible = false;
}
else
{
ParamUCPaging.Visible = true;
ParamUCPaging.InitPageInfo(); //分页控件中要显示的控件
}
}
protected void GetBoundData4()
{
pager4.PageIndex = UCPaging4.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager4);
CommonFun.Paging(dt, gridview4, UCPaging4, NoDataPanel4);
if (NoDataPanel4.Visible)
{
UCPaging4.Visible = false;
}
else
{
UCPaging4.Visible = true;
UCPaging4.InitPageInfo();
}
}
private void bindGridMS()
{
pager_ms.PageIndex = UCPagingMS.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager_ms);
CommonFun.Paging(dt, GridView1, UCPagingMS, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPagingMS.Visible = false;
}
else
{
UCPagingMS.Visible = true;
UCPagingMS.InitPageInfo(); //分页控件中要显示的控件
}
}
protected void GetBoundData2()
{
pager2.PageIndex = UCPaging2.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager2);
CommonFun.Paging(dt, gridview2, UCPaging2, NoDataPanel2);
if (NoDataPanel2.Visible)
{
UCPaging2.Visible = false;
}
else
{
UCPaging2.Visible = true;
UCPaging2.InitPageInfo();
}
}
protected void GetManutAssignData()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, pm_projectplan_view_repeater, UCPaging1, NoDataPane1);
if (NoDataPane1.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, tbpc_otherpurbill_list_Repeater, UCPaging1, NoDataPanel);
if (NoDataPanel.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();
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, grvDDBill, UCPaging1, pal_NoData);
if (pal_NoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
}
private void bindGrid()
{
bindnum(pager.StrWhere);
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GridView1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
/// <summary>
/// 绑定GRV_CON数据
/// </summary>
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, GRV_CON, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
//CheckUser(ControlFinder);
}