/// <summary>
/// 修改告警信息
/// </summary>
/// <param name="bean"></param>
public void EditBy(WarnRec bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder("update oth_warnrec set");
var i = 0;
var dList = new List <object>();
if (bean.ProcessFlag != null)
{
sql.Append(" processflag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.ProcessDt != null)
{
sql.Append(" ProcessDt={" + i++ + "},");
dList.Add(bean.ProcessDt);
}
if (bean.ProcesseEp != null)
{
sql.Append(" processeep={" + i++ + "},");
dList.Add(bean.ProcesseEp);
}
sql.Append(" updatedt=sysdate where DATAITEMID={" + i++ + "} and TARGETDEV={" + i + "}");
dList.Add(bean.DataItemId);
dList.Add(bean.TargetDev);
Log.Debug("SQL:" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
public override void Add(UseRoles bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (!string.IsNullOrEmpty(bean.RoleId))
{
sql1.Append(" RoleId,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.RoleId);
}
if (!string.IsNullOrEmpty(bean.LoginName))
{
sql1.Append(" LoginName,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.LoginName);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into sm_useroles(" + sql1 + ") values(" + sql2 + ")";
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
Oop.Execute(sql, list.ToArray());
}
public override void Modify(WarnRec bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder("update oth_warnrec set");
var i = 0;
var dList = new List <object>();
if (bean.ProcessFlag != null)
{
sql.Append(" processflag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.ProcessDt != null)
{
sql.Append(" ProcessDt={" + i++ + "},");
dList.Add(bean.ProcessDt);
}
if (bean.ProcesseEp != null)
{
sql.Append(" processeep={" + i++ + "},");
dList.Add(bean.ProcesseEp);
}
sql.Append(" updatedt=sysdate where id={" + i++ + "}");
dList.Add(bean.Id);
Log.Debug("SQL:" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
public override void Modify(Employer employer)
{
Log.Debug("更新人员");
var sql = "update t_employer set password='******' where WorkNum='" + employer.WorkNum + "'";
Oop.Execute(sql);
}
/// <summary>
/// 根据桩id删除充电桩
/// </summary>
/// <param name="chargpile"></param>
public void EditChargPile(ChargPile chargpile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update dev_chargpile set ");
strSql.Append(" BOX_ID={0},DTU_ID={1},PILETYPEID={2},ZONGXIAN_DZ={3},CHANGJIAO_BH={4},YUNXING_BH={5},TOUYOU_SJ={6},ZHUANGTAI={7},ZHICHAN_BH={8},YUNWEI_DW={9},DELETEFLAG={10},CREATEDT={11},UPDATEDT={12} ");
strSql.Append(" where dev_chargpile={13} ");
object[] parameters = new object[] {
chargpile.BOX_ID,
chargpile.DTU_ID,
chargpile.PILETYPEID,
chargpile.ZONGXIAN_DZ,
chargpile.CHANGJIAO_BH,
chargpile.YUNXING_BH,
chargpile.TOUYOU_SJ,
chargpile.ZHUANGTAI,
chargpile.ZHICHAN_BH,
chargpile.YUNWEI_DW,
chargpile.DELETEFLAG,
chargpile.CREATEDT,
chargpile.UPDATEDT,
chargpile.DEV_CHARGPILE
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("修改充电桩失败！", e);
}
}
public override void Modify(MenuPower bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update t_menu_power set");
var i = 0;
var dList = new List <object>();
if (string.IsNullOrEmpty(bean.MenuId))
{
sql.Append(" MenuId={" + i++ + "}");
dList.Add(bean.MenuId);
}
if (string.IsNullOrEmpty(bean.PowerId))
{
sql.Append(" PowerId={" + i++ + "}");
dList.Add(bean.PowerId);
}
sql.Append(" where Id={" + i + "}");
dList.Add(bean.Id);
Log.Debug("SQL :" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="chargpile"></param>
public void AddChargPile(ChargPile chargpile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into dev_chargpile(DEV_CHARGPILE,BOX_ID,DTU_ID,PILETYPEID,ZONGXIAN_DZ,CHANGJIAO_BH,YUNXING_BH,TOUYOU_SJ,ZHUANGTAI,ZHICHAN_BH,YUNWEI_DW,DELETEFLAG,CREATEDT,UPDATEDT,POWERPILENAME) values ");
strSql.Append(" ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14})");
object[] parameters = new object[] {
chargpile.DEV_CHARGPILE,
chargpile.BOX_ID,
chargpile.DTU_ID,
chargpile.PILETYPEID,
chargpile.ZONGXIAN_DZ,
chargpile.CHANGJIAO_BH,
chargpile.YUNXING_BH,
chargpile.TOUYOU_SJ,
chargpile.ZHUANGTAI,
chargpile.ZHICHAN_BH,
chargpile.YUNWEI_DW,
chargpile.DELETEFLAG,
chargpile.CREATEDT,
chargpile.UPDATEDT,
chargpile.POWERPILENAME
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("添加充电桩失败！", e);
}
}
public override void Del(ResMenu bean)
{
Log.Debug("del方法参数：");
var sql = "delete from sm_resmenu where ResId='" + bean.ResId + "'";
Oop.Execute(sql);
}
public override void Modify(WarnDetail bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update gat_warndetail set");
var i = 0;
var dList = new List <object>();
if (bean.IsSuccess != null)
{
sql.Append(" IsSuccess={" + i++ + "},");
dList.Add(bean.IsSuccess);
}
if (bean.ProcessFlag != null)
{
sql.Append(" ProcessFlag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.UpdateDT != null)
{
sql.Append(" UpdateDT={" + i++ + "}");
dList.Add(bean.UpdateDT);
}
sql.Append(" where Id={" + i++ + "}");
dList.Add(bean.Id);
Log.Debug("SQL :" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
public void ModifyEmail(Employer bean)
{
Log.Debug("ModifyById方法参数：" + bean.ToString());
string sql = "update t_employer set email={0} where id={1}";
Oop.Execute(sql, bean.Email, bean.Id);
}
/// <summary>
/// 保存充电站
/// </summary>
/// <param name="bean"></param>
public void SaveZhan(ChargStation bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update dev_chargstation set");
var i = 0;
var dList = new List <object>();
if (bean.ZhuangChangJ != null)
{
sql.Append(" zhuangchang_j={" + i++ + "},");
dList.Add(bean.ZhuangChangJ);
}
if (bean.ZhuangLeiX != null)
{
sql.Append(" zhuanglei_x={" + i++ + "},");
dList.Add(bean.ZhuangLeiX);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where ZHAN_BH={" + i++ + "}");
dList.Add(bean.ZhanBh);
try
{
Oop.Execute(sql.ToString(), dList.ToArray());
}
catch (Exception e)
{
Log.Error("保存充电站失败！", e);
}
}
public void DelEmployee(string id)
{
Log.Debug("del方法接收的参数：");
var sql = "delete from t_employer where id='" + id + "'";
Oop.Execute(sql);
}
/// <summary>
/// 添加配置项
/// </summary>
/// <param name="typeid"></param>
/// <param name="pzx"></param>
public void AddPZX(string typeid,string pzx)
{
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List<object>();
string id = Guid.NewGuid().ToString();
sql1.Append(" ID, ");
sql2.Append(" '"+id+"', ");
if (!string.IsNullOrEmpty(typeid))
{
sql1.Append(" PILETYPEID,");
sql2.Append(" {" + i++ + "},");
list.Add(typeid);
}
if (!string.IsNullOrEmpty(pzx))
{
sql1.Append(" GATITEMID,");
sql2.Append(" {" + i++ + "},");
list.Add(pzx);
}
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 + ",createdt) values(" + sql2 + ",sysdate)";
Oop.Execute(sql, list.ToArray());
}
/// <summary>
/// 修改检修记录
/// </summary>
/// <param name="bean"></param>
public override void Modify(ChargPileJianXiuJL bean)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update dev_maintainrecord set ");
strSql.Append(" ZHUAN_ID={0},UPDATEDT={1},JIANXIU_LX={2},JIANXIU_JB={3},JIANXIU_SJ={4},JIANXIU_JL={5},JIANXIU_R={6} ");
strSql.Append(" where id={7} ");
object[] parameters = new object[] {
bean.Zhuan_Id,
bean.UpdateDt,
bean.JianXiu_Lx,
bean.JianXiu_Jb,
bean.JianXiu_Sj,
bean.JianXiu_Jl,
bean.JianXiu_R,
bean.Id
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("修改充电桩检修记录失败！", e);
}
}
/// <summary>
/// 删除人员
/// </summary>
/// <param name="id"></param>
public void DelDepartment(string id)
{
Log.Debug("del方法参数：");
var sql = "delete from t_department where id='" + id + "' or parentdept='" + id + "'";
Oop.Execute(sql);
}
/// <summary>
/// 更新部门
/// </summary>
/// <param name="bean"></param>
public void UpdateDepartment(Department bean)
{
Log.Debug("更新部门");
var sql = "update t_department set name='" + bean.Name + "' where id='" + bean.Id + "'";
Oop.Execute(sql);
}
public override void Del(Warn bean)
{
Log.Debug("del方法参数：" + bean);
var sql = "delete from gat_warn where Id='" + bean.Id + "'";
Log.Debug("SQL :" + sql);
Oop.Execute(sql);
}
public override void Del(MenuPower bean)
{
Log.Debug("del方法参数：" + bean);
var sql = "delete from t_menu_power where powerid='" + bean.PowerId + "'";
Log.Debug("SQL :" + sql);
Oop.Execute(sql);
}
public override void Del(UseRoles bean)
{
Log.Debug("del方法参数：" + bean);
var sql = "delete from sm_useroles where loginname='" + bean.LoginName + "'";
Log.Debug("SQL :" + sql);
Oop.Execute(sql);
}
public override void Del(Role bean)
{
Log.Debug("del方法参数：" + bean);
var sql = "delete from sm_role where RoleId='" + bean.RoleId + "'";
Log.Debug("SQL :" + sql);
Oop.Execute(sql);
}
public override void Del(Branch bean)
{
Log.Debug("del方法参数：");
var sql = new StringBuilder();
sql.Append("delete from dev_branch where BranchNo='" + bean.BranchNo + "'");
Oop.Execute(sql.ToString());
}
public void Del2(UseRoles bean)
{
Log.Debug("del方法参数：" + bean);
var sql = "delete from sm_useroles where roleid='" + bean.RoleId + "'";
Log.Debug("SQL :" + sql);
Oop.Execute(sql);
}
public override void Del(ChargStation bean)
{
Log.Debug("del方法参数：");
var sql = new StringBuilder();
sql.Append("delete from dev_chargstation where Zhan_Bh='" + bean.ZhanBh + "'");
Oop.Execute(sql.ToString());
}
public override void Modify(ChargPrice bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update cfg_chargprice set");
var i = 0;
var dList = new List <object>();
if (!string.IsNullOrEmpty(bean.Name))
{
sql.Append(" Name={" + i++ + "},");
dList.Add(bean.Name);
}
if (!string.IsNullOrEmpty(bean.PriceType))
{
sql.Append(" PriceType={" + i++ + "},");
dList.Add(bean.PriceType);
}
if (bean.Version != null)
{
sql.Append(" Version={" + i++ + "},");
dList.Add(bean.Version);
}
if (bean.BeginDT != null)
{
sql.Append(" BeginDT={" + i++ + "},");
dList.Add(bean.BeginDT);
}
if (bean.EndDT != null)
{
sql.Append(" EndDT={" + i++ + "},");
dList.Add(bean.EndDT);
}
if (bean.Price != null)
{
sql.Append(" Price={" + i++ + "},");
dList.Add(bean.Price);
}
if (bean.CreateDT != null)
{
sql.Append(" CreateDT={" + i++ + "},");
dList.Add(bean.CreateDT);
}
if (bean.UpdateDT != null)
{
sql.Append(" UpdateDT={" + i++ + "},");
dList.Add(bean.UpdateDT);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where id={" + i++ + "}");
dList.Add(bean.Id);
Log.Debug("SQL :" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
public override void Modify(Branch bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update dev_branch set");
var i = 0;
var dList = new List <object>();
if (bean.ZhuanBh != null)
{
sql.Append(" ZhuanBh={" + i++ + "},");
dList.Add(bean.ZhuanBh);
}
if (!string.IsNullOrEmpty(bean.ChanQuanGx))
{
sql.Append(" ChanQuanGx={" + i++ + "},");
dList.Add(bean.ChanQuanGx);
}
if (!string.IsNullOrEmpty(bean.YunWeiDw))
{
sql.Append(" YunWeiDw={" + i++ + "},");
dList.Add(bean.YunWeiDw);
}
if (!string.IsNullOrEmpty(bean.ChangJia))
{
sql.Append(" ChangJia={" + i++ + "},");
dList.Add(bean.ChangJia);
}
if (!string.IsNullOrEmpty(bean.FenZhiXlx))
{
sql.Append(" FenZhiXlx={" + i++ + "},");
dList.Add(bean.FenZhiXlx);
}
if (bean.Createdt != null)
{
sql.Append(" Createdt={" + i++ + "},");
dList.Add(bean.Createdt);
}
if (bean.Updatedt != null)
{
sql.Append(" Updatedt={" + i++ + "},");
dList.Add(bean.Updatedt);
}
if (!string.IsNullOrEmpty(bean.ZhiChanBh))
{
sql.Append(" ZhiChanBh={" + i++ + "},");
dList.Add(bean.ZhiChanBh);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where BranchNo={" + i++ + "}");
dList.Add(bean.BranchNo);
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 删除充电桩计划任务
/// </summary>
/// <param name="bean"></param>
public override void Del(ScheduleJobs bean)
{
Log.Debug("del方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("delete from cmd_schedulejobs where id='" + bean.Id + "'");
Log.Debug("SQL :" + sql);
Oop.Execute(sql.ToString());
}
public override void Del(ChargPrice bean)
{
Log.Debug("del方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("delete from cfg_chargprice where id='" + bean.Id + "'");
Log.Debug("SQL :" + sql);
Oop.Execute(sql.ToString());
}
public override void Add(Warn bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (!string.IsNullOrEmpty(bean.Id))
{
sql1.Append(" Id,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Id);
}
if (!string.IsNullOrEmpty(bean.WarnType))
{
sql1.Append(" WarnType,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.WarnType);
}
if (!string.IsNullOrEmpty(bean.WarnTarget))
{
sql1.Append(" WarnTarget,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.WarnTarget);
}
if (!string.IsNullOrEmpty(bean.WarnContext))
{
sql1.Append(" WarnContext,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.WarnContext);
}
if (bean.CreateDT != null)
{
sql1.Append(" CreateDT,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.CreateDT);
}
if (bean.UpdateDT != null)
{
sql1.Append(" UpdateDT,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.UpdateDT);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into gat_warn(" + sql1 + ") values(" + sql2 + ")";
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
Oop.Execute(sql, list.ToArray());
}
/// <summary>
///
/// </summary>
/// <param name="bean"></param>
public override void Modify(SmsOutBox bean)
{
var sql = new StringBuilder("update msg_outbox set");
var i = 0;
var list = new List <object>();
if (!string.IsNullOrEmpty(bean.Msgid.ToString(CultureInfo.InvariantCulture)))
{
sql.Append(" Msgid={" + i++ + "},");
list.Add(bean.Msgid);
}
if (!string.IsNullOrEmpty(bean.Expresslevel.ToString(CultureInfo.InvariantCulture)))
{
sql.Append(" Expresslevel={" + i++ + "},");
list.Add(bean.Expresslevel);
}
if (!string.IsNullOrEmpty(bean.Sender))
{
sql.Append(" Sender={" + i++ + "},");
list.Add(bean.Sender);
}
if (!string.IsNullOrEmpty(bean.Receiver))
{
sql.Append(" Receiver={" + i++ + "},");
list.Add(bean.Receiver);
}
if (!string.IsNullOrEmpty(bean.Msgtype.ToString(CultureInfo.InvariantCulture)))
{
sql.Append(" Msgtype={" + i++ + "},");
list.Add(bean.Msgtype);
}
if (!string.IsNullOrEmpty(bean.Msgtitle))
{
sql.Append(" Msgtitle={" + i++ + "},");
list.Add(bean.Msgtitle);
}
if (!string.IsNullOrEmpty(bean.Mmscontentlocation))
{
sql.Append(" Mmscontentlocation={" + i++ + "},");
list.Add(bean.Mmscontentlocation);
}
if (!string.IsNullOrEmpty(bean.Sendtime.ToString()))
{
sql.Append(" Sendtime={" + i++ + "},");
list.Add(bean.Sendtime);
}
if (!string.IsNullOrEmpty(bean.Commport.ToString(CultureInfo.InvariantCulture)))
{
sql.Append(" Commport={" + i++ + "},");
list.Add(bean.Commport);
}
sql = sql.Remove(sql.Length - 1, 1);
sql.Append(" where id={" + i + "}");
list.Add(bean.Msgid);
Oop.Execute(sql.ToString(), list.ToArray());
}
public override void Add(Employer bean)
{
Log.Debug("Add方法接收的参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (!string.IsNullOrEmpty(bean.Id))
{
sql1.Append(" id,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Id);
}
if (!string.IsNullOrEmpty(bean.WorkNum))
{
sql1.Append(" WorkNum,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.WorkNum);
}
if (!string.IsNullOrEmpty(bean.Name))
{
sql1.Append(" name,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Name);
}
if (!string.IsNullOrEmpty(bean.DeptId))
{
sql1.Append(" deptid,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.DeptId);
}
if (!string.IsNullOrEmpty(bean.PhoneNum))
{
sql1.Append(" PhoneNum,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.PhoneNum);
}
if (!string.IsNullOrEmpty(bean.Email))
{
sql1.Append(" Email,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Email);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into t_employer(" + sql1 + ") values(" + sql2 + ")";
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
Oop.Execute(sql, list.ToArray());
}
