/// <summary> /// 设置集中器信息 /// </summary> /// <param name="esp"></param> /// <returns></returns> public int SetEsp(EspVModel esp) { int gw_id = 1; StringBuilder strSql = new StringBuilder(); strSql.Clear(); strSql.Append("insert into v1_gateway("); strSql.Append("Ledger,Gw_id,GwName,GwAddr,GwIp,GwPort,Timeout,GwType,GPRSNum,Inst_loc,Remark,Disabled,Create_by,Create_dt,Update_by,Update_dt)"); strSql.Append(" values (@Ledger,@Gw_id,'0.0.0.0','0.0.0.0','0.0.0.0',0,1000,'','','','',0,@SysUid,now(),@SysUid,now())"); strSql.Append("ON DUPLICATE KEY UPDATE Update_by=@SysUid,Update_dt=now()"); SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Gw_id = gw_id, SysUid = this.SysUid }); if (esp.Esp_id == 0) { strSql.Clear(); strSql.Append("select max(Esp_id)as cnt from v1_gateway_esp where Ledger=@Ledger"); esp.Esp_id = CommFunc.ConvertDBNullToInt32(SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger })) + 1; } object params01 = new { Ledger = this.Ledger, Esp_id = esp.Esp_id, Gw_id = gw_id, EspName = esp.EspName, EspAddr = esp.EspAddr, EspIp = "0.0.0.0", // esp.EspIp, EspPort = 1000, //esp.EspPort, Timeout = 1000, EspType = esp.EspType, Inst_loc = esp.Inst_loc, Remark = "", Disabled = esp.Disabled, Supplier = esp.Supplier, SysUid = this.SysUid }; strSql.Clear(); strSql.Append("insert into v1_gateway_esp("); strSql.Append("Ledger,Esp_id,Gw_id,EspName,EspAddr,EspIp,EspPort,Timeout,EspType,Inst_loc,Remark,Disabled,Create_by,Create_dt,Update_by,Update_dt,Supplier,ActiveTime)"); strSql.Append(" values ("); strSql.Append("@Ledger,@Esp_id,@Gw_id,@EspName,@EspAddr,@EspIp,@EspPort,@Timeout,@EspType,@Inst_loc,@Remark,@Disabled,@SysUid,now(),@SysUid,now(),@Supplier,now())"); strSql.Append("ON DUPLICATE KEY UPDATE "); strSql.Append(" EspName=@EspName,"); strSql.Append("EspAddr=@EspAddr,"); strSql.Append("EspIp=@EspIp,"); strSql.Append("EspPort=@EspPort,"); strSql.Append("Timeout=@Timeout,"); strSql.Append("EspType=@EspType,"); strSql.Append("Inst_loc=@Inst_loc,"); strSql.Append("Remark=@Remark,"); strSql.Append("Disabled=@Disabled,"); strSql.Append("Supplier=@Supplier,"); strSql.Append("Update_by =@SysUid,Update_dt=now()"); return(SQLHelper.Execute(strSql.ToString(), params01)); }
/// <summary> /// 设置集中器信息 /// </summary> /// <param name="esp">集中器信息</param> /// <returns></returns> public APIResult SetEsp(EspVModel esp) { APIResult rst = new APIResult(); try { bll.SetEsp(esp); rst.Code = 0; rst.Msg = ""; rst.Data = this.GetEspList(esp.Esp_id, ""); } catch (Exception ex) { rst.Code = -1; rst.Msg = ex.Message; FileLog.WriteLog("设置集中器信息错误(SetEsp):" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 设置集中器信息 /// </summary> /// <param name="esp"></param> /// <returns></returns> public int SetEsp(EspVModel esp) { return(dal.SetEsp(esp)); }
public APIResult SetEsp(EspVModel esp) { return(baseInfoHelper.SetEsp(esp)); }
public APIResult AddEsp(EspVModel esp) { esp.Esp_id = 0; return(baseInfoHelper.SetEsp(esp)); }