/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "T_Test_Table";
* parameters[1].Value = "F_ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
public PagerTable GetPagerList(string swhere, string orderby, int pageindex, int pagesize)
{
string strWhere = "";
if (!string.IsNullOrEmpty(swhere.Trim()))
{
strWhere += " where " + swhere;
}
PagerTable pt = new PagerTable();
pt.TotalCount = DbHelperSQL.GetCount("T_Test_Table b", strWhere);
StringBuilder strSql = new StringBuilder();
strSql.Append("select F_ID,F_TempleteID,F_Time,REPLACE(F_BannerContent,'$','') F_BannerContent ,F_IsShow ,Case When F_IsShow =0 then '' else '是' end Show ");
strSql.Append(" FROM T_Test_Table ");
strSql.Append(strWhere);
if (!string.IsNullOrEmpty(orderby))
{
strSql.Append(" order by " + orderby);
}
pt.DataSource = DbHelperSQL.Query(strSql.ToString(), pageindex, pagesize).Tables[0];
return(pt);
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "T_Audit";
* parameters[1].Value = "F_ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
public PagerTable GetPagerList(string swhere, string orderby, int pageindex, int pagesize)
{
string strWhere = "";
if (!string.IsNullOrEmpty(swhere.Trim()))
{
strWhere += " where " + swhere;
}
PagerTable pt = new PagerTable();
pt.TotalCount = DbHelperSQL.GetCount("T_Audit b", strWhere);
StringBuilder strSql = new StringBuilder();
strSql.Append(" select e.F_Name as UserName,w.F_StateName, b.F_ID,b.F_Name,b.F_Content,b.F_Money,b.F_Time,b.F_WF_StateID,b.F_UserID,b.F_IsDelete,b.F_Date,b.F_Type from T_Audit b");
strSql.Append(" Left join T_Employee e on b.F_UserID =e.F_ID ");
strSql.Append(" Left join (select * from T_WorkFlow_Templete where F_LinkTask='" + Library.DataDictionary.WorkFlowLinkTable.Audit + "') w on b.F_WF_StateID =w.F_StateID ");
strSql.Append(strWhere);
if (!string.IsNullOrEmpty(orderby))
{
strSql.Append(" order by " + orderby);
}
pt.DataSource = DbHelperSQL.Query(strSql.ToString(), pageindex, pagesize).Tables[0];
return(pt);
}
private void BandGridData()
{
string sWhere = "b.F_IsDelete=0 and b.F_Type = 0 ";
if (!string.IsNullOrEmpty(this.txtKey.Text.Trim()))
{
sWhere += " and b.F_Name like '%" + this.txtKey.Text.Trim() + "%'";
}
string sOrder = "b.F_Time";
PagerTable pt = SystemManager.Instance.Services.AuditService.GetPagerList(sWhere, sOrder, DataPager.PageSize * (DataPager.PageIndex - 1), DataPager.PageSize);
DataPager.TotalCount = pt.TotalCount;
this.GridView.DataSoure = pt.DataSource;
}
private void BandGridData()
{
if (!string.IsNullOrEmpty(m_TempleteId))
{
string sWhere = "F_TempleteID=" + m_TempleteId;
if (!string.IsNullOrEmpty(txtKey.Text.Trim()))
{
sWhere += " and F_BannerContent like '%" + txtKey.Text.Trim() + "%'";
}
PagerTable pt = SystemManager.Instance.Services.Test_TableService.GetPagerList(sWhere, "F_Time DESC", DataPager.PageSize * (DataPager.PageIndex - 1), DataPager.PageSize);
DataPager.TotalCount = pt.TotalCount;
this.GridView.DataSoure = pt.DataSource;
}
}
/// <devdoc>
/// <para>
/// Creates a DetailsViewRow that contains the paging UI.
/// The paging UI is a navigation bar that is a built into a single TableCell that
/// spans across all fields of the DetailsView.
/// </para>
/// </devdoc>
protected virtual void InitializePager(DetailsViewRow row, PagedDataSource pagedDataSource) {
TableCell cell = new TableCell();
PagerSettings pagerSettings = PagerSettings;
if (_pagerTemplate != null) {
_pagerTemplate.InstantiateIn(cell);
}
else {
PagerTable pagerTable = new PagerTable();
TableRow pagerTableRow = new TableRow();
cell.Controls.Add(pagerTable);
pagerTable.Rows.Add(pagerTableRow);
switch (pagerSettings.Mode) {
case PagerButtons.NextPrevious:
CreateNextPrevPager(pagerTableRow, pagedDataSource, false);
break;
case PagerButtons.Numeric:
CreateNumericPager(pagerTableRow, pagedDataSource, false);
break;
case PagerButtons.NextPreviousFirstLast:
CreateNextPrevPager(pagerTableRow, pagedDataSource, true);
break;
case PagerButtons.NumericFirstLast:
CreateNumericPager(pagerTableRow, pagedDataSource, true);
break;
}
}
cell.ColumnSpan = 2;
row.Cells.Add(cell);
}
/// <devdoc>
/// <para>
/// Creates a GridViewRow that contains the paging UI.
/// The paging UI is a navigation bar that is a built into a single TableCell that
/// spans across all fields of the GridView.
/// </para>
/// </devdoc>
protected virtual void InitializePager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource) {
TableCell cell = new TableCell();
if (columnSpan > 1) {
cell.ColumnSpan = columnSpan;
}
PagerSettings pagerSettings = PagerSettings;
if (_pagerTemplate != null) {
InitializeTemplateRow(row, columnSpan);
}
else {
PagerTable pagerTable = new PagerTable();
TableRow pagerTableRow = new TableRow();
switch (pagerSettings.Mode) {
case PagerButtons.NextPrevious:
CreateNextPrevPager(pagerTableRow, pagedDataSource, false);
break;
case PagerButtons.Numeric:
CreateNumericPager(pagerTableRow, pagedDataSource, false);
break;
case PagerButtons.NextPreviousFirstLast:
CreateNextPrevPager(pagerTableRow, pagedDataSource, true);
break;
case PagerButtons.NumericFirstLast:
CreateNumericPager(pagerTableRow, pagedDataSource, true);
break;
}
cell.Controls.Add(pagerTable);
pagerTable.Rows.Add(pagerTableRow);
row.Cells.Add(cell);
}
}
protected virtual void InitializePager(DetailsViewRow row, PagedDataSource pagedDataSource)
{
TableCell container = new TableCell();
System.Web.UI.WebControls.PagerSettings pagerSettings = this.PagerSettings;
if (this._pagerTemplate != null)
{
this._pagerTemplate.InstantiateIn(container);
}
else
{
PagerTable child = new PagerTable();
TableRow row2 = new TableRow();
container.Controls.Add(child);
child.Rows.Add(row2);
switch (pagerSettings.Mode)
{
case PagerButtons.NextPrevious:
this.CreateNextPrevPager(row2, pagedDataSource, false);
break;
case PagerButtons.Numeric:
this.CreateNumericPager(row2, pagedDataSource, false);
break;
case PagerButtons.NextPreviousFirstLast:
this.CreateNextPrevPager(row2, pagedDataSource, true);
break;
case PagerButtons.NumericFirstLast:
this.CreateNumericPager(row2, pagedDataSource, true);
break;
}
}
container.ColumnSpan = 2;
row.Cells.Add(container);
}
protected virtual void InitializePager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource)
{
TableCell cell = new TableCell();
if (columnSpan > 1)
{
cell.ColumnSpan = columnSpan;
}
System.Web.UI.WebControls.PagerSettings pagerSettings = this.PagerSettings;
if (this._pagerTemplate != null)
{
this.InitializeTemplateRow(row, columnSpan);
}
else
{
PagerTable child = new PagerTable();
TableRow row2 = new TableRow();
switch (pagerSettings.Mode)
{
case PagerButtons.NextPrevious:
this.CreateNextPrevPager(row2, pagedDataSource, false);
break;
case PagerButtons.Numeric:
this.CreateNumericPager(row2, pagedDataSource, false);
break;
case PagerButtons.NextPreviousFirstLast:
this.CreateNextPrevPager(row2, pagedDataSource, true);
break;
case PagerButtons.NumericFirstLast:
this.CreateNumericPager(row2, pagedDataSource, true);
break;
}
cell.Controls.Add(child);
child.Rows.Add(row2);
row.Cells.Add(cell);
}
}
