public void PageBind2()
{
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Index";
pb.FldName = "id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
int count = 0;
pb.DoCount = 1;
if (where.Length > 0)
{
if (TextBox1.Text.Trim() != "")
{
key += " and Title like '%" + TextBox1.Text + "%'";
}
}
else
{
if (TextBox1.Text.Trim() != "")
{
key += " Title like '%" + TextBox1.Text + "%'";
}
else
{
key += " 1=1";
}
}
//if (TextBox1.Text.Trim()!="")
// key += " and Title like ''%" + TextBox1.Text + "%''";
//else
// key += " 1=1";
//if (where.Length > 0)
//{
// key += " and Title like ''%" + TextBox1.Text + "%''";
// //and typeid not in (1,2,4,9,19,84,85,86,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103) ";
//}
//else
//{
// key += " 1=1 and Title like ''%" + TextBox1.Text + "%'' ";
// //and typeid not in (1,2,4,9,19,84,85,86,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103) ";
//}
where += key + " and del=0 and IsDel=0";
if (tm.GetModel(ul.LoginID).m_bum == 131)
{
pb.StrWhere = where + " and (bum_bz=" + tm.GetModel(ul.LoginID).m_bum + " or bum_bz=0)";
}
else if (tm.GetModel(ul.LoginID).m_bum == 134)
{
pb.StrWhere = where + " and (bum_bz=" + tm.GetModel(ul.LoginID).m_bum + " or bum_bz=0 or bum_bz=132)";
}
else if (ul.JiaoSe(ul.LoginID) != "系统管理员")
{
pb.StrWhere = where + " and bum_bz=" + tm.GetModel(ul.LoginID).m_bum;
}
else
{
pb.StrWhere = where;
}
mbll.GetList(pb, ref count); //获取总条数
pb.DoCount = 0;
List <Tunnel.Model.Tunnel_index> modelList = new List <Tunnel.Model.Tunnel_index>();
modelList = mbll.GetList3(pb, ref count);//获取分页结果
//数据绑定
Repeater1.DataSource = modelList;
Repeater1.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}
public void PageBind2()
{
string parentID = null == Request.QueryString["parentID"] ? "" : Request.QueryString["parentID"].ToString().Trim();
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Index";
pb.FldName = "id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
int count = 0;
pb.DoCount = 1;
if (where.Length > 0)
{
key += " and Title like '%" + TextBox1.Text + "%' ";
}
else
{
key += " 1=1 and Title like '%" + TextBox1.Text + "%' ";
}
where += key + " and del=0";
if (parentID != "")
{
where = where + " and typeId=" + parentID;
}
else
{
where = where + " and typeId in (47,48,49)";
}
if (ul.LoginID != 1 && ul.JiaoSe(ul.LoginID) != "系统管理员")
{
pb.StrWhere = where + " and userid=" + ul.LoginID;
}
else
{
pb.StrWhere = where;
}
mbll.GetList(pb, ref count); //获取总条数
pb.DoCount = 0;
List <Tunnel.Model.Tunnel_index> modelList = new List <Tunnel.Model.Tunnel_index>();
modelList = mbll.GetList3(pb, ref count);//获取分页结果
//数据绑定
Repeater1.DataSource = modelList;
Repeater1.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}
public void PageBind2()
{
string type = null == Request.QueryString["type"] ? "" : Request.QueryString["type"].ToString().Trim();
//switch (Request.QueryString["type"].ToString())
//{
// case "1":
// type = "84,89";
// break;
// case "2":
// type = "85,90";
// break;
// case "3":
// type = "86,91";
// break;
//}
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Index";
pb.FldName = "id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
int count = 0;
pb.DoCount = 1;
key += " 1=1 and Title like '%" + TextBox1.Text + "%' and typeid in (" + type + ")";
if (ul.LoginID != 1 && ul.JiaoSe(ul.LoginID) != "系统管理员")
{
pb.StrWhere = key + " and userid=" + ul.LoginID + " and del=0";
}
else
{
pb.StrWhere = key + " and del=0";
}
mbll.GetList(pb, ref count); //获取总条数
pb.DoCount = 0;
List <Tunnel.Model.Tunnel_index> modelList = new List <Tunnel.Model.Tunnel_index>();
modelList = mbll.GetList3(pb, ref count);//获取分页结果
//数据绑定
Repeater1.DataSource = modelList;
Repeater1.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}
public void PageBind2()
{
PageBase pb = new PageBase();
pb.TblName = "Tunnel_Index";
pb.FldName = "id";
pb.ProcedureName = "pagination";
pb.PageSize = pageSize;
if (cuttentPage == 0)
{
cuttentPage = pb.PageIndex;
}
pb.PageIndex = cuttentPage;
int count = 0;
pb.DoCount = 1;
string where = " typeid =" + Convert.ToInt32(Request.QueryString["typeId"]);
string key = "";
if (where.Length > 0)
{
key += " and Title like '%" + TextBox1.Text + "%'";
}
else
{
key += " 1=1 and Title like '%" + TextBox1.Text + "%'";
}
where += key;
pb.StrWhere = where + " and del=0 AND IsDel=0";
List <Tunnel.Model.Tunnel_index> modelList = new List <Tunnel.Model.Tunnel_index>();
List <Tunnel.Model.Tunnel_index> modelLists = new List <Tunnel.Model.Tunnel_index>();
mbll.GetList3(pb, ref count);; //获取分页结果
pb.DoCount = 0;
if (pageSize == count)
{
cuttentPage = cuttentPage - 1;
pb.PageIndex = cuttentPage;
}
modelList = mbll.GetList3(pb, ref count);
//for (int i = 0; i < modelList.Count; i++)
//{
// Tunnel.Model.Tunnel_index mode = (Tunnel.Model.Tunnel_index)(modelList[i]);
// if (m_UserLogin.LoginID.ToString().Trim() == mode.UserId.ToString().Trim())
// {
// modelLists.Add(mode);
// continue;
// }
// if (null != mode.ReadUser && mode.ReadUser != "")
// {
// string[] str = mode.ReadUser.ToString().Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
// for (int j = 0; j < str.Length; j++)
// {
// if (m_UserLogin.LoginID.ToString().Trim() == str[j])
// {
// modelLists.Add(mode);
// break;
// }
// }
// }
//}
//数据绑定
Repeater2.DataSource = modelList;
Repeater2.DataBind();
//数据分页
MTCPager1.PageSize = pageSize;
MTCPager1.RecordCount = count;
MTCPager1.PageIndex = cuttentPage;
if (count <= pb.PageSize)
{
MTCPager1.Visible = false;
}
else
{
MTCPager1.Visible = true;
}
}
