/// <summary> /// 编辑时,获取指定信息;还有显示详细信息Detail /// </summary> /// <param name="Id"></param> /// <returns></returns> public Bus_EffciencyComplain GetModel(string Id) { var tempModel = LoadEntities(t => t.ID == Id).FirstOrDefault(); if (tempModel == null) { return(new Bus_EffciencyComplain()); } Bus_EffComplExeResService attributeService = new Bus_EffComplExeResService(); var attrList = from a in attributeService.LoadEntities(a => a.ExecuteResId == Id) //join l in langService.LoadEntities(l => l.TABLE_NAME == "Bus_EffComplExeRes_ExecuteResIdItem") on a.ExecuteResId equals l.ID join l in langService.LoadEntities(l => l.TABLE_NAME == "Bus_EffComplExeRes_ExecuteResIdItem") on a.ExecuteResIdItem equals l.ID select new { ID = a.ID, ExecuteResId = a.ExecuteResId, ExecuteResIdItem = a.ExecuteResIdItem, ExecuteResIdItemName = l.COLUMN_NAME }; List <Bus_EffComplExeRes> list = new List <Bus_EffComplExeRes>(); foreach (var item in attrList) { Bus_EffComplExeRes obj = new Bus_EffComplExeRes(); obj.ID = item.ID; obj.ExecuteResId = item.ExecuteResId; obj.ExecuteResIdItem = item.ExecuteResIdItem; obj.ExecuteResIdItemName = item.ExecuteResIdItemName; list.Add(obj); } if (list != null) { tempModel.AttrList = list; } var comp = langService.GetModel("Bus_EffciencyComplain_CompanyInfoId", tempModel.CompanyInfoId); var comper = langService.GetModel("Bus_EffciencyComplain_CompanyPerId", tempModel.CompanyPerId); var sourceObj = langService.GetModel("Bus_EffciencyComplain_ComplainFrmSource", tempModel.ComplainFrmSourceId); var typeObj = langService.GetModel("Bus_TakeErrorAttribute_AttributeIDItem", tempModel.ComplainType); // var overObj = langService.GetModel("Bus_TakeError_OverQuality", tempModel.OverQuality); if (comp != null) { tempModel.CompanyInfoIdName = comp.COLUMN_NAME; } if (comper != null) { tempModel.CompanyPerIdName = comper.COLUMN_NAME; } if (sourceObj != null) { tempModel.ComplainFrmSourceIdName = sourceObj.COLUMN_NAME; } if (typeObj != null) { tempModel.ComplainTypeName = typeObj.COLUMN_NAME; } // if (overObj != null) { tempModel.OverQualityName = overObj.COLUMN_NAME; } return(tempModel); }
/// <summary> /// 修改或者添加一条数据 /// </summary> /// <param name="model">实体参数</param> /// <returns>大于0,操作成功,反之失败</returns> public int OperateModel(Bus_EffciencyComplain model) { if (!string.IsNullOrEmpty(model.ID) && model.ID.Length == 36) { //编辑 var existModel = this.LoadEntities(t => t.ID == model.ID).FirstOrDefault(); existModel.CompanyInfo = model.CompanyInfo; existModel.CompanyInfoId = model.CompanyInfoId; existModel.CompanyPerId = model.CompanyPerId; existModel.OtherPer = model.OtherPer; existModel.ComplainFrmSourceId = model.ComplainFrmSourceId; existModel.ComplainAcceptTime = model.ComplainAcceptTime; existModel.DelFlag = 0; existModel.ComplainCode = model.ComplainCode; existModel.ComplainProfileContent = model.ComplainProfileContent; existModel.ComplainType = model.ComplainType; existModel.IsOverTime = model.IsOverTime; existModel.IsSearch = model.IsSearch; existModel.MassesSatisfy = model.MassesSatisfy; existModel.LevelRecords = model.LevelRecords; existModel.Phone = model.Phone; existModel.AreaCode = model.AreaCode; existModel.Tel = model.Tel; existModel.ComplainAreaCode = model.ComplainAreaCode; existModel.ComplainTel = model.ComplainTel; #region 修改处理情况 var existExecuteRes = DbSession.Bus_EffComplExeResRepository.LoadEntities(ur => ur.ExecuteResId == existModel.ID); //删除现有数据 foreach (var item in existExecuteRes) { DbSession.Bus_EffComplExeResRepository.DeleteEntity(item); } if (model.ExecuteResIds != null) { foreach (var attrId in model.ExecuteResIds) { Bus_EffComplExeRes attrModel = new Bus_EffComplExeRes(); attrModel.ID = Guid.NewGuid().ToString(); attrModel.ExecuteResId = existModel.ID; attrModel.ExecuteResIdItem = attrId; DbSession.Bus_EffComplExeResRepository.AddEntity(attrModel); } } #endregion } else if (string.IsNullOrEmpty(model.ID)) { //添加 var addModel = new Bus_EffciencyComplain(); addModel.ID = Guid.NewGuid().ToString(); addModel.CompanyInfo = model.CompanyInfo; addModel.CompanyInfoId = model.CompanyInfoId; addModel.CompanyPerId = model.CompanyPerId; addModel.OtherPer = model.OtherPer; addModel.ComplainFrmSourceId = model.ComplainFrmSourceId; addModel.ComplainAcceptTime = model.ComplainAcceptTime; addModel.DelFlag = 0; addModel.ComplainCode = model.ComplainCode; addModel.ComplainProfileContent = model.ComplainProfileContent; addModel.ComplainType = model.ComplainType; addModel.IsOverTime = model.IsOverTime; addModel.IsSearch = model.IsSearch; addModel.MassesSatisfy = model.MassesSatisfy; addModel.LevelRecords = model.LevelRecords; addModel.UserId = model.UserId; addModel.CreateTime = DateTime.Now; addModel.Creator = model.UserId; addModel.Phone = model.Phone; addModel.AreaCode = model.AreaCode; addModel.Tel = model.Tel; addModel.ComplainAreaCode = model.ComplainAreaCode; addModel.ComplainTel = model.ComplainTel; DbSession.Bus_EffciencyComplainRepository.AddEntity(addModel); #region 新增处理情况 //添加 if (model.ExecuteResIds != null) { foreach (var attrId in model.ExecuteResIds) { Bus_EffComplExeRes attrModel = new Bus_EffComplExeRes(); attrModel.ID = Guid.NewGuid().ToString(); attrModel.ExecuteResId = addModel.ID; attrModel.ExecuteResIdItem = attrId; DbSession.Bus_EffComplExeResRepository.AddEntity(attrModel); } } #endregion } return(DbSession.SaveChange()); }