/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="modifyUser"></param>
/// <returns></returns>
public bool LogicDeleteInfo(long id, string loginUser)
{
UserRoleInfo userRoleInfo = dal.GetInfo(id);
if (userRoleInfo == null)
{
throw new Exception("MC:0x00000084");///数据错误
}
string sql = "update [dbo].[TS_SYS_USER_ROLE] " +
"set [VALID_FLAG] = 0,[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " +
"where [ID] = " + id + ";" +
"update [dbo].[TS_SYS_USER_ROLE_RANGE_AUTH] " +
"set [VALID_FLAG] = 0,[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " +
"where [USER_FID] = N'" + userRoleInfo.UserFid.GetValueOrDefault() + "' and [ROLE_FID] = N'" + userRoleInfo.RoleFid.GetValueOrDefault() + "';";
using (var trans = new TransactionScope())
{
CommonDAL.ExecuteNonQueryBySql(sql);
trans.Complete();
}
return(true);
}
