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