/// <summary>
/// 绑定Grid表格，并实现分页
/// </summary>
/// <param name="grid">表格控件</param>
/// <param name="pageIndex">第几页</param>
/// <param name="pageSize">每页显示记录数量</param>
/// <param name="wheres">查询条件</param>
/// <param name="sorts">排序</param>
public override void BindGrid(FineUI.Grid grid, int pageIndex = 0, int pageSize = 0, List<ConditionHelper.SqlqueryCondition> wheres = null, List<string> sorts = null)
{
//用于统计执行时长(耗时)
var swatch = new Stopwatch();
swatch.Start();
try {
// 1.设置总项数
grid.RecordCount = GetRecordCount(wheres);
// 2.如果不存在记录，则清空Grid表格
if (grid.RecordCount == 0) {
grid.Rows.Clear();
// 查询并绑定到Grid
grid.DataBind();
grid.AllowPaging = false;
}
else
{
//3.查询并绑定到Grid
grid.DataSource = GetDataTable(false, 0, null, pageIndex, pageSize, wheres, sorts);
grid.DataBind();
}
}
catch (Exception e) {
// 记录日志
CommonBll.WriteLog("获取用户操作日志表记录时出现异常", e);
}
// 统计结束
swatch.Stop();
// 计算查询数据库使用时间，并存储到Session里，以便UI显示
HttpContext.Current.Session["SpendingTime"] = (swatch.ElapsedMilliseconds / 1000.00).ToString();
}
/// <summary>
/// 绑定菜单下拉列表——只显示所有可以显示的菜单（IsMenu)
/// </summary>
public void BandDropDownListShowMenu(Page page, FineUI.DropDownList ddl)
{
//在内存中筛选记录
var dt = DataTableHelper.GetFilterData(GetDataTable(), string.Format("{0}={1}", MenuInfoTable.IsMenu, 0), MenuInfoTable.Depth + ", " + MenuInfoTable.Sort);
try
{
//整理出有层次感的数据
dt = DataTableHelper.DataTableTidyUp(dt, MenuInfoTable.Id, MenuInfoTable.ParentId, 0);
ddl.EnableSimulateTree = true;
//显示值
ddl.DataTextField = MenuInfoTable.Name;
//显示key
ddl.DataValueField = MenuInfoTable.Id;
//数据层次
ddl.DataSimulateTreeLevelField = MenuInfoTable.Depth;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("请选择菜单", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定下拉列表
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
//显示值
ddl.DataTextField = UploadTypeTable.Name;
//显示key
ddl.DataValueField = UploadTypeTable.Id;
//绑定数据源
ddl.DataSource = GetDataTable();
ddl.DataBind();
ddl.Items.Insert(0, new FineUI.ListItem("请选择上传类型", "0"));
ddl.SelectedValue = "0";
}
/// <summary>
/// 绑定菜单下拉列表——只显示一级菜单
/// </summary>
public void BandDropDownList(Page page, FineUI.DropDownList ddl)
{
var dt = DataTableHelper.GetFilterData(GetDataTable(), MenuInfoTable.ParentId, "0", MenuInfoTable.Sort, "desc");
//显示值
ddl.DataTextField = MenuInfoTable.Name;
//显示key
ddl.DataValueField = MenuInfoTable.Id;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.Items.Insert(0, new FineUI.ListItem("请选择菜单", "0"));
ddl.SelectedValue = "0";
}
/// <summary>
/// 绑定广告位置下拉列表——显示所有
/// </summary>
public void BandDropDownListShowAll(Page page, FineUI.DropDownList ddl)
{
//设置排序
var sortList = new List<string>();
sortList.Add(AdvertisingPositionTable.Depth);
sortList.Add(AdvertisingPositionTable.Sort);
//筛选记录
var dt = GetDataTable(false, 0, null, 0, 0, null, sortList);
try
{
//整理出有层次感的数据
dt = DataTableHelper.DataTableTidyUp(dt, AdvertisingPositionTable.Id, AdvertisingPositionTable.ParentId, 0);
ddl.EnableSimulateTree = true;
//显示值
ddl.DataTextField = AdvertisingPositionTable.Name;
//绑定Id
ddl.DataValueField = AdvertisingPositionTable.Id;
//数据层次
ddl.DataSimulateTreeLevelField = AdvertisingPositionTable.Depth;
//绑定数据源
ddl.DataSource = dt;
ddl.DataBind();
ddl.SelectedIndex = 0;
ddl.Items.Insert(0, new FineUI.ListItem("请选择广告位置", "0"));
ddl.SelectedValue = "0";
}
catch (Exception e)
{
// 记录日志
CommonBll.WriteLog("", e);
}
}
/// <summary>
/// 绑定Grid表格，使用内存分页，显示有层次感
/// </summary>
/// <param name="grid">表格控件</param>
/// <param name="parentValue">父Id值</param>
/// <param name="wheres">查询条件</param>
/// <param name="sorts">排序</param>
/// <param name="parentId">父Id</param>
public override void BindGrid(FineUI.Grid grid, int parentValue, List<ConditionHelper.SqlqueryCondition> wheres = null, List<string> sorts = null, string parentId = "ParentId")
{
//用于统计执行时长(耗时)
var swatch = new Stopwatch();
swatch.Start();
try
{
// 查询数据库
var dt = GetDataTable(false, 0, null, 0, 0, wheres, sorts);
// 1.设置总项数
grid.RecordCount = dt == null ? 0 : dt.Rows.Count;
// 2.如果不存在记录，则清空Grid表格
if (grid.RecordCount == 0)
{
grid.Rows.Clear();
// 查询并绑定到Grid
grid.DataBind();
grid.AllowPaging = false;
}
else
{
// 对查询出来的记录进行层次处理
grid.DataSource = DataTableHelper.DataTableTidyUp(dt, "Id", parentId, parentValue);
// 查询并绑定到Grid
grid.DataBind();
grid.AllowPaging = true;
}
}
catch (Exception e) {
// 记录日志
CommonBll.WriteLog("绑定表格时出现异常", e);
}
//统计结束
swatch.Stop();
//计算查询数据库使用时间，并存储到Session里，以便UI显示
HttpContext.Current.Session["SpendingTime"] = (swatch.ElapsedMilliseconds / 1000.00).ToString();
}
