/// <summary> /// 新增公司信息数据 /// </summary> public AjaxResult InsertNew(List <TbCompany> cpy, bool isApi = false) { if (cpy == null) { return(AjaxResult.Warning("参数错误")); } try { List <TbCompany> data = Db.Context.From <TbCompany>().Select(TbCompany._.All).ToList(); using (DbTrans trans = Db.Context.BeginTransaction()) { //先删除原来的表 //Repository<TbCompany>.Delete(trans, data, isApi); Db.Context.FromSql("truncate table TbCompany").SetDbTransaction(trans).ExecuteNonQuery(); //插入从BM那边取过来的数据 Repository <TbCompany> .Insert(trans, cpy, isApi); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception e) { var err = e.ToString(); return(AjaxResult.Error(err)); } }
private Task HandleExceptionAsync(HttpContext context) { var statusCode = context.Response.StatusCode; var msg = "服务器内部错误"; switch (statusCode) { case 401: msg = "未授权"; break; case 404: msg = "未找到接口"; break; case 500: msg = "服务器内部错误"; break; } if (!_ex.IsStringEmpty()) { LogHelper.Error(context.Request.Path + _ex); } context.Response.ContentType = "application/json;charset=utf-8"; return(context.Response.WriteAsync(AjaxResult.Error <string>(statusCode, msg).ToString())); }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbSafeAccidentReport model, bool isApi = false) { if (model == null) { return(AjaxResult.Warning("参数错误")); } if (isApi == false) { model.BrowseCount = 0; model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; } model.ProjectId = "";//项目id不保存 try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbSafeAccidentReport> .Insert(trans, model, isApi); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
/// <summary> /// 保存管线信息(管线信息页面起止人井信息保存) /// </summary> /// <returns></returns> public ActionResult EditGxxx(FormCollection form) { try { var id = ConvertUtility.ToDecimal(form["Gxxxid"]); var model = gxxxBusiness.Find(id); if (model == null) { return(Json(AjaxResult.Error("请保存管线基本信息后再保存管线起止井信息"))); } GX_GXXX gxxx = new GX_GXXX(); gxxx = model; //起止井位置信息 gxxx.QJ = form["Qjszwz"]; gxxx.ZJ = form["Zjszwz"]; //起止井所在管孔位置 gxxx.QJGKWZ = form["gxszgkqjwz"]; gxxx.ZJGKWZ = form["gxszgkwz"]; gxxx.MODIFYBY = CurrentUser.UserName; gxxx.MODIFYTIME = DateTime.Now; gxxxBusiness.UpdateEntity(model); var ret = gxxxBusiness.SaveChange(); return(Json(ret > 0 ? AjaxResult.Success("数据操作成功") : AjaxResult.Error("数据操作失败"))); } catch (Exception ex) { return(Json(AjaxResult.Error("删除失败:" + (ex.InnerException != null ? ex.InnerException.Message : ex.Message)))); } }
/// <summary> /// 删除数据 /// </summary> public AjaxResult Delete(int keyValue) { try { //判断信息是否存在 var anyRet = AnyInfo(keyValue); if (anyRet.state != ResultType.success.ToString()) { return(anyRet); } using (DbTrans trans = Db.Context.BeginTransaction()) { //删除信息 var count = Repository <TbStockTaking> .Delete(trans, p => p.ID == keyValue); //删除明细信息 Repository <TbStockTakingItem> .Delete(trans, p => p.TakNum == ((TbStockTaking)anyRet.data).TakNum); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
public HttpResponseMessage GetMenuList(string RoleCode, string UserId) { try { var list = new List <TbSysMenuApp>(); //判断人员角色菜单 if (!string.IsNullOrEmpty(RoleCode)) { var roleMenuList = _sysMenu.GetCurrentMenuListByRoleCodeApp(RoleCode); if (roleMenuList.Count > 0) { list.AddRange(roleMenuList); } } //判断人员菜单 if (!string.IsNullOrEmpty(UserId)) { var userMenuList = _sysMenu.GetCurrentMenuListByUserCodeApp(UserId); if (userMenuList.Count > 0) { list.AddRange(userMenuList); } } //去重 list = list.Where((x, firstId) => list.FindIndex(z => z.MenuCode == x.MenuCode) == firstId).OrderBy(x => x.Sort).ToList(); string a = ToMenuJson(list, "0"); JArray ja = (JArray)JsonConvert.DeserializeObject(a); return(AjaxResult.Success(ja).ToJsonApi()); } catch (Exception) { return(AjaxResult.Error("获取App菜单失败").ToJsonApi()); } }
/// <summary> /// 根据key获得导航信息 /// </summary> /// <returns></returns> public JsonResult _GetSingleNav(string key = "", int limits = 5) { if (string.IsNullOrEmpty(key)) { return(Json(AjaxResult.Error("参数错误"))); } try { Navigation_S ns = _NavigationFacade.Value.GetNavByKey(key); List <Article_S> list = _ArticleFacade.Value.GetTopArticleByColumnID("70010004", 5); var result = new { obj = ns, data = list }; return(Json(AjaxResult.Success(result))); } catch (Exception ex) { return(Json(AjaxResult.Error(ex.Message))); } }
public void GetMapInfo(int id, string type) { try { var mapInfo = new MapDTO(); var service = new MapService(); switch (type) { case "scenic": //类似是景区 mapInfo = service.GetMapInfo(id); break; case "catering": //类似是餐饮 mapInfo = service.GetShop(id); break; case "hotel": //类似是酒店 mapInfo = service.GetHotel(id); break; } Context.Response.Write(AjaxResult.Success(mapInfo)); } catch (JsonException jsEx) { Context.Response.Write(AjaxResult.Error(jsEx.Message, jsEx.ErrorType)); } catch (Exception ex) { Context.Response.Write(AjaxResult.Error(ex.Message)); } }
public void GetMarkers(int wid) { try { //后台登陆的通过session获取wid Model.wx_userweixin model = Session["nowweixin"] as Model.wx_userweixin; if (model != null) { wid = model.id; } BLL.wx_travel_marker bll = new BLL.wx_travel_marker(); var markers = bll.GetModelList(string.Format("wid={0}", wid)); if (!markers.Any()) { Context.Response.Write(AjaxResult.Error("该微信帐号下未配置景点信息").ToCamelString()); return; } Context.Response.Write(AjaxResult.Success(markers).ToCamelString()); } catch { Context.Response.Write(AjaxResult.Error("获取景点信息失败").ToCamelString()); } }
/// <summary> /// 修改数据(单条) /// </summary> public AjaxResult Update(TbFormWindowsShowFields request) { if (request == null) { return(AjaxResult.Warning("参数错误")); } try { var model = Repository <TbFormWindowsShowFields> .First(p => p.PhysicalTableName == request.PhysicalTableName && p.FieldCode == request.FieldCode); if (model == null) { return(AjaxResult.Error("信息不存在")); } model.FieldCode = request.FieldCode; model.FieldName = request.FieldName; model.FieldShowOrder = request.FieldShowOrder; model.PhysicalTableName = request.PhysicalTableName; model.FieldIsShow = request.FieldIsShow; model.FieldWidth = request.FieldWidth; model.FormWindowsTableName = request.FormWindowsTableName; var count = Repository <TbFormWindowsShowFields> .Update(model); if (count > 0) { return(AjaxResult.Success()); } return(AjaxResult.Error()); } catch (Exception) { return(AjaxResult.Error()); } }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbDistributionDeclare model, List <TbDistributionDeclareItem> items) { if (model == null) { return(AjaxResult.Warning("参数错误")); } model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; model.Examinestatus = "未发起"; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbDistributionDeclare> .Insert(trans, model); //添加明细信息 Repository <TbDistributionDeclareItem> .Insert(trans, items); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error()); } }
/// <summary> /// 删除数据 /// </summary> public AjaxResult Delete(int keyValue) { try { //判断信息是否存在 var anyRet = AnyInfo(keyValue); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } using (DbTrans trans = Db.Context.BeginTransaction()) { //删除信息 var count = Repository <TbSettlementOrder> .Delete(trans, p => p.ID == keyValue); Repository <TbSettlementOrderDetail> .Delete(trans, p => p.SettlementCode == ((TbSettlementOrder)anyRet.data).SettlementCode); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbSettlementOrder model, List <TbSettlementOrderDetail> items, bool isApi = false) { if (model == null) { return(AjaxResult.Warning("参数错误")); } model.Examinestatus = "未发起"; model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 Repository <TbSettlementOrder> .Insert(trans, model, isApi); Repository <TbSettlementOrderDetail> .Insert(trans, items, isApi); trans.Commit(); return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
/// <summary> /// 修改公司信息数据 /// </summary> public AjaxResult Update(TbCompany cyp, bool isApi = false) { if (cyp == null) { return(AjaxResult.Warning("参数错误")); } try { //var model = MapperHelper.Map<TbCompany, TbCompany>(cyp); //var count = Repository<TbCompany>.Update(model,isApi); //if (count <= 0) //{ // return AjaxResult.Error(); //} Repository <TbCompany> .Update(cyp, d => d.CompanyCode == cyp.CompanyCode, isApi); return(AjaxResult.Success()); } catch (Exception e) { var err = e.ToString(); return(AjaxResult.Error(err)); } }
///// <summary> ///// 新增、修改 ///// </summary> ///// <param name="jdata"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage SaveCompanyData(string jdata) //{ // try // { // //{"type":"add","model":{"CompanyCode":"001003002","ParentCompanyCode":"001003","CompanyFullName":"二工区","Address":"广州市","IsEnable": 0,"OrgType":3}} // JObject jo = (JObject)JsonConvert.DeserializeObject(jdata); // string modelstr = jo["model"] == null ? "" : jo["model"].ToString(); // string type = jo["type"] == null ? "" : jo["type"].ToString(); // if (string.IsNullOrWhiteSpace(modelstr) || string.IsNullOrWhiteSpace(type)) // return AjaxResult.Error("参数错误").ToJsonApi(); // var model = JsonEx.JsonToObj<TbCompany>(modelstr); // if (type == "add") // { // var data = cit.Insert(model, true); // return data.ToJsonApi(); // } // else // { // var data = cit.Update(model, true); // return data.ToJsonApi(); // } // } // catch (Exception) // { // return AjaxResult.Error("操作失败").ToJsonApi(); // } //} ///// <summary> ///// 删除 ///// </summary> ///// <param name="keyValue"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage DeleteCompanyData(string companyCode) //{ // var data = cit.Delete(companyCode, true); // return data.ToJsonApi(); //} /// <summary> /// 获取组织机构地址 /// </summary> /// <returns></returns> public HttpResponseMessage GetCompanyList(string url) { try { var dataJson = Get(strBMUrl + url); JObject jo = (JObject)JsonConvert.DeserializeObject(dataJson); string modelstr = jo["data"] == null ? "" : jo["data"].ToString(); if (string.IsNullOrWhiteSpace(modelstr)) { return(AjaxResult.Error("参数错误").ToJsonApi()); } DataTable dt = ToDataTable(modelstr); dt.Columns["OrgId"].ColumnName = "CompanyCode"; dt.Columns["OrgName"].ColumnName = "CompanyFullName"; dt.Columns["ParentOrgId"].ColumnName = "ParentCompanyCode"; dt.Columns["Address"].ColumnName = "Address"; dt.Columns["OrgType"].ColumnName = "OrgType"; DataColumn dc = new DataColumn("IsEnable", typeof(int)); dc.DefaultValue = 0; dt.Columns.Add(dc); List <TbCompany> model = ModelConvertHelper <TbCompany> .ToList(dt); var data = cit.InsertNew(model, true); return(AjaxResult.Success(data).ToJsonApi()); } catch (Exception) { return(AjaxResult.Error("操作失败").ToJsonApi()); } }
public void GetOpenId(string code, int wid, string url) { string openid = string.Empty; try { if (Session["openid"] == null) { BLL.wx_userweixin bll = new BLL.wx_userweixin(); Model.wx_userweixin wxModel = bll.GetModel(wid); openid = OAuth2BaseProc(wxModel, "OpenId", code, url); if (!string.IsNullOrEmpty(openid)) { Session["openid"] = openid; } } Context.Response.Write(AjaxResult.Success(openid).ToCamelString()); } catch (UnAuthException oEx) { Context.Response.Write(AjaxResult.Error(oEx.RedirectUrl, oEx.Code).ToCamelString()); } catch (Exception ex) { Context.Response.Write(AjaxResult.Error("获取OpenID失败。").ToCamelString()); } }
///// <summary> ///// 新增、修改 ///// </summary> ///// <param name="jdata"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage SaveUserData(string jdata) //{ // try // { // //{"type":"edit","model":{"UserCode":"zhangqiang","UserName":"******","UserPwd":"dEu7vwkYjTA=","UserSex":"男","UserClosed":"在职","MobilePhone":"15726831456","IDNumber":"500228199210264578","CompanyCode ":"001003002","DepartmentCode":"BM17"}} // JObject jo = (JObject)JsonConvert.DeserializeObject(jdata); // string modelstr = jo["model"] == null ? "" : jo["model"].ToString(); // string type = jo["type"] == null ? "" : jo["type"].ToString(); // if (string.IsNullOrWhiteSpace(modelstr) || string.IsNullOrWhiteSpace(type)) // return AjaxResult.Error("参数错误").ToJsonApi(); // var model = JsonEx.JsonToObj<TbUser>(modelstr); // if (type == "add") // { // var data = ui.Insert(model, true); // return data.ToJsonApi(); // } // else // { // var data = ui.Update(model, true); // return data.ToJsonApi(); // } // } // catch (Exception) // { // return AjaxResult.Error("操作失败").ToJsonApi(); // } //} ///// <summary> ///// 删除 ///// </summary> ///// <param name="keyValue"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage DeleteUserData(string userCode) //{ // var data = ui.DeleteNew(userCode, true); // return data.ToJsonApi(); //} /// <summary> /// 获取用户地址 /// </summary> /// <returns></returns> public HttpResponseMessage GetUserList(string url) { try { var dataJson = Get(strBMUrl + url); //JObject jo = (JObject)JsonConvert.DeserializeObject(dataJson); //string modelstr = jo["data"] == null ? "" : jo["data"].ToString(); //if (string.IsNullOrWhiteSpace(modelstr)) // return AjaxResult.Error("参数错误").ToJsonApi(); //DataTable dt = ToDataTable(modelstr); //dt.Columns["UserAccount"].ColumnName = "UserCode"; //dt.Columns["type"].ColumnName = "UserType"; //DataColumn dc = new DataColumn("UserClosed", typeof(string)); //dc.DefaultValue = "在职"; //dt.Columns.Add(dc); //DataColumn dc1 = new DataColumn("CreateTime", typeof(DateTime)); //dc1.DefaultValue = DateTime.Now; //dt.Columns.Add(dc1); //List<TbUser> model = ModelConvertHelper<TbUser>.ToList(dt); var requestUserList = JsonEx.JsonToObj <RequestUserModel>(dataJson); if (requestUserList.data == null) { return(AjaxResult.Success().ToJsonApi()); } var model = MapperHelper.Map <RequestUserListModel, TbUser>(requestUserList.data); var data = ui.InsertNew(model, true); return(data.ToJsonApi()); } catch (Exception) { return(AjaxResult.Error("操作失败").ToJsonApi()); } }
public HttpResponseMessage GetAllProjectOrg(string UserId) { string UserCode = UserId; if (!string.IsNullOrWhiteSpace(UserCode)) { var list = _User.GetAllProjectOrg(UserCode); var treeList = new List <TreeGridModel>(); foreach (var item in list) { bool hasChildren = list.Count(p => p.ProjectId == item.OrgId) == 0 ? false : true; TreeGridModel treeModel = new TreeGridModel(); treeModel.id = item.OrgId; treeModel.text = item.OrgName; treeModel.isLeaf = hasChildren; treeModel.parentId = item.ProjectId; treeModel.expanded = true; treeModel.entityJson = item.ToJson(); treeList.Add(treeModel); } JObject jo = (JObject)Newtonsoft.Json.JsonConvert.DeserializeObject(treeList.TreeGridJson());//将string转换为json对象 return(AjaxResult.Success(jo).ToJsonApi()); } else { return(AjaxResult.Error("接口信息错误:参数错误").ToJsonApi()); } }
/// <summary> /// 多文件删除(单个删除) /// </summary> /// <param name="fileValue">fileId$fileName</param> /// <returns></returns> public JsonResult DeleteUploaderFile(string id) { CasAttachmentEntity casAttachmentEntity = new CasAttachmentEntity { AttachmentId = id }; casAttachmentEntity = DataAccess.SelectSingle(casAttachmentEntity); string orginalFilePath = string.Empty;//原始文件路径 if (casAttachmentEntity == null) { return(Json(AjaxResult.Error("删除失败:数据库没有该文件"), JsonRequestBehavior.AllowGet)); } bool flag = BusinessDataService.CommonHelperService.DeleteFile(id); if (flag) { //删除磁盘文件 if (!string.IsNullOrEmpty(casAttachmentEntity.FilePath)) { DeleteFile(Server.MapPath(casAttachmentEntity.FilePath)); } if (string.IsNullOrEmpty(casAttachmentEntity.PdfFilePath)) { DeleteFile(Server.MapPath(casAttachmentEntity.PdfFilePath)); } } return(Json(flag ? AjaxResult.Success() : AjaxResult.Error("删除失败"), JsonRequestBehavior.AllowGet)); }
public HttpResponseMessage SubmitForm([FromBody] JObject jdata) { try { string modelstr = jdata["model"] == null ? "" : jdata["model"].ToString(); string type = jdata["type"] == null ? "" : jdata["type"].ToString(); if (string.IsNullOrWhiteSpace(modelstr) || string.IsNullOrWhiteSpace(type)) { return(AjaxResult.Error("参数错误").ToJsonApi()); } var model = JsonEx.JsonToObj <TbArticle>(modelstr); if (type == "add") { model.InsertTime = DateTime.Now; var data = _article.Insert(model, true); return(data.ToJsonApi()); } else { var data = _article.Update(model, true); return(data.ToJsonApi()); } } catch (Exception) { return(AjaxResult.Error("操作失败").ToJsonApi()); } }
public ActionResult EditJbxx(FormCollection form, GX_GXXX gxxx) { var id = ConvertUtility.ToDecimal(form["Gxxxid"]); var model = gxxxBusiness.Find(id); if (model == null) { return(Json(AjaxResult.Error("未找到需要更新的数据"))); } gxxx.XMYSXXID = ConvertUtility.ToDecimal(form["ysid"]); gxxx.GCBH = form["GXBH"]; gxxx.GXWZ = form["GXWZ"]; gxxx.GXCD = ConvertUtility.ToDecimal(form["GXCD"]); gxxx.DXLX = form["DXLX"]; gxxx.GXLX = form["GXLX"]; gxxx.JSZT = form["JSZT"]; gxxx.YWLX = form["YWLX"]; gxxx.GJZ = form["GJZ"]; gxxx.XNZC = form["XNZC"]; gxxx.GKCL = form["GKCL"]; gxxx.SYZT = ConvertUtility.ToDecimal(form["SYZT"]); gxxx.GKHS = ConvertUtility.ToDecimal(form["GKHS"]); gxxx.GKLS = ConvertUtility.ToDecimal(form["GCBH"]); gxxx.PLSX = ConvertUtility.ToDecimal(form["GCBH"]); gxxx.GXZT = form["GCBH"]; gxxx.MODIFYBY = CurrentUser.UserName; gxxx.MODIFYTIME = DateTime.Now; gxxxBusiness.UpdateEntity(gxxx); ViewData["GxxxId"] = gxxx.ID; return(Json(gxxxBusiness.SaveChange() > 0 ? AjaxResult.Success("数据操作成功!") : AjaxResult.Error("数据操作失败!"))); }
public HttpResponseMessage UploadFile([FromBody] JObject quePara) { if (quePara == null) { return(AjaxResult.Error("文件不能为空").ToJsonApi()); } string file = quePara["file"] == null ? "" : quePara["file"].ToString(); string fileName = quePara["fileName"] == null ? "" : quePara["fileName"].ToString(); if (string.IsNullOrEmpty(file)) { return(AjaxResult.Error("文件不能为空").ToJsonApi()); } try { var files = new List <FileData>(); files.Add(new FileData { file = file, fileName = fileName }); var retFile = base.UploadFileData(files); if (retFile == null) { return(AjaxResult.Error("图片上传失败").ToJsonApi()); } return(AjaxResult.Success(retFile.Item1).ToJsonApi()); } catch (Exception ex) { return(AjaxResult.Error("发生错误").ToJsonApi()); } }
/// <summary> /// 保存管孔信息 /// </summary> /// <returns></returns> public ActionResult EditGkxx(FormCollection form) { if (string.IsNullOrEmpty(form["gkhsParent"]) || string.IsNullOrEmpty(form["gklsParent"])) { AjaxResult.Error("请选择管孔所在位置!"); } var id = ConvertUtility.ToDecimal(form["GkxxId"]); var gkxx = gxxxBusiness.FindGkxx(id); if (gkxx == null) { AjaxResult.Error("未找到需要更新的数据!"); } gkxx.GKBH = form["GKXX"]; gkxx.GKCL = form["GKXXGKCL"]; gkxx.SYZT = ConvertUtility.ToDecimal(form["GKXXSYZT"]); gkxx.ZKHS = ConvertUtility.ToDecimal(form["GKHS1"]); gkxx.ZKLS = ConvertUtility.ToDecimal(form["GKLS1"]); gkxx.ZKSL = ConvertUtility.ToDecimal(form["GXSL"]); gkxx.GKSZH = ConvertUtility.ToDecimal(form["gkhsParent"]); gkxx.GKSZL = ConvertUtility.ToDecimal(form["gklsParent"]); gkxx.MODIFYBY = CurrentUser.UserName; gkxx.MODIFYTIME = DateTime.Now; gxxxBusiness.UpdateGkxx(gkxx); return(Json(gxxxBusiness.SaveChange() > 0 ? AjaxResult.Success("数据操作成功!") : AjaxResult.Error("数据操作失败!"))); }
/// <summary> /// 新增数据(单条) /// </summary> public AjaxResult InsertNew(List <TbUserRole> userroleList, bool isApi = false) { if (userroleList == null) { return(AjaxResult.Warning("参数错误")); } try { List <TbUserRole> data = Db.Context.From <TbUserRole>().Select(TbUserRole._.All).ToList(); using (DbTrans trans = Db.Context.BeginTransaction()) { //先删除原来的表 Db.Context.FromSql("truncate table TbUserRole").SetDbTransaction(trans).ExecuteNonQuery(); Repository <TbUserRole> .Insert(trans, userroleList, isApi); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception) { return(AjaxResult.Error("操作失败")); } }
/// <summary> /// 新增数据 /// </summary> public AjaxResult Insert(TbStockTaking model, List <TbStockTakingItem> items) { if (model == null) { return(AjaxResult.Warning("参数错误")); } model.InsertUserCode = OperatorProvider.Provider.CurrentUser.UserCode; try { using (DbTrans trans = Db.Context.BeginTransaction()) { //添加信息 var id = Repository <TbStockTaking> .Insert(trans, model); //添加明细信息 Repository <TbStockTakingItem> .Insert(trans, items); trans.Commit(); return(AjaxResult.Success(id)); } } catch (Exception ex) { return(AjaxResult.Error()); } }
/// <summary> /// 修改数据(单条) /// </summary> public AjaxResult Update(TbUserRoleRequset request) { if (request == null) { return(AjaxResult.Warning("参数错误")); } try { var model = MapperHelper.Map <TbUserRoleRequset, TbUserRole>(request); if (model == null) { return(AjaxResult.Warning("信息不存在")); } var count = TbUserRoleRepository.Update(model); if (count > 0) { return(AjaxResult.Success()); } return(AjaxResult.Error("操作失败")); } catch (Exception) { return(AjaxResult.Error("操作失败")); } }
/// <summary> /// 删除数据 /// </summary> public AjaxResult Delete(int keyValue) { try { //判断信息是否存在 var anyRet = AnyInfo(keyValue); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } using (DbTrans trans = Db.Context.BeginTransaction()) { //删除预警节点、节点人员配置 var count = Repository <TbFormEarlyWarningNode> .Delete(trans, p => p.ID == keyValue); Repository <TbFormEarlyWarningNodePersonnel> .Delete(trans, p => p.MenuCode == ((TbFormEarlyWarningNode)anyRet.data).MenuCode && p.EWNodeCode == ((TbFormEarlyWarningNode)anyRet.data).EWNodeCode); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
public AjaxResult Upload() { if (Request.Form.Files.Count != 1) { return(AjaxResult.Error("上传失败")); } var file = Request.Form.Files[0]; var filename = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"'); string newfilename = System.Guid.NewGuid().ToString() + "." + GetFileExt(filename); string impath = hostingEnvironment.WebRootPath + "//uploadfile"; if (!Directory.Exists(impath)) { Directory.CreateDirectory(impath); } string newfile = impath + $@"//{newfilename}"; using (FileStream fs = System.IO.File.Create(newfile)) { file.CopyTo(fs); fs.Flush(); } string url = "/uploadfile/" + newfilename; return(AjaxResult.Success(data: url)); }
/// <summary> /// 修改数据 /// </summary> public AjaxResult Update(TbSafeAccidentReport model, bool isApi = false) { if (model == null) { return(AjaxResult.Warning("参数错误")); } var anyRet = AnyInfo(model.ID); if (anyRet.state.ToString() != ResultType.success.ToString()) { return(anyRet); } model.ProjectId = "";//项目id不保存 try { using (DbTrans trans = Db.Context.BeginTransaction())//使用事务 { //修改信息 Repository <TbSafeAccidentReport> .Update(trans, model, p => p.ID == model.ID, isApi); trans.Commit();//提交事务 return(AjaxResult.Success()); } } catch (Exception ex) { return(AjaxResult.Error(ex.ToString())); } }
/// <summary> /// 新增公司信息数据 /// </summary> public AjaxResult Insert(TbCompany cpy, bool isApi = false) { if (cpy == null) { return(AjaxResult.Warning("参数错误")); } if (cpy.ParentCompanyCode == "0") { var num = JudgeExist(); if (num > 0) { return(AjaxResult.Warning("父级(顶级)公司只能存在一个!")); } } try { //var model = MapperHelper.Map<TbCompany, TbCompany>(cpy); //var count = Repository<TbCompany>.Insert(model,isApi); //if (count <= 0) // return AjaxResult.Error(); Repository <TbCompany> .Insert(cpy, isApi); return(AjaxResult.Success()); } catch (Exception e) { var err = e.ToString(); return(AjaxResult.Error(err)); } }