public string SaveAlert(DEF_ALERTEntity DefineSave)
{
var v = GetVerify(DefineSave);
v.Require(a => a.MC);
v.Require(a => a.SQLSTR);
var b = false;
b = VerifySql(DefineSave.SQLSTR);
if (b == false)
{
throw new LogicException("SQL语句不正确!");
}
;
v.IsUnique(a => a.MC);
v.Verify();
if (DefineSave.ID.IsEmpty())
{
DefineSave.ID = CommonService.NewINC("DEF_ALERT");
}
DbHelper.Save(DefineSave);
return(DefineSave.ID);
}
public void Delete(DEF_ALERTEntity DefineDelete)
{
var v = GetVerify(DefineDelete);
v.Require(a => a.ID);
v.Verify();
CommenDelete(DefineDelete);
}
public UIResult SearchAlert(DEF_ALERTEntity Data)
{
var res = service.XtglService.GetAlertElement(Data);
return(new UIResult(
new
{
defalert = res.Item1,
item = res.Item2
}
));
}
public UIResult SearchAlert(DEF_ALERTEntity Data)
{
//返回预警的列表给col,返回预警的结果给data
var res = service.XtglService.GetAlertSql(Data);
return(new UIResult(
new
{
alertData = res.Item1,
alertCol = res.Item2
}
));
}
public Tuple <DataTable, DataTable> GetAlertSql(DEF_ALERTEntity Data)
{
DEF_ALERTEntity alert = new DEF_ALERTEntity();
alert = DbHelper.Select(new DEF_ALERTEntity()
{
ID = Data.ID
});
DataTable alertSql = DbHelper.ExecuteTable(alert.SQLSTR);
string sqlItem = $@"select FIELDMC,CHINAMC,WIDTH from ALERT_FIELD where 1=1";
if (!Data.ID.IsEmpty())
{
sqlItem += " and ID = " + Data.ID;
}
DataTable alertCol = DbHelper.ExecuteTable(sqlItem);
return(new Tuple <DataTable, DataTable>(alertSql, alertCol));
}
public Tuple <dynamic, DataTable> GetAlertElement(DEF_ALERTEntity Data)
{
string sql = $@"select ID,MC,XSSX,SQLSTR FROM DEF_ALERT where 1=1";
if (!Data.ID.IsEmpty())
{
sql += " and ID = " + Data.ID;
}
DataTable defalert = DbHelper.ExecuteTable(sql);
string sqlItem = $@"select FIELDMC,CHINAMC,WIDTH from ALERT_FIELD where 1=1";
if (!Data.ID.IsEmpty())
{
sqlItem += " and ID = " + Data.ID;
}
DataTable defalertItem = DbHelper.ExecuteTable(sqlItem);
return(new Tuple <dynamic, DataTable>(defalert.ToOneLine(), defalertItem));
}
public string Save(DEF_ALERTEntity DefineSave)
{
return(service.XtglService.SaveAlert(DefineSave));
}
