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