public override void Del(PointCfg bean) { Log.Debug("Del方法参数:" + bean.ToString()); try { Oop.BeginTransaction(); Oop.Execute("delete from gat_pointcfg gp where gp.id={0}", bean.Id); Oop.Execute("delete from gat_warn gw where gw.pointid={0}", bean.Id); Oop.Submit(true); } catch (Exception e) { Oop.Rollback(true); Log.Error("Del出错:" + e); throw new Exception("删除数据出错,请稍后再试。"); } }
public override void Modify(PointCfg bean) { Log.Debug("Modify方法参数:" + bean.ToString()); var sql1 = new StringBuilder("update GAT_POINTCFG set "); var i = -1; var list = new List <object>(); var pointId = bean.Id; if (bean.LimitMin != null) { sql1.Append(" limitmin={" + ++i + "},"); list.Add(bean.LimitMin); } if (bean.LimitMax != null) { sql1.Append(" limitmax={" + ++i + "},"); list.Add(bean.LimitMax); } if (bean.IsOverLimtWarn != null) { sql1.Append(" IsOverLimtWarn={" + ++i + "},"); list.Add(bean.IsOverLimtWarn); } if (bean.Eff_Min != null) { sql1.Append(" Eff_Min={" + ++i + "},"); list.Add(bean.Eff_Min); } if (bean.Eff_Max != null) { sql1.Append(" Eff_Max={" + ++i + "},"); list.Add(bean.Eff_Max); } if (bean.IsOverEffWarn != null) { sql1.Append(" IsOverEffWarn={" + ++i + "},"); list.Add(bean.IsOverEffWarn); } if (bean.IsAutoCleanWarn != null) { sql1.Append(" IsAutoCleanWarn={" + ++i + "},"); list.Add(bean.IsAutoCleanWarn); } if (bean.CleanWarnRule != null) { sql1.Append(" CleanWarnRule={" + ++i + "},"); list.Add(bean.CleanWarnRule); } if (!string.IsNullOrEmpty(bean.YxStates)) { sql1.Append(" YxStates={" + ++i + "},"); list.Add(bean.YxStates); } if (!string.IsNullOrEmpty(bean.YxEff)) { sql1.Append(" YxEff={" + ++i + "},"); list.Add(bean.YxEff); } if (!string.IsNullOrEmpty(bean.YxWarn)) { sql1.Append(" YxWarn={" + ++i + "},"); list.Add(bean.YxWarn); } sql1.Append(" IsUse={" + ++i + "},"); list.Add(bean.IsUse); var sql = sql1.ToString() + " updatedt=sysdate where id={" + ++i + "}"; list.Add(bean.Id); if (list.Count <= 1) { return; } var j = -1; string sqlWarn1 = "", sqlWarn2 = "", sqlWarn3 = ""; var listWarn1 = new List <object>(); var listWarn2 = new List <object>(); var listWarn3 = new List <object>(); DataTable dtWarn = Oop.GetDataTable("select warntype from gat_warn where pointid={0}", pointId); if (dtWarn != null && dtWarn.Rows.Count > 0) { foreach (DataRow row in dtWarn.Rows) { j = -1; if (!"snd".Equals(row["warntype"].ToString().ToLower())) { continue; } if ("snd".Equals(row["warntype"].ToString().ToLower()) && !string.IsNullOrEmpty(bean.Sy)) { string sqlF = ""; if (null != bean.SndFileContext) { sqlF = " sndfilecontext={" + ++j + "}, "; listWarn3.Add(pointId); } sqlWarn3 = "update gat_warn set " + sqlF + " sndfiletype={" + ++j + "},updatedt=sysdate where pointid={" + ++j + "} and warntype='Wav'"; listWarn3.AddRange(new object[] { bean.SndFileType, pointId }); } else { sqlWarn3 = "delete from gat_warn where pointid={" + ++j + "} and warntype='Wav'"; listWarn3.Add(pointId); } } } j = -1; if (!string.IsNullOrEmpty(bean.Sy) && sqlWarn3.Length == 0) { sqlWarn3 = "insert into gat_warn(id,warntype,pointid,sndfilecontext,sndfiletype,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn3.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Sy, pointId, bean.SndFileContext, bean.SndFileType }); } j = -1; if (!string.IsNullOrEmpty(bean.Dx)) { sqlWarn1 = "insert into gat_warn (id,warntype,warntarget,warncontext,pointid,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn1.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Dx, bean.Sjh, bean.Dxmb, pointId }); } j = -1; if (!string.IsNullOrEmpty(bean.Yj)) { sqlWarn2 = "insert into gat_warn(id,warntype,warntarget,warncontext,pointid,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn2.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Yj, bean.Yxdz, bean.Yjmb, pointId }); } try { Oop.BeginTransaction(); Oop.Execute(sql, list.ToArray()); Oop.Execute("delete from gat_warn where pointid={0} and warntype != 'Wav'", pointId); if (!string.IsNullOrEmpty(bean.Dx)) { Oop.Execute(sqlWarn1, listWarn1.ToArray()); } if (!string.IsNullOrEmpty(bean.Yj)) { Oop.Execute(sqlWarn2, listWarn2.ToArray()); } if (!string.IsNullOrEmpty(bean.Sy)) { Oop.Execute(sqlWarn3, listWarn3.ToArray()); } Oop.Submit(true); } catch (Exception e) { Oop.Rollback(true); Log.Error("Modify方法出错:" + e); throw new Exception("修改出错。"); } }
public override void Add(PointCfg bean) { Log.Debug("Add方法参数:" + bean.ToString()); var sql1 = new StringBuilder(); var sql2 = new StringBuilder(); var i = -1; var list = new List <object>(); sql1.Append(" id,"); sql2.Append(" {" + ++i + "},"); var pointId = Guid.NewGuid().ToString(); list.Add(pointId); if (!string.IsNullOrEmpty(bean.ZhuangLeiX)) { sql1.Append(" PILETYPEID,"); sql2.Append(" (select t.parserkey from dev_powerpiletypes t where t.zhuanglei_x={" + ++i + "}),"); list.Add(bean.ZhuangLeiX); } if (!string.IsNullOrEmpty(bean.GatItemId)) { sql1.Append(" gatitemid,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.GatItemId); } if (bean.LimitMin != null) { sql1.Append(" limitmin,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.LimitMin); } if (bean.LimitMax != null) { sql1.Append(" limitmax,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.LimitMax); } if (bean.IsOverLimtWarn != null) { sql1.Append(" IsOverLimtWarn,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.IsOverLimtWarn); } if (bean.Eff_Min != null) { sql1.Append(" Eff_Min,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.Eff_Min); } if (bean.Eff_Max != null) { sql1.Append(" Eff_Max,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.Eff_Max); } if (bean.IsOverEffWarn != null) { sql1.Append(" IsOverEffWarn,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.IsOverEffWarn); } if (bean.IsAutoCleanWarn != null) { sql1.Append(" IsAutoCleanWarn,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.IsAutoCleanWarn); } if (bean.CleanWarnRule != null) { sql1.Append(" CleanWarnRule,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.CleanWarnRule); } if (!string.IsNullOrEmpty(bean.YxStates)) { sql1.Append(" YxStates,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.YxStates); } if (!string.IsNullOrEmpty(bean.YxEff)) { sql1.Append(" YxEff,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.YxEff); } if (!string.IsNullOrEmpty(bean.YxWarn)) { sql1.Append(" YxWarn,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.YxWarn); } sql1.Append(" IsUse,"); sql2.Append(" {" + ++i + "},"); list.Add(bean.IsUse); if (sql1.Length > 0) { sql1 = sql1.Remove(sql1.Length - 1, 1); sql2 = sql2.Remove(sql2.Length - 1, 1); } var sql = "insert into GAT_POINTCFG(" + sql1.ToString() + ",createdt) values(" + sql2.ToString() + ",sysdate)"; var j = -1; string sqlWarn1 = "", sqlWarn2 = "", sqlWarn3 = ""; var listWarn1 = new List <object>(); var listWarn2 = new List <object>(); var listWarn3 = new List <object>(); if (!string.IsNullOrEmpty(bean.Dx)) { sqlWarn1 = "insert into gat_warn (id,warntype,warntarget,warncontext,pointid,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn1.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Dx, bean.Sjh, bean.Dxmb, pointId }); } j = -1; if (!string.IsNullOrEmpty(bean.Yj)) { sqlWarn2 = "insert into gat_warn(id,warntype,warntarget,warncontext,pointid,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn2.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Yj, bean.Yxdz, bean.Yjmb, pointId }); } j = -1; if (!string.IsNullOrEmpty(bean.Sy)) { sqlWarn3 = "insert into gat_warn(id,warntype,pointid,sndfilecontext,sndfiletype,createdt) values({" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},{" + ++j + "},sysdate)"; listWarn3.AddRange(new object[] { Guid.NewGuid().ToString(), bean.Sy, pointId, bean.SndFileContext, bean.SndFileType }); } try { Oop.BeginTransaction(); Oop.Execute(sql, list.ToArray()); if (!string.IsNullOrEmpty(bean.Dx)) { Oop.Execute(sqlWarn1, listWarn1.ToArray()); } if (!string.IsNullOrEmpty(bean.Yj)) { Oop.Execute(sqlWarn2, listWarn2.ToArray()); } if (!string.IsNullOrEmpty(bean.Sy)) { Oop.Execute(sqlWarn3, listWarn3.ToArray()); } Oop.Submit(true); } catch (Exception e) { Oop.Rollback(true); Log.Error("Add 方法出错:" + e); throw new Exception("保存出错。"); } }