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(); //分页控件中要显示的控件
}
}
