/// <summary> /// 保存集中器信息 /// </summary> /// <param name="Gw"></param> /// <returns></returns> public int YdModuleOnSaveGw(v1_gatewayVModel Gw) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); DataTable obj = new DataTable(); if (Gw.Gw_id == 0) { strSql.Clear(); strSql.Append("select max(Gw_id) as cnt from v1_gateway where Ledger=@Ledger"); obj = SQLHelper.Query(strSql.ToString(), new { Ledger = this.Ledger }); Gw.Gw_id = obj.Rows.Count > 0 ? CommFunc.ConvertDBNullToInt32(obj.Rows[0]["cnt"]) + 1 : 1; //Gw.Gw_id = CommFunc.ConvertDBNullToInt32(obj.Rows[0]["cnt"]) + 1; //Gw.Gw_id = CommFunc.ConvertDBNullToInt32(SQLUtilities.ExecuteScalar(strSql.ToString(), params01)) + 1; //params01[1].Value = Gw.Gw_id; strSql.Clear(); strSql.Append("insert into v1_gateway("); strSql.Append("Ledger,Gw_id,GwName,GwAddr,GwIp,GwPort,Timeout,GwType,Inst_loc,Remark,Disabled,Create_by,Create_dt,Update_by,Update_dt)"); strSql.Append(" values ("); strSql.Append("@Ledger,@Gw_id,@GwName,@GwAddr,@GwIp,@GwPort,@Timeout,@GwType,@Inst_loc,@Remark,@Disabled,@Uid,now(),@Uid,now())"); if (SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Gw_id = Gw.Gw_id, GwName = Gw.GwName, GwAddr = Gw.GwAddr, GwIp = Gw.GwIp, GwPort = Gw.GwPort, Timeout = Gw.Timeout, GwType = Gw.GwType, Inst_loc = Gw.Inst_loc, Remark = Gw.Remark, Disabled = Gw.Disabled, Uid = this.SysUid }) > 0) { return(Gw.Gw_id); } else { return(0); } } else { strSql.Clear(); strSql.Append("update v1_gateway set "); strSql.Append("GwName=@GwName,"); strSql.Append("GwAddr=@GwAddr,"); strSql.Append("GwIp=@GwIp,"); strSql.Append("GwPort=@GwPort,"); strSql.Append("Timeout=@Timeout,"); strSql.Append("GwType=@GwType,"); strSql.Append("Inst_loc=@Inst_loc,"); strSql.Append("Remark=@Remark,"); strSql.Append("Disabled=@Disabled,"); strSql.Append("Update_by=@Uid,"); strSql.Append("Update_dt=now()"); strSql.Append(" where Ledger=@Ledger and Gw_id=@Gw_id "); if (SQLHelper.Execute(strSql.ToString(), new { Ledger = this.Ledger, Gw_id = Gw.Gw_id, GwName = Gw.GwName, GwAddr = Gw.GwAddr, GwIp = Gw.GwIp, GwPort = Gw.GwPort, Timeout = Gw.Timeout, GwType = Gw.GwType, Inst_loc = Gw.Inst_loc, Remark = Gw.Remark, Disabled = Gw.Disabled, Uid = this.SysUid }) > 0) { return(Gw.Gw_id); } else { return(0); } } }
/// <summary> /// 保存集中器信息 /// </summary> /// <param name="gw">对象</param> /// <returns></returns> public APIRst YdModuleOnSaveGw(v1_gatewayVModel gw) { APIRst rst = new APIRst(); try { if (string.IsNullOrEmpty(gw.GwName)) { throw new Exception("集中器名称不能为空"); } var gwid = bll.IsExistYdGwName(gw.GwName); if (gwid > 0 && (gw.Gw_id == 0 || (gw.Gw_id > 0 && gw.Gw_id != gwid))) { throw new Exception("集中器名称:" + gw.GwName + "重复,请查询后再操作"); } if (string.IsNullOrEmpty(gw.GwAddr)) { throw new Exception("集中器地址不能为空"); } gwid = bll.IsExistYdGwAddr(gw.GwAddr); if (gwid > 0 && (gw.Gw_id == 0 || (gw.Gw_id > 0 && gw.Gw_id != gwid))) { throw new Exception("集中器地址:" + gw.GwAddr + "重复,请查询后再操作"); } if (gw.Timeout == 0) { throw new Exception("集中器延时设置(毫秒)不能为零"); } int total = 0; bll.YdModuleOnSaveGw(gw); object rows = this.GetYdModuleOnGatewayList(gw.Gw_id, out total); object obj = new { total = total, rows = rows }; rst.data = obj; } catch (Exception ex) { rst.rst = false; rst.err.code = (int)ResultCodeDefine.Error; rst.err.msg = ex.Message; FileLog.WriteLog("设置集中器数据错误:" + ex.Message + ex.StackTrace); } return(rst); }
/// <summary> /// 设置集中器信息 /// </summary> /// <param name="Gw"></param> /// <returns></returns> public int YdModuleOnSaveGw(v1_gatewayVModel Gw) { return(dal.YdModuleOnSaveGw(Gw)); }
public APIRst SetYdModuleOnSaveGw(v1_gatewayVModel v1_gateway) { return(infoHelper.YdModuleOnSaveGw(v1_gateway)); }