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