public JsonResult AddSql(ViewModel model) { if (SysUser != null) { model.INPUTER = SysUser.UserCode; } else { return(FailResult("未登录状态")); } var verifymodel = ModelVerify.First(model); if (verifymodel != null) { return(FailResult(verifymodel.ErrorMessage)); } if (model.COMMAND_TEXT.Length > 2000) { return(FailResult("该SQL超出长度")); } if (!string.IsNullOrEmpty(model.VIEW_NAME)) { if (sqlManager.IsExists(model.VIEW_NAME)) { return(FailResult("标题已存在,不可用")); } } if (!sqlManager.IsCorrect(model.COMMAND_TEXT)) { return(FailResult(sqlManager.PromptInfo.Message)); } Tsql_View daView = new Tsql_View() { ViewName = model.VIEW_NAME, ClassifyId = model.CLASSIFY_ID, CommandText = model.COMMAND_TEXT, ViewTemplate = model.VIEW_TEMPLATE, CacheStatus = model.CACHE_STATUS, PageRow = model.PAGE_ROW, Status = 1, Inputer = model.INPUTER, Remarks = model.REMARKS, }; if (!daView.Insert()) { return(FailResult(daView.PromptInfo.Message)); } else { //添加删除缓存数据 ViewFacade viewfacade = new ViewFacade(); viewfacade.AddOrUpdateCache(daView.ViewId, Convert.ToInt32(daView.CacheStatus), Isparameter(daView.CommandText)); } return(SuccessResult()); }
/// <summary> /// 验证表单提交数据合法性 /// </summary> /// <returns></returns> private bool SaveVerify(string groupName) { var verifyResult = ModelVerify.First(this, groupName); if (verifyResult != null) { Alert(ResultType.非法数值, verifyResult.ErrorMessage); return(false); } //TODO:其他的检查 return(true); }
/// <summary> /// 执行更新操作 /// </summary> /// <returns></returns> public bool Update() { if (_address == null) { Alert("收货地址信息不能为空"); return(false); } if (_address.Consignee == null) { _address.Consignee = new ConsigneeInfo(); } var vres0 = ModelVerify.Verify(_address, "update"); if (!vres0.IsSuccess) { Alert(vres0.Verifys.FirstOrDefault().ErrorMessage); return(false); } int addressId = _address.Address_Id; Tnet_Shipping_Address daShippingAddress = new Tnet_Shipping_Address(); if (!daShippingAddress.SelectByPk(addressId)) { Alert("收货地址信息不存在"); return(false); } if (_address.Owner_Id > 0 && daShippingAddress.Owner_Id != _address.Owner_Id) { Alert("操作不允许"); return(false); } _address.Owner_Id = daShippingAddress.Owner_Id; _address.Owner_Type = (Address_Owner_Type)daShippingAddress.Owner_Type; Tnet_Consignee daConsignee = new Tnet_Consignee(); if (!daConsignee.SelectByPk(daShippingAddress.Consignee_Id)) { Alert("收件人信息有误"); return(false); } //如果收货人信息传入null,表示不需要修改此项,则将已有的收货人信息写入 _address.Consignee Extend(_address.Consignee, daConsignee); var oldAddressId = _address.Address_Id; BeginTransaction(); ConsigneeCreationProvider creationProvider = new ConsigneeCreationProvider(_address); creationProvider.ReferenceTransactionFrom(Transaction); if (!creationProvider.Create()) { Rollback(); Alert("更新收货地址失败,请重试!"); return(false); } this._address = creationProvider.ShippingAddress;//new shipping address Commit(); OnSuccess(this._address); return(true); }