protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, checked_list_Repeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
//clearData();
}
private void bindGrid()
{
pager_org.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager_org);
CommonFun.Paging(dt, rptProNumCost, 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, rptProNumCost, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
CheckUser(ControlFinder);
}
private void bindrpt()
{
InitPager();
pager_org.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rpt1, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
/// <summary>
/// 绑定tbpc_otherpurbill_list_Repeater数据
/// </summary>
private void bindRepeater()
{
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(); //分页控件中要显示的控件
}
}
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, 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, GridView1, 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, Reproject1, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
//CheckUser(ControlFinder);
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, pc_purinform_repeater, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
//CheckUser(ControlFinder);
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, grvQKJL, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
//CheckUser(ControlFinder);
}
protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, tbpc_purshaseplanassignRepeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
//clearData();
}
private void bindGrid()
{
InitPager();
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()
{
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();
}
}
private void bindGrid()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, rptTBCS_CUSUPINFO, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
Panel1.Visible = false;
}
else
{
UCPaging1.Visible = true;
Panel1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
}
}
protected void GetBoundData()
{
InitPager();
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, Purordertotal_list_Repeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void GetBoundData()
{
InitPager();
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager);
CommonFun.Paging(dt, grvYKJL, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
//DataTable dt = DBCProcPageing.Projects_Select(UCPaging1.CurrentPage, UCPaging1.PageSize);
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 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_BM,PX_FS,PX_BH";
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;
double xshj = 0;
double rshj = 0;
foreach (DataRow dr in dt.Rows)
{
xshj += CommonFun.ComTryDouble(dr["PX_SJXS"].ToString());
rshj += CommonFun.ComTryDouble(dr["PX_SJRS"].ToString());
}
foreach (RepeaterItem item in rptPXJH.Controls)
{
if (item.ItemType == ListItemType.Footer)
{
((Label)item.FindControl("XSHJ")).Text = xshj.ToString();
((Label)item.FindControl("RSHJ")).Text = rshj.ToString();
break;
}
}
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
protected void GetData()
{
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParamGroupBy(pager);
CommonFun.Paging(dt, grvRK, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
btnXTFP.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
btnXTFP.Visible = true;
}
}
protected void bindData()
{
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.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 bindrpt()
{
pager_org.TableName = "PM_CPFYJSD";
pager_org.PrimaryKey = "JS_ID";
pager_org.ShowFields = "* ";
pager_org.OrderField = "JS_ID";
pager_org.StrWhere = StrWhere();
pager_org.OrderType = 1;//升序排列
pager_org.PageSize = CommonFun.ComTryInt(ddl_pagesize.SelectedItem.Text.ToString());
UCPaging1.PageSize = pager_org.PageSize;
pager_org.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rptJSDGL, UCPaging1, NoDataPane);
//计算总金额
string sqlzong = "select * from PM_CPFYJSD where " + StrWhere() + " ";
System.Data.DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sqlzong);
double tot_money = 0;
for (int i = 0; i < dt1.Rows.Count; i++)
{
if (dt1.Rows[i]["JS_HSJE"].ToString() == "")
{
tot_money += 0;
}
else
{
tot_money += Convert.ToDouble(dt1.Rows[i]["JS_HSJE"].ToString());
}
}
lb_select_money.Text = tot_money.ToString("0.00");
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void bindGrid()
{
string sqlwhere = "1=1";
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(); //分页控件中要显示的控件
}
}
//点击查询时重新邦定，添加查询条件
private void RebindGrid()
{
selectaddgroupd.SelectedIndex = 0; //对添加下拉框进行初始化
InitPager();
pager.StrWhere = CreateConStr();
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 bindrpt()
{
asd.dt = new DataTable();
pager_org.TableName = "OM_PXDA as a left join OM_PXJH_SQ as b on a.DA_XMID=b.PX_ID left join dbo.View_TBDS_STAFFINFO as c on a.DA_CXRID = c.ST_ID";
pager_org.PrimaryKey = "DA_ID";
pager_org.ShowFields = "a.*,b.*,c.DEP_NAME ";
pager_org.OrderField = "DA_CXRID,DEP_NAME,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);
asd.dt = dt;
string sql = "select count(distinct(DA_CXR)) as RSHJ,sum(convert(float,case when ISNUMERIC(PX_SJXS)=1 then PX_SJXS else '0' end))as XSHJ from OM_PXDA as a left join OM_PXJH_SQ as b on a.DA_XMID=b.PX_ID left join dbo.View_TBDS_STAFFINFO as c on a.DA_CXRID = c.ST_ID where " + StrWhere();
DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sql);
foreach (RepeaterItem item in rptPXJH.Controls)
{
if (item.ItemType == ListItemType.Footer)
{
((Label)item.FindControl("XSHJ")).Text = dt1.Rows[0]["XSHJ"].ToString();
((Label)item.FindControl("RSHJ")).Text = dt1.Rows[0]["RSHJ"].ToString();
break;
}
}
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
}
private void databind()
{
string sqltext;
string str = Dfinddept1.SelectedValue;
if (Dfinddept1.SelectedValue == "00")
{
sqltext = "select distinct * from TBDS_DEPINFO where DEP_CODE LIKE '[0-9][0-9]' and DEP_SFJY='0'";
setpagerparm("TBDS_DEPINFO", "DEP_CODE", "*", "DEP_CODE", "DEP_CODE LIKE '[0-9][0-9]' and DEP_SFJY='0'", 0, 10);
}
else
{
//sqltext = "select * from TBDS_DEPINFO where DEP_CODE LIKE '" + str + "[0-9][0-9]' order by DEP_CODE";//不显示第一级
if (Radiogrouportw.SelectedValue == "1")//查看岗位/班组信息，生产部编码“04”
{
//sqltext = "select * from TBDS_DEPINFO where DEP_CODE LIKE '04%' order by DEP_CODE";
sqltext = "select * from TBDS_DEPINFO where DEP_CODE LIKE '" + str + "[0-9][0-9]' and DEP_SFJY='0' order by DEP_CODE";//不显示第一级
setpagerparm("TBDS_DEPINFO", "DEP_CODE", "*", "DEP_CODE", "DEP_CODE LIKE '" + str + "[0-9][0-9]' and DEP_SFJY='0'", 0, 10);
}
else //查看工种信息
{
sqltext = "select JC_ID AS DEP_CODE,JC_NAME AS DEP_NAME,JC_NOTE AS DEP_NOTE from TBDS_JOBCATINFO WHERE JC_DEPID='04' and JC_SFJY='0' order by JC_ID";
setpagerparm("TBDS_JOBCATINFO", "JC_ID", "JC_ID AS DEP_CODE,JC_NAME AS DEP_NAME,JC_NOTE AS DEP_NOTE", "JC_ID", "JC_DEPID='04' and JC_SFJY='0'", 0, 10);
}
}
pager.PageIndex = UCPaging1.CurrentPage;
DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, tbds_depinfoRepeater, UCPaging1, NoDataPane);
if (NoDataPane.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
CheckUser(ControlFinder);
}
Lnumber.Text = "共" + Convert.ToString(dt.Rows.Count) + "条记录";
}
private void bindGrid()
{
string sqlwhere = "1=1";
if (txtWLCode.Text != "")
{
sqlwhere += " and WLBM like '%" + txtWLCode.Text + "%'";
}
if (txtOrder.Text != "")
{
sqlwhere += " and CODE like '%" + txtOrder.Text + "%'";
}
if (txtName.Text != "")
{
sqlwhere += " and WLNAME like '%" + txtName.Text + "%'";
}
if (txtGuige.Text != "")
{
sqlwhere += " and WLMODEL like '%" + txtGuige.Text + "%'";
}
if (ddlIsRK.SelectedValue != "")
{
sqlwhere += " and STATE_rk ='" + ddlIsRK.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(); //分页控件中要显示的控件
}
}
private void bindGrid()
{
string shwhere = GetStrWhere();
string sqltext = "orderno,supplierid,suppliernm,zdtime,cgtimerq,pjid,pjnm,engid,pjid+'/'+engnm AS engnm,whstate,convert(float,zxnum) as zxnum,recgdnum,detailstate,detailcstate,marunit,convert(float,ctamount) as ctamount," +
"zdrid,zdrnm,shrid,shrnm,totalnote,totalstate,totalcstate,ptcode,PO_TUHAO,marid,marnm,margg,marcz,margb,PO_MASHAPE,length,width,PO_ZJE,PO_CGFS,ctprice,recdate ";
InitPager1("View_TBPC_PURORDERDETAIL_PLAN_TOTAL", "", sqltext, "zdtime desc,ptcode,marnm,margg", shwhere);
pager.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParam(pager);
CommonFun.Paging(dt, Purordertotal_list_Repeater, UCPaging1, NoDataPanel);
if (NoDataPanel.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo(); //分页控件中要显示的控件
//CheckUser(ControlFinder);
}
}
private void bindrpt()
{
InitPager();
pager_org.PageIndex = UCPaging1.CurrentPage;
System.Data.DataTable dt = CommonFun.GetDataByPagerQueryParamWithPriKey(pager_org);
CommonFun.Paging(dt, rptFGDZCBF, UCPaging1, palNoData);
if (palNoData.Visible)
{
UCPaging1.Visible = false;
}
else
{
UCPaging1.Visible = true;
UCPaging1.InitPageInfo();
}
for (int j = 0; j < rptFGDZCBF.Items.Count; j++)
{
Label s = (Label)rptFGDZCBF.Items[j].FindControl("lbXuHao");
s.Text = (j + 1 + (pager_org.PageIndex - 1) * UCPaging1.PageSize).ToString();
}
}
private void bindGrid()
{
string sqlwhere = "1=1";
if (txtBEditPer.Text != "")
{
sqlwhere += " and bSTNAME like '%" + txtBEditPer.Text.Trim() + "%'";
}
if (txtEdiePer.Text != "")
{
sqlwhere += " and EditPerName like '%" + txtEdiePer.Text.Trim() + "%'";
}
if (txtStart.Text != "")
{
sqlwhere += " and EditTime > '" + txtStart.Text.Trim() + "'";
}
if (txtEnd.Text != "")
{
sqlwhere += " and EditTime < '" + txtEnd.Text.Trim() + "'";
}
if (ddlCAOZUOType.SelectedValue != "00")
{
sqlwhere += " and Caozuo like '%" + ddlCAOZUOType.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(); //分页控件中要显示的控件
}
}
