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