/// <summary> /// 设置采集点信息 /// </summary> /// <returns></returns> public APIRst SetModuleFun(ModuleFunVModel fun) { APIRst rst = new APIRst(); try { rst.data = bll.SetModuleFun(fun); } 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="fun"></param> /// <returns></returns> public int SetModuleFun(ModuleFunVModel fun) { StringBuilder strSql = new StringBuilder(); strSql.Clear(); strSql.Append("select count(*) from v0_fun where Ledger=@Ledger and Fun_id!=@Fun_id and FunType=@FunType"); object obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger, Fun_id = fun.Fun_id, FunType = fun.FunType }); if (CommFunc.ConvertDBNullToInt32(obj) > 0) { throw new Exception("已存在此采集点型号:" + fun.FunType); } if (fun.ModuleTypeId == 0) { throw new Exception("已存在此采集类型ID号为空"); } if (fun.Fun_id == 0) { strSql.Clear(); strSql.Append("select max(Fun_id)as cnt from v0_fun where Ledger=@Ledger"); fun.Fun_id = CommFunc.ConvertDBNullToInt32(SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger })) + 1; } // strSql.Clear(); strSql.Append("select count(a.Ledger)as cnt from v0_fun as a inner join v2_info as b on a.Ledger=b.Ledger and a.Fun_id=b.Fun_id"); strSql.Append(" where a.Ledger=@Ledger and a.Mm_id=@Mm_id and a.Fun_id=@Fun_id limit 1"); obj = SQLHelper.ExecuteScalar(strSql.ToString(), new { Ledger = this.Ledger, Mm_id = fun.ModuleTypeId, Fun_id = fun.Fun_id }); if (CommFunc.ConvertDBNullToInt32(obj) > 0) { throw new Exception("此采集点型号:" + fun.FunType + "已经有采集数据不能修改"); } // object params01 = new { Ledger = this.Ledger, Mm_id = fun.ModuleTypeId, Fun_id = fun.Fun_id, FunType = fun.FunType, FunName = fun.FunName, Disabled = 0 }; strSql.Clear(); strSql.Append("insert into v0_fun(Ledger,Fun_id,Mm_id,FunName,FunType,Action,Scale,Disabled,SubTab)"); strSql.Append(" values (@Ledger, @Fun_id, @Mm_id, @FunName, @FunType, 0, 2, 0, @FunType)"); strSql.Append("ON DUPLICATE KEY UPDATE FunType=@FunType,FunName=@FunName,SubTab=@FunType;"); return(SQLHelper.Execute(strSql.ToString(), params01)); }
public APIRst SetModuleFun(ModuleFunVModel fun) { return(infoHelper.SetModuleFun(fun)); }
public APIRst AddModuleFun(ModuleFunVModel fun) { fun.Fun_id = 0; return(infoHelper.SetModuleFun(fun)); }
/// <summary> /// 设置采集点信息 /// </summary> /// <param name="fun"></param> /// <returns></returns> public int SetModuleFun(ModuleFunVModel fun) { return(dal.SetModuleFun(fun)); }