public async Task <IHttpActionResult> Post(ModelInputModel newModel) { if (newModel == null) { return(BadRequest(ErrorMessage.Model.RequiredModelInputModel)); } if (string.IsNullOrWhiteSpace(newModel.Name)) { return(BadRequest(ErrorMessage.Model.RequiredModelName)); } //Create model and comments Model model = new Model() { Id = newModel.Id, Name = newModel.Name, VehicleTypeId = newModel.VehicleTypeId }; CommentsStagingModel comment = new CommentsStagingModel() { Comment = newModel.Comment }; var attachments = SetUpAttachmentsModels(newModel.Attachments); var changeRequestId = await _modelApplicationService.AddAsync(model, CurrentUser.Email, comment, attachments); return(Ok(changeRequestId)); }
public void DeleteModelDetail() { // 新增表 ModelInputModel inputMaster = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> resultMaster = this.ModelService.ModifyModel(inputMaster); Assert.IsTrue(resultMaster.IsSuccess, resultMaster.ErrorMessage); // 新增动态表字段 ModelDetailInputModel inputModel = new ModelDetailInputModel() { ColIndex = 1, ColMemo = "AA", ColName = "BB", ColType = "nvarchar(256)", ModelID = resultMaster?.Data?.ModelID }; BaseResultModel <ModelDetailOutputModel> result = this.ModelDetailService.ModifyModelDetail(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); // 删除动态字段表 BaseResultModel <int> delResult = this.ModelDetailService.DeleteModelDetail(new List <Guid?> { result.Data.ModelDetailID }); Assert.IsTrue(delResult.IsSuccess && delResult.Data > 0, delResult.ErrorMessage); }
public async Task <IHttpActionResult> Put(int id, ModelInputModel model) { if (id == default(int)) { return(BadRequest(ErrorMessage.Model.InvalidModelId)); } if (model == null) { return(BadRequest(ErrorMessage.Model.RequiredModelInputModel)); } if (string.IsNullOrWhiteSpace(model.Name)) { return(BadRequest(ErrorMessage.Model.RequiredModelName)); } //Create Model and Comments Model _model = new Model() { Id = model.Id, Name = model.Name, VehicleTypeId = model.VehicleTypeId, BaseVehicleCount = model.BaseVehicleCount, VehicleCount = model.VehicleCount }; CommentsStagingModel comment = new CommentsStagingModel() { Comment = model.Comment }; var attachments = SetUpAttachmentsModels(model.Attachments); var changeRequestId = await _modelApplicationService.UpdateAsync(_model, id, CurrentUser.Email, comment, attachments); return(Ok(changeRequestId)); }
public IActionResult GetPFPredictionGrade([FromBody] ModelInputModel input) { var data = mapper.Map <PFPrediction.Model.DataModels.ModelInput>(input); var pred = mlService.GetPFPredictionForStudent(data); return(Ok(pred)); }
/// <summary> /// 新增、修改模块表 /// </summary> /// <param name="model"></param> /// <returns></returns> public BaseResultModel <ModelOutputModel> ModifyModel(ModelInputModel model) { SuccessResultModel <ModelOutputModel> result = new SuccessResultModel <ModelOutputModel>(); try { ModelOutputModel selModel = this.ModelRepository.SelectWithModel(new ModelModel() { ModelName = model.ModelName }); ModelOutputModel selModelCode = this.ModelRepository.SelectWithModel(new ModelModel() { ModelCode = model.ModelCode }); if (model.ModelID.IsNullOrEmpty()) { if (selModel != null) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.参数校验未通过, "名称已存在")); } if (selModelCode != null) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.参数校验未通过, "编号已存在")); } model.ModelID = model.ModelID ?? Guid.NewGuid(); List <ModelDetailInputModel> initModelDeatil = GetInitModelDetailList(model); TransactionOptions option = new TransactionOptions(); option.IsolationLevel = IsolationLevel.ReadCommitted; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, option)) { // 初始化表-- 》 全局固定字段: 工号、审核状态、审核时间、确认标识、确认人、确认时间 this.ModelDetailRepository.InsertCol(initModelDeatil.ToArray()); this.ModelDetailRepository.InitDBTable(model); result.Data = this.ModelRepository.InsertAndReturn(model); scope.Complete(); } } else { if (selModel != null && selModel.ModelID != model.ModelID) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.参数校验未通过, "名称已存在")); } if (selModelCode != null && selModelCode.ModelID != model.ModelID) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.参数校验未通过, "编号已存在")); } result.Data = this.ModelRepository.UpdateWithKeysAndReturn(model); } return(result); } catch (Exception ex) { LogWriter.WriteLog(EnumLogLevel.Fatal, "ModifyModel", JsonConvert.SerializeObject(model), "Model", "新增、修改模块表异常!", ex); return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.系统异常, "新增、修改模块表异常")); } }
/// <summary> /// 删除模块表 (逻辑删除) /// </summary> /// <param name="IDs"></param> /// <returns></returns> public BaseResultModel <int> DeleteModel(List <Guid?> IDs) { SuccessResultModel <int> result = new SuccessResultModel <int>(); ErrorResultModel <int> error = new ErrorResultModel <int>(); try { ModelOutputModel selModel = new ModelOutputModel(); ModelInputModel inputModel = new ModelInputModel(); TransactionOptions option = new TransactionOptions(); option.IsolationLevel = IsolationLevel.ReadCommitted; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, option)) { foreach (Guid?item in IDs) { selModel = this.ModelRepository.SelectWithKeys(new ModelModel() { ModelID = item }); inputModel = new ModelInputModel() { ModelID = selModel.ModelID, ModelCode = selModel.ModelCode, IsDelete = true }; result.Data = this.ModelDetailRepository.UpdateWithModel(new ModelDetailModel() { IsDelete = true }, new ModelDetailModel() { ModelID = selModel.ModelID }); result.Data = this.ModelRepository.UpdateWithKeys(inputModel); this.ModelRepository.DelDBTable(inputModel); } scope.Complete(); } if (result.Data == 0) { error.ErrorCode = EnumErrorCode.业务执行失败; error.ErrorMessage = "请确认需要删除的数据!"; return(error); } return(result); } catch (Exception ex) { LogWriter.WriteLog(EnumLogLevel.Fatal, "DeleteModel", JsonConvert.SerializeObject(IDs), "Model", "删除模块表 (逻辑删除)异常!", ex); error.ErrorCode = EnumErrorCode.系统异常; error.ErrorMessage = "删除模块表 (逻辑删除)异常!"; return(error); } }
/// <summary> /// 删除数据库表 /// </summary> /// <param name="model"></param> /// <returns></returns> public void DelDBTable(ModelInputModel model) { string sql = @" IF EXISTS(SELECT 1 FROM sysobjects WHERE id = OBJECT_ID('[{0}]')) drop table {0} "; sql = string.Format(sql, model.ModelCode); base.Internal_DataHelper.ExecuteNonQuery(sql); }
public void ListPageModel() { // 新增表 ModelInputModel inputModel = new ModelInputModel() { PageNO = 1, PageSize = 20, }; BaseResultModel <PageModel <ModelOutputModel> > result = this.ModelService.ListPageModel(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); }
public async Task <IHttpActionResult> Post(int id, ModelInputModel modelInputModel) { //System.Threading.Thread.Sleep(2000); //return Ok(-1); // create model and list of comments CommentsStagingModel comment = new CommentsStagingModel() { Comment = modelInputModel.Comment }; var attachments = SetUpAttachmentsModels(modelInputModel.Attachments); var changeRequestId = await _modelApplicationService.DeleteAsync(null, id, CurrentUser.Email, comment, attachments); return(Ok(changeRequestId)); }
/// <summary> /// 初始化数据库表明细字段 /// </summary> /// <param name="model"></param> /// <returns></returns> public void InitDBTable(ModelInputModel model) { string firstTableSql = @" IF EXISTS(SELECT 1 FROM sysobjects WHERE id = OBJECT_ID('[{0}]')) drop table {0} /*==============================================================*/ /* Table: {0} */ /*==============================================================*/ CREATE TABLE [dbo].[{0}]( "; string desSql = @" ) declare @CurrentUser sysname select @CurrentUser = '******' execute sp_addextendedproperty 'MS_Description', '{1}','user', @CurrentUser, 'table', '{0}' "; StringBuilder colSqlSB = new StringBuilder(); StringBuilder desSqlSB = new StringBuilder(); List <ModelDetailOutputModel> selModelDetail = this.List(new ModelDetailModel() { ModelID = model.ModelID }).ToList(); foreach (ModelDetailOutputModel modelDetail in selModelDetail) { colSqlSB.Append($" {modelDetail.ColName} {modelDetail.ColType} "); if (modelDetail.ColName == (model.ModelCode + "ID")) { colSqlSB.Append(" NOT NULL PRIMARY KEY "); } colSqlSB.Append(" , "); desSqlSB.Append($" execute sp_addextendedproperty 'MS_Description', '{modelDetail.ColMemo}' ,'user', @CurrentUser, 'table', '{model.ModelCode}', 'column', '{modelDetail.ColName}' "); } string sql = string.Format(firstTableSql, model.ModelCode) + colSqlSB.ToString() + string.Format((desSql + desSqlSB.ToString()), model.ModelCode, model.ModelName); base.Internal_DataHelper.ExecuteNonQuery(sql); }
/// <summary> /// 获取模块表列表分页 /// </summary> /// <param name="model"></param> /// <returns></returns> public BaseResultModel <PageModel <ModelOutputModel> > ListPageModel(ModelInputModel model) { try { model.PageNO = model.PageNO ?? 1; model.PageSize = model.PageSize ?? int.MaxValue; model.IsDelete = false; using (this.ModelRepository.BeginLikeMode()) { return(new SuccessResultModel <PageModel <ModelOutputModel> >(this.ModelRepository.ListPage(model))); } } catch (Exception e) { LogWriter.WriteLog(EnumLogLevel.Fatal, "ListPageModel", JsonConvert.SerializeObject(model), "Model", "获取模块表列表分页查询数据时发生错误.", e); return(new ErrorResultModel <PageModel <ModelOutputModel> >(EnumErrorCode.系统异常, "获取模块表列表分页查询数据时发生错误!")); } }
public void DeleteModel() { // 新增表 ModelInputModel inputModel = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> result = this.ModelService.ModifyModel(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); // 删除表 BaseResultModel <int> delResult = this.ModelService.DeleteModel(new List <Guid?> { result.Data.ModelID }); Assert.IsTrue(delResult.IsSuccess && delResult.Data > 0, delResult.ErrorMessage); }
public void InsertDynamicModel() { // 新增表 ModelInputModel inputMaster = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> resultMaster = this.ModelService.ModifyModel(inputMaster); Assert.IsTrue(resultMaster.IsSuccess, resultMaster.ErrorMessage); // 新增动态表字段 ModelDetailInputModel inputModel = new ModelDetailInputModel() { ColIndex = 1, ColMemo = "AA", ColName = "BB", ColType = "nvarchar(256)", ModelID = resultMaster?.Data?.ModelID }; BaseResultModel <ModelDetailOutputModel> resultDetail = this.ModelDetailService.ModifyModelDetail(inputModel); Assert.IsTrue(resultDetail.IsSuccess, resultDetail.ErrorMessage); // 新增动态表数据 TableSelModel selTable = new TableSelModel() { TableName = inputMaster.ModelCode, ColSel = new List <TableColSelModel>() { new TableColSelModel() { ColName = inputModel.ColName, ColValue = "BBValue" } } }; BaseResultModel <int> result = this.ModelService.InsertDynamicModel(selTable); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); }
public void ModifyModelDetail() { // 新增表 ModelInputModel inputMaster = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> resultMaster = this.ModelService.ModifyModel(inputMaster); Assert.IsTrue(resultMaster.IsSuccess, resultMaster.ErrorMessage); // 新增动态表字段 ModelDetailInputModel inputModel = new ModelDetailInputModel() { ColIndex = 1, ColMemo = "AA", ColName = "BB", ColType = "nvarchar(256)", ModelID = resultMaster?.Data?.ModelID }; BaseResultModel <ModelDetailOutputModel> result = this.ModelDetailService.ModifyModelDetail(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); // 编辑动态表字段 inputModel = new ModelDetailInputModel() { ModelDetailID = result?.Data?.ModelDetailID, ColIndex = 1, ColMemo = "AA", ColName = "BB", ColType = "nvarchar(256)", ModelID = resultMaster?.Data?.ModelID }; result = this.ModelDetailService.ModifyModelDetail(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); }
private static List <ModelDetailInputModel> GetInitModelDetailList(ModelInputModel model) { List <ModelDetailInputModel> initModelDeatil = new List <ModelDetailInputModel>(); initModelDeatil.Add(new ModelDetailInputModel() { ModelID = model.ModelID, ColIndex = 1, ColName = $"{model.ModelCode.Replace("tb_", "")}ID", ColMemo = "主键ID", ColType = "uniqueidentifier" }); initModelDeatil.Add(new ModelDetailInputModel() { ModelID = model.ModelID, ColIndex = 2, ColName = "IsDelete", ColMemo = "是否删除", ColType = "bit" }); return(initModelDeatil); }
public ModelOutputModel AddModel(Guid makeId, string modelName) { modelName = modelName.Trim(); // The make with the id should exist in the make list if (!DataProvider.Makes.Any(x => x.Key == makeId)) { throw new ResourceNotFoundException(nameof(makeId), makeId.ToString()); } return(LockHelper.LockAction <ModelOutputModel>( _modelLock, // De-duplicate the model with the same name & makeId... () => !DataProvider.Models.Any(x => x.Value.MakeId == makeId && String.Equals(x.Value.Name, modelName, StringComparison.InvariantCultureIgnoreCase)), () => { var model = new ModelInputModel(makeId, modelName); DataProvider.Models.TryAdd(model.Id, model); return _mapper.Map <ModelOutputModel>(model); }, () => throw new ResourceConflictException(nameof(modelName), modelName))); }
public void ModifyModel() { // 新增表 ModelInputModel inputModel = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> result = this.ModelService.ModifyModel(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); // 编辑表 inputModel = new ModelInputModel() { ModelID = result?.Data?.ModelID, ModelCode = "tb_test1", ModelName = "测试表1" }; result = this.ModelService.ModifyModel(inputModel); Assert.IsTrue(result.IsSuccess, result.ErrorMessage); }
/// <summary> /// 新增、修改模块表 /// </summary> /// <param name="model">OutputModel</param> /// <returns>OutputModel</returns> public BaseResultModel <ModelOutputModel> ModifyModel(ModelInputModel model) { if (model == null) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.请求参数错误, "参数不能为空")); } ModelAttrEx arrtEx = new ModelAttrEx(); string modelErrorMes = ""; if (model.ModelID.IsNullOrEmpty()) { modelErrorMes += arrtEx.AddAttrVaild <ModelInputModel>(ModelState, model); } else { modelErrorMes += arrtEx.EditAttrVaild <ModelInputModel>(ModelState, model); } if (!modelErrorMes.IsNullOrEmpty()) { return(new ErrorResultModel <ModelOutputModel>(EnumErrorCode.请求参数错误, modelErrorMes)); } return(ModelService.ModifyModel(model)); }
/// <summary> /// 获取模块表列表分页 /// </summary> /// <param name="model">InputModel</param> /// <returns>OutputModel</returns> public BaseResultModel <PageModel <ModelOutputModel> > ListPageModel(ModelInputModel model) { return(ModelService.ListPageModel(model)); }
public void ListPageDynamicJoinModelList() { // 新增表 ModelInputModel inputMaster = new ModelInputModel() { ModelCode = "tb_test", ModelName = "测试表" }; BaseResultModel <ModelOutputModel> resultMaster = this.ModelService.ModifyModel(inputMaster); Assert.IsTrue(resultMaster.IsSuccess, resultMaster.ErrorMessage); ModelInputModel inputSon = new ModelInputModel() { ModelCode = "tb_testDetail", ModelName = "测试子表" }; BaseResultModel <ModelOutputModel> resultSon = this.ModelService.ModifyModel(inputSon); Assert.IsTrue(resultSon.IsSuccess, resultSon.ErrorMessage); // 新增动态表字段 ModelDetailInputModel inputSonModel = new ModelDetailInputModel() { ColIndex = 1, ColMemo = "备注", ColName = "dynamicID", ColType = "nvarchar(256)", ModelID = resultSon?.Data?.ModelID }; BaseResultModel <ModelDetailOutputModel> resultSonDetail = this.ModelDetailService.ModifyModelDetail(inputSonModel); Assert.IsTrue(resultSonDetail.IsSuccess, resultSonDetail.ErrorMessage); // 新增动态表数据 string tempGuid = Guid.NewGuid() + string.Empty; TableSelModel selMasterTable = new TableSelModel() { TableName = inputMaster.ModelCode, ColSel = new List <TableColSelModel>() { new TableColSelModel() { ColName = "testID", ColValue = tempGuid } } }; BaseResultModel <int> resultMasterTab = this.ModelService.InsertDynamicModel(selMasterTable); Assert.IsTrue(resultMasterTab.IsSuccess, resultMasterTab.ErrorMessage); TableSelModel selSonTable = new TableSelModel() { TableName = inputSon.ModelCode, ColSel = new List <TableColSelModel>() { new TableColSelModel() { ColName = "dynamicID", ColValue = tempGuid } } }; BaseResultModel <int> resultSonTab = this.ModelService.InsertDynamicModel(selSonTable); Assert.IsTrue(resultSonTab.IsSuccess, resultSonTab.ErrorMessage); // 查询动态表分页 TableSelModel selTableList = new TableSelModel() { PageNo = 1, PageSize = 20, TableName = inputSon.ModelCode, JoinMasterTableName = inputMaster.ModelCode, WhereSel = new List <TableColSelModel>() { new TableColSelModel() { ColName = "dynamicID", ColValue = tempGuid } } }; BaseResultModel <ResultModel> resultTableList = this.ModelService.ListPageDynamicJoinModelList(selTableList); Assert.IsTrue(resultTableList.IsSuccess && resultTableList.Data.dataCount > 0, resultTableList.ErrorMessage); }