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