/// <summary>
/// 判断功能名，在同一级别中是否存在
/// </summary>
public APIResponseEntity <bool> IsExistFunctionNameInSameLevel(APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.SysFunction.IsExistFunctionNameInSameLevelEntity> request)
{
var response = new APIResponseEntity <bool>();
response.IsSuccess = true;
response.Message = "该功能名可以使用！";
XCLCMS.Data.Model.SysFunction model = null;
if (request.Body.SysFunctionID > 0)
{
model = sysFunctionBLL.GetModel(request.Body.SysFunctionID);
if (null != model)
{
if (string.Equals(request.Body.FunctionName, model.FunctionName, StringComparison.OrdinalIgnoreCase))
{
return(response);
}
}
}
List <XCLCMS.Data.Model.SysFunction> lst = sysFunctionBLL.GetChildListByID(request.Body.ParentID);
if (lst.IsNotNullOrEmpty())
{
if (lst.Exists(k => string.Equals(k.FunctionName, request.Body.FunctionName, StringComparison.OrdinalIgnoreCase)))
{
response.IsSuccess = false;
response.Message = "该功能名在当前层级中已存在！";
}
}
return(response);
}
public override ActionResult AddSubmit(FormCollection fm)
{
base.AddSubmit(fm);
XCLCMS.View.AdminWeb.Models.SysFunction.SysFunctionAddVM viewModel = this.GetViewModel(fm);
XCLCMS.Data.Model.SysFunction model = null;
XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel();
model = new Data.Model.SysFunction();
model.CreaterID = base.CurrentUserModel.UserInfoID;
model.CreaterName = base.CurrentUserModel.UserName;
model.CreateTime = DateTime.Now;
model.UpdaterID = base.CurrentUserModel.UserInfoID;
model.UpdaterName = base.CurrentUserModel.UserName;
model.UpdateTime = DateTime.Now;
model.ParentID = viewModel.ParentID;
model.FunctionName = viewModel.SysFunction.FunctionName;
model.Remark = viewModel.SysFunction.Remark;
model.RecordState = XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString();
model.SysFunctionID = XCLCMS.Lib.WebAPI.Library.CommonAPI_GenerateID(base.UserToken, new Data.WebAPIEntity.RequestEntity.Common.GenerateIDEntity()
{
IDType = Data.CommonHelper.EnumType.IDTypeEnum.FUN.ToString()
});
model.Code = viewModel.SysFunction.Code;
var request = XCLCMS.Lib.WebAPI.Library.CreateRequest <XCLCMS.Data.Model.SysFunction>(base.UserToken);
request.Body = model;
var response = XCLCMS.Lib.WebAPI.SysFunctionAPI.Add(request);
return(Json(response));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XCLCMS.Data.Model.SysFunction model)
{
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("sp_SysFunction_Update");
db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, model.SysFunctionID);
db.AddInParameter(dbCommand, "ParentID", DbType.Int64, model.ParentID);
db.AddInParameter(dbCommand, "FunctionName", DbType.AnsiString, model.FunctionName);
db.AddInParameter(dbCommand, "Code", DbType.AnsiString, model.Code);
db.AddInParameter(dbCommand, "Remark", DbType.String, model.Remark);
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);
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 APIResponseEntity <bool> IsExistCode(APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.SysFunction.IsExistCodeEntity> request)
{
var response = new APIResponseEntity <bool>();
response.IsSuccess = true;
response.Message = "该标识可以使用！";
XCLCMS.Data.Model.SysFunction model = null;
if (request.Body.SysFunctionID > 0)
{
model = sysFunctionBLL.GetModel(request.Body.SysFunctionID);
if (null != model)
{
if (string.Equals(request.Body.Code, model.Code, StringComparison.OrdinalIgnoreCase))
{
return(response);
}
}
}
if (!string.IsNullOrEmpty(request.Body.Code))
{
bool isExist = sysFunctionBLL.IsExistCode(request.Body.Code);
if (isExist)
{
response.IsSuccess = false;
response.Message = "该标识名已存在！";
}
}
return(response);
}
public APIResponseEntity <bool> IsExistFunctionNameInSameLevel([FromUri] string json)
{
var request = Newtonsoft.Json.JsonConvert.DeserializeObject <APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.SysFunction.IsExistFunctionNameInSameLevelEntity> >(System.Web.HttpUtility.UrlDecode(json));
var response = new APIResponseEntity <bool>();
response.IsSuccess = true;
response.Message = "该功能名可以使用！";
XCLCMS.Data.Model.SysFunction model = null;
if (request.Body.SysFunctionID > 0)
{
model = sysFunctionBLL.GetModel(request.Body.SysFunctionID);
if (null != model)
{
if (string.Equals(request.Body.FunctionName, model.FunctionName, StringComparison.OrdinalIgnoreCase))
{
return(response);
}
}
}
List <XCLCMS.Data.Model.SysFunction> lst = sysFunctionBLL.GetChildListByID(request.Body.ParentID);
if (lst.IsNotNullOrEmpty())
{
if (lst.Exists(k => string.Equals(k.FunctionName, request.Body.FunctionName, StringComparison.OrdinalIgnoreCase)))
{
response.IsSuccess = false;
response.Message = "该功能名在当前层级中已存在！";
}
}
return(response);
}
public APIResponseEntity <bool> IsExistCode([FromUri] string json)
{
var request = Newtonsoft.Json.JsonConvert.DeserializeObject <APIRequestEntity <XCLCMS.Data.WebAPIEntity.RequestEntity.SysFunction.IsExistCodeEntity> >(System.Web.HttpUtility.UrlDecode(json));
var response = new APIResponseEntity <bool>();
response.IsSuccess = true;
response.Message = "该标识可以使用！";
XCLCMS.Data.Model.SysFunction model = null;
if (request.Body.SysFunctionID > 0)
{
model = sysFunctionBLL.GetModel(request.Body.SysFunctionID);
if (null != model)
{
if (string.Equals(request.Body.Code, model.Code, StringComparison.OrdinalIgnoreCase))
{
return(response);
}
}
}
if (!string.IsNullOrEmpty(request.Body.Code))
{
bool isExist = sysFunctionBLL.IsExistCode(request.Body.Code);
if (isExist)
{
response.IsSuccess = false;
response.Message = "该标识名已存在！";
}
}
return(response);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XCLCMS.Data.Model.SysFunction GetModel(long SysFunctionID)
{
XCLCMS.Data.Model.SysFunction model = new XCLCMS.Data.Model.SysFunction();
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand("select * from SysFunction where SysFunctionID=@SysFunctionID");
db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, SysFunctionID);
DataSet ds = db.ExecuteDataSet(dbCommand);
var lst = XCLNetTools.Generic.ListHelper.DataTableToList <XCLCMS.Data.Model.SysFunction>(ds.Tables[0]);
return(null != lst && lst.Count > 0 ? lst[0] : null);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XCLCMS.Data.Model.SysFunction GetModel(long SysFunctionID)
{
XCLCMS.Data.Model.SysFunction model = new XCLCMS.Data.Model.SysFunction();
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand("select * from SysFunction WITH(NOLOCK) where SysFunctionID=@SysFunctionID");
db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, SysFunctionID);
using (var dr = db.ExecuteReader(dbCommand))
{
return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.SysFunction>(dr));
}
}
/// <summary>
/// 删除指定SysFunctionID下面的子节点
/// </summary>
public bool DelChild(XCLCMS.Data.Model.SysFunction model)
{
string strSql = string.Format("update SysFunction set RecordState='{0}',UpdateTime=@UpdateTime,UpdaterID=@UpdaterID,UpdaterName=@UpdaterName where ParentID=@SysFunctionID and RecordState='{1}' and ParentID>0",
XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.D.ToString(), XCLCMS.Data.CommonHelper.EnumType.RecordStateEnum.N.ToString());
Database db = base.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, model.SysFunctionID);
db.AddInParameter(dbCommand, "UpdateTime", DbType.DateTime, model.UpdateTime);
db.AddInParameter(dbCommand, "UpdaterID", DbType.Int64, model.UpdaterID);
db.AddInParameter(dbCommand, "UpdaterName", DbType.String, model.UpdaterName);
return(db.ExecuteNonQuery(dbCommand) > 0);
}
/// <summary>
/// 删除指定SysFunctionId下面的子节点
/// </summary>
public bool DelChild(XCLCMS.Data.Model.SysFunction model)
{
return(dal.DelChild(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(XCLCMS.Data.Model.SysFunction model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(XCLCMS.Data.Model.SysFunction model)
{
return(dal.Add(model));
}
