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