public int Insert(RoleInfo oParam)
{
string sql = @"INSERT INTO Sys_Role
(
SysNo, RoleID, RoleName, Status
)
VALUES (
@SysNo, @RoleID, @RoleName, @Status
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramRoleID = new SqlParameter("@RoleID", SqlDbType.NVarChar,20);
SqlParameter paramRoleName = new SqlParameter("@RoleName", SqlDbType.NVarChar,50);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
paramSysNo.Value = oParam.SysNo;
paramRoleID.Value = oParam.RoleID;
paramRoleName.Value = oParam.RoleName;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramRoleID);
cmd.Parameters.Add(paramRoleName);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Update_DBC(RoleInfo oParam)
{
string sql = @"UPDATE Sys_Role SET
RoleID=@RoleID,
RoleName=@RoleName, Status=@Status, OperationTypeID=@OperationTypeID
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramRoleID = new SqlParameter("@RoleID", SqlDbType.NVarChar, 20);
SqlParameter paramRoleName = new SqlParameter("@RoleName", SqlDbType.NVarChar, 50);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramOperationTypeID = new SqlParameter("@OperationTypeID", SqlDbType.Int, 4);
paramSysNo.Value = oParam.SysNo;
paramRoleID.Value = oParam.RoleID;
paramRoleName.Value = oParam.RoleName;
paramStatus.Value = oParam.Status;
if (oParam.OperationTypeID == -2)
paramOperationTypeID.Value = System.DBNull.Value;
else
paramOperationTypeID.Value = oParam.OperationTypeID;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramRoleID);
cmd.Parameters.Add(paramRoleName);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramOperationTypeID);
return SqlHelper.ExecuteNonQuery(cmd);
}
/// <summary>
/// Map RoleInfo
/// </summary>
/// <param name="oParam"></param>
/// <param name="tempdr"></param>
private void map(RoleInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.RoleID = Util.TrimNull(tempdr["RoleID"]);
oParam.RoleName = Util.TrimNull(tempdr["RoleName"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
public Hashtable GetRoleHtByDept(Hashtable paramHash)
{
DataSet ds = GetRoleDsByDept(paramHash);
if (!Util.HasMoreRow(ds))
return null;
Hashtable ht = new Hashtable(20);
foreach (DataRow dr in ds.Tables[0].Rows)
{
RoleInfo item = new RoleInfo();
map(item, dr);
ht.Add(item, null);
}
return ht;
}
/// <summary>
/// ���½�ɫ,��ӵIJ���
/// </summary>
/// <param name="oParam"></param>
/// <returns></returns>
public int UpdateRole_DBC(RoleInfo oParam, string paramDelSql)
{
int _return = 0;
string[] strPrivilege = paramDelSql.Split(',');
//oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence");
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
_return = new RoleDac().Update_DBC(oParam);
_return = new RoleDac().DelPrivilegeRole(paramDelSql, oParam.SysNo);
for (int i = 0; i < strPrivilege.Length; i++)
{
if (Util.IsNumber(strPrivilege[i]))
_return = new RoleDac().InsertPrivilegeRole(oParam.SysNo, Int16.Parse(strPrivilege[i]));
}
scope.Complete();
}
return _return;
}
/// <summary>
/// ���½�ɫ
/// </summary>
/// <param name="oParam"></param>
/// <returns></returns>
public int UpdateRole(RoleInfo oParam)
{
string sql = "select * from sys_role where sysno <> " + oParam.SysNo + " and roleid = " + Util.ToSqlString(oParam.RoleID);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( Util.HasMoreRow(ds))
throw new BizException("the same Role ID exists");
return new RoleDac().Update(oParam);
}
/// <summary>
/// ����SysNo��ȡ��ɫ
/// </summary>
/// <param name="paramRoleSysNo"></param>
/// <returns></returns>
public RoleInfo LoadRole(int paramRoleSysNo)
{
string sql = "select * from sys_role where sysno = " + paramRoleSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( !Util.HasMoreRow(ds) )
return null;
RoleInfo oRoleInfo = new RoleInfo();
map(oRoleInfo, ds.Tables[0].Rows[0]);
return oRoleInfo;
}
/// <summary>
/// ���ӽ�ɫ����ɫID�����ظ�,�����˲���
/// </summary>
/// <param name="oParam"></param>
/// <returns></returns>
public int InsertRole_DBC(RoleInfo oParam,string paramDelSql)
{
//string sql = "select top 1 sysno from sys_role where roleid = " + Util.ToSqlString((oParam.RoleID));
//DataSet ds = SqlHelper.ExecuteDataSet(sql);
//if (Util.HasMoreRow((ds)))
// throw new BizException("the same Role ID exists");
//oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence");
//return new RoleDac().Insert(oParam);
int _return = 0;
string[] strPrivilege = paramDelSql.Split(',');
oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence");
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
_return = new RoleDac().Insert_DBC(oParam);
_return = new RoleDac().DelPrivilegeRole(paramDelSql, oParam.SysNo);
for (int i = 0; i < strPrivilege.Length; i++)
{
if (Util.IsNumber(strPrivilege[i]))
_return = new RoleDac().InsertPrivilegeRole(oParam.SysNo, Int16.Parse(strPrivilege[i]));
}
scope.Complete();
}
return _return;
}
/// <summary>
/// ���ӽ�ɫ����ɫID�����ظ�
/// </summary>
/// <param name="oParam"></param>
/// <returns></returns>
public int InsertRole(RoleInfo oParam)
{
string sql = "select top 1 sysno from sys_role where roleid = " + Util.ToSqlString((oParam.RoleID));
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( Util.HasMoreRow((ds)))
throw new BizException("the same Role ID exists");
oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence");
return new RoleDac().Insert(oParam);
}
