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