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("保存出错。");
}
}
