/// <summary> /// 添加系统设置 /// </summary> /// <param name="set"></param> /// <returns></returns> public string AddSet(MD_SysSet set) { DbParameter[] parms = { GenerateInParam("@parentid", SqlDbType.Int, 4, set.Parentid), GenerateInParam("@name", SqlDbType.VarChar, 50, set.Name), GenerateInParam("@invalue", SqlDbType.VarChar, 50, set.InValue) }; string commandText = string.Format(@" begin try INSERT INTO owzx_sys_set([parentid],[name],[invalue]) VALUES (@parentid,@name,@invalue) select '添加成功' state end try begin catch select ERROR_MESSAGE() state end catch "); return(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString()); }
/// <summary> /// 更新系统设置 /// </summary> /// <param name="set"></param> /// <returns></returns> public string UpdateSet(MD_SysSet set) { DbParameter[] parms = { GenerateInParam("@setid", SqlDbType.Int, 4, set.Setid), GenerateInParam("@name", SqlDbType.VarChar, 50, set.Name), GenerateInParam("@invalue", SqlDbType.VarChar, 50, set.InValue) }; string commandText = string.Format(@" begin try begin tran t1 if exists(select 1 from owzx_sys_set where setid=@setid) begin update a set a.name=@name,a.invalue=@invalue from owzx_sys_set a where a.setid=@setid select '更新成功' state commit tran t1 end else begin select '记录已被删除' state commit tran t1 end end try begin catch rollback tran t1 select ERROR_MESSAGE() state end catch "); return(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString()); }