public DataTable GetDataByPage(PageModel pmodel)
{
StringBuilder strSql = new StringBuilder();
if (string.IsNullOrEmpty(pmodel.fieldname))
{
pmodel.fieldname = "*";
}
//SQL数据库语句
string ptopsql = "select top " + (pmodel.page - 1) * pmodel.pagesize + " " + pmodel.keycol + " from \"" + pmodel.tablename + "\" ";
strSql.Append("select top " + pmodel.pagesize +
" " + pmodel.fieldname + " from \"" + pmodel.tablename + "\" where 1=1");
if (!pmodel.wherestr.Equals(""))
{
strSql.Append(" and " + pmodel.wherestr);
ptopsql += " where " + pmodel.wherestr;
}
if (!pmodel.orderby.Equals(""))
{
ptopsql += " order by " + pmodel.orderby;
strSql.Append(" and " + pmodel.keycol + " not in (" + ptopsql + ") order by " + pmodel.orderby);
}
else
{
strSql.Append(" and " + pmodel.keycol + " not in (" + ptopsql + ")");
}
return SqlHelper.Query(strSql.ToString()).Tables[0];
}
public int GetPageCount(PageModel pmodel)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count (*) as total from \"" + pmodel.tablename + "\" where 1=1");
if (!pmodel.wherestr.Equals(""))
{
strSql.Append(" and " + pmodel.wherestr);
}
return int.Parse(SqlHelper.ExecuteScalar(strSql.ToString()).ToString());
}
public DataTable GetChildAreaList(int pageIndex, int pageSize, int parentid)
{
try
{
PageModel pmodel = new PageModel();
pmodel.tablename = "becm_layerobject";
pmodel.keycol = "layerobjectid";
pmodel.page = pageIndex;
pmodel.pagesize = pageSize;
pmodel.wherestr = " layerobjectparentid=" + parentid;
pmodel.orderby = pmodel.keycol;
return page.GetDataByPage(pmodel);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private PageModel InitPageModel(WarningAnalysisModel model)
{
WarningTypeModel wt = wt_List.Find(s => s.Value == model.SelectTypeId);
if (wt == null)
{
throw new Exception("报警类型xml配置有误");
}
if (string.IsNullOrEmpty(wt.CValue) || string.IsNullOrEmpty(wt.keycol))
{
throw new Exception(wt.Text + "缺少数据库参数信息");
}
PageModel pmodel = new PageModel();
DateTime starttime = model.StartDate;
DateTime endtime = model.EndDate.AddDays(1);
pmodel.tablename = wt.CValue;
pmodel.keycol = wt.keycol;
pmodel.page = model.PageCurrent;
pmodel.pagesize = model.PageSize;
pmodel.wherestr = " DATETIME >= '" + starttime.ToShortDateString() + "' and DATETIME < '" + endtime.ToShortDateString() + "'";
pmodel.wherestr += string.Format(@" and devicename in (select cname from tb_device where devarea in (SELECT a.id
FROM tb_area a,f_Cid({0}) b
WHERE a.id=b.ID ))", model.BuildId);
pmodel.orderby = wt.keycol;
return pmodel;
}
private PageModel InitPageModel(int pageIndex, int pageSize, string startTime, string endTime, string warningTypeId, int areaId)
{
WarningTypeModel wt = wt_List.Find(s => s.Value == warningTypeId);
if (wt == null)
{
throw new Exception("报警类型xml配置有误");
}
if (string.IsNullOrEmpty(wt.CValue) || string.IsNullOrEmpty(wt.keycol))
{
throw new Exception(wt.Text + "缺少数据库参数信息");
}
PageModel pmodel = new PageModel();
DateTime starttime = Convert.ToDateTime(startTime);
DateTime endtime = Convert.ToDateTime(endTime).AddDays(1);
pmodel.tablename = wt.CValue;
pmodel.keycol = wt.keycol;
pmodel.page = pageIndex;
pmodel.pagesize = pageSize;
pmodel.wherestr = " DATETIME >= '" + starttime.ToShortDateString() + "' and DATETIME < '" + endtime.ToShortDateString() + "'";
pmodel.wherestr += string.Format(@" and devicename in (select cname from tb_device where devarea in (SELECT a.id
FROM tb_area a,f_Cid({0}) b
WHERE a.id=b.ID ))", areaId);
pmodel.orderby = wt.keycol;
return pmodel;
}
