/// <summary>
/// 增加一条数据
/// 注：如果roleIdList为空，则添加model.FK_SysRoleID，否则，则添加roleIdList
/// </summary>
public bool Add(XCLCMS.Data.Model.SysUserRole model, List <long> roleIdList = null)
{
if (null == roleIdList || roleIdList.Count == 0)
{
if (model.FK_SysRoleID > 0)
{
roleIdList = new List <long>()
{
model.FK_SysRoleID
};
}
}
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("sp_SysUserRole_ADD");
db.AddInParameter(dbCommand, "FK_UserInfoID", DbType.Int64, model.FK_UserInfoID);
db.AddInParameter(dbCommand, "RecordState", DbType.AnsiString, model.RecordState);
db.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, model.CreateTime);
db.AddInParameter(dbCommand, "CreaterID", DbType.Int64, model.CreaterID);
db.AddInParameter(dbCommand, "CreaterName", DbType.String, model.CreaterName);
db.AddInParameter(dbCommand, "UpdateTime", DbType.DateTime, model.UpdateTime);
db.AddInParameter(dbCommand, "UpdaterID", DbType.Int64, model.UpdaterID);
db.AddInParameter(dbCommand, "UpdaterName", DbType.String, model.UpdaterName);
dbCommand.Parameters.Add(new SqlParameter("@FK_SysRoleIDTable", SqlDbType.Structured)
{
TypeName = "TVP_IDTable",
Direction = ParameterDirection.Input,
Value = XCLNetTools.DataSource.DataTableHelper.ToSingleColumnDataTable <long, long>(roleIdList)
});
db.AddOutParameter(dbCommand, "ResultCode", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "ResultMessage", DbType.String, 1000);
db.ExecuteNonQuery(dbCommand);
var result = XCLCMS.Data.DAL.Common.Common.GetProcedureResult(dbCommand.Parameters);
if (result.IsSuccess)
{
return(true);
}
else
{
throw new Exception(result.ResultMessage);
}
}
/// <summary>
/// 执行策略
/// </summary>
public override void DoWork <T>(T context)
{
var userInfoContext = context as XCLCMS.Data.BLL.Strategy.UserInfo.UserInfoContext;
XCLCMS.Data.BLL.SysUserRole bll = new XCLCMS.Data.BLL.SysUserRole();
XCLCMS.Data.Model.SysUserRole model = new XCLCMS.Data.Model.SysUserRole();
model.CreaterID = userInfoContext.CurrentUserInfo.UserInfoID;
model.CreaterName = userInfoContext.CurrentUserInfo.UserName;
model.CreateTime = DateTime.Now;
model.UpdaterID = model.CreaterID;
model.UpdaterName = model.CreaterName;
model.UpdateTime = model.CreateTime;
model.FK_UserInfoID = userInfoContext.UserInfo.UserInfoID;
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
bool flag = false;
try
{
flag = bll.Add(model, userInfoContext.UserRoleIDs);
}
catch (Exception ex)
{
flag = false;
this.ResultMessage += string.Format("异常信息：{0}", ex.Message);
}
if (flag)
{
this.Result = StrategyLib.ResultEnum.SUCCESS;
}
else
{
this.Result = StrategyLib.ResultEnum.FAIL;
this.ResultMessage = string.Format("保存用户角色信息失败！{0}", this.ResultMessage);
}
}
/// <summary>
/// 增加数据
/// </summary>
public bool Add(XCLCMS.Data.Model.SysUserRole model, List <long> roleIdList = null)
{
return(dal.Add(model, roleIdList));
}
