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