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; }