/// <summary>
/// 获取异常告警
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string FindByTelesignallingWarn2(HttpContext context)
{
string ret = null;
var message = new JsonMessage <TelesignallingWarn>();
var warnrecbll = new WarnRecBll();
var telesignallingParam = new TelesignallingParam();
var zhanbh = context.Request.Params["zhanbh"];
var warnType = context.Request.Params["warnType"];
var yunXinbh = context.Request.Params["yunXinbh"];
var kssj = context.Request.Params["kssj"];
var jssj = context.Request.Params["jssj"];
var clfs = context.Request.Params["clfs"];
telesignallingParam.Zhanbh = zhanbh;
telesignallingParam.WarnType = warnType;
telesignallingParam.ZhanYxBh = yunXinbh;
telesignallingParam.Kssj = kssj;
telesignallingParam.Jssj = jssj;
telesignallingParam.Clfs = clfs;
try
{
var page = context.Request.Params["page"];
var rows = context.Request.Params["rows"];
var pageIndex = 0;
var size = 0;
var count = 0;
if (!string.IsNullOrEmpty(page))
{
pageIndex = int.Parse(page);
}
if (!string.IsNullOrEmpty(rows))
{
size = int.Parse(rows);
}
//保存工号
var worknum = ((Employer)(context.Session[Constant.LoginUser])).WorkNum;
var dt = warnrecbll.FindByTelesignallingWarn(telesignallingParam, pageIndex, size, ref count);
var list = ConvertHelper <TelesignallingWarn> .ConvertToList(dt);
foreach (var li in list)
{
li.WorkNum = worknum;
}
message.Rows = list;
message.Total = count;
ret = _jss.Serialize(message);
ret = ret.Replace("Total", "total");
ret = ret.Replace("Rows", "rows");
}
catch (Exception e)
{
Log.Error(e);
}
message.Status = 0;
message.Msg = "发生异常";
return(ret);
}
/// <summary>
/// 查询异常告警
/// </summary>
/// <returns></returns>
public DataTable FindByTelesignallingWarn(TelesignallingParam telesignallingParam, int page, int rows, ref int count)
{
Log.Debug("FindByTelesignallingWarn方法没有参数");
var sql = new StringBuilder();
var sqlWhere = new StringBuilder();
var sqlCount = new StringBuilder("select count(*) from oth_warnrec owr inner join dev_chargpile dcp2 on dcp2.dev_chargpile=owr.targetdev ");
var getpage = new GetPage();
sql.Append("select owr.id,owr.targetdev,owr.dataitemid, ");
sql.Append("(select sc.codename from sys_code sc where sc.parentid='5077B15C-4F5E-49B2-9E32-E7C1E2F1E74D' and owr.logtype=sc.code) codename, ");
sql.Append("to_char(owr.occurdt,'yyyy-mm-dd hh24:mi:ss') occurdt,");
sql.Append("(select dcs.zhan_jc from dev_chargstation dcs ");
sql.Append("inner join dev_branch db on db.zhuan_bh=dcs.zhan_bh ");
sql.Append("inner join dev_chargpile dcp on dcp.box_id=db.branchno ");
sql.Append("where dcp.dev_chargpile=owr.targetdev) zhanjc,");
sql.Append("(select dcp.yunxing_bh from dev_chargpile dcp where dcp.dev_chargpile=owr.targetdev) yunxing_bh,");
sql.Append("(select gi.Itemname from gat_item gi where gi.itemno=owr.dataitemid) itemname, ");
sql.Append("owr.logdesc,owr.processflag ");
sql.Append("from oth_warnrec owr ");
sql.Append("inner join dev_chargpile dcp2 on dcp2.dev_chargpile=owr.targetdev ");
sqlWhere.Append("where owr.dataitemid!='CardExceptionState' and owr.dataitemid!='DTUStatus' and owr.dataitemid!='PowerStopState' ");
if (!string.IsNullOrEmpty(telesignallingParam.WarnType))
{
sqlWhere.Append("and owr.logtype='" + telesignallingParam.WarnType + "' ");
}
if (!string.IsNullOrEmpty(telesignallingParam.Zhanbh))
{
sqlWhere.Append("and owr.targetdev like '" + telesignallingParam.Zhanbh + "%' ");
}
if (!string.IsNullOrEmpty(telesignallingParam.ZhanYxBh))
{
sqlWhere.Append("and dcp2.yunxing_bh='" + telesignallingParam.ZhanYxBh + "' ");
}
if (!string.IsNullOrEmpty(telesignallingParam.Kssj) && !string.IsNullOrEmpty(telesignallingParam.Jssj))
{
sqlWhere.Append("and owr.occurdt between to_date('" + telesignallingParam.Kssj + "','yyyy-mm-dd') and to_date('" + telesignallingParam.Jssj + "','yyyy-mm-dd')+1 ");
}
if (!string.IsNullOrEmpty(telesignallingParam.Clfs))
{
sqlWhere.Append("and owr.processflag='" + telesignallingParam.Clfs + "' ");
}
sqlWhere.Append("order by owr.occurdt desc");
count = int.Parse(Oop.GetScalar(sqlCount.Append(sqlWhere).ToString()).ToString());
return(Oop.GetDataTableByPage(sql.Append(sqlWhere).ToString(), (page - 1) * rows, rows));
}
/// <summary>
/// 查询异常告警
/// </summary>
/// <returns></returns>
public DataTable FindByTelesignallingWarn(TelesignallingParam telesignallingParam, int page, int rows, ref int count)
{
return(_warnRecDal.FindByTelesignallingWarn(telesignallingParam, page, rows, ref count));
}
