public PagedListModel <GL_MetricInfoDTO> QueryMetricInfoInfo(GL_MetricInfoDTO serchModel, Page page)
{
var query = from MetricInfo in DataContext.GL_MetricInfo
select new GL_MetricInfoDTO
{
Metric_UID = MetricInfo.Metric_UID,
Plant_Organization_UID = MetricInfo.Plant_Organization_UID,
Plant_Organization_Name = MetricInfo.System_Organization2.Organization_Name,
BG_Organization_UID = MetricInfo.BG_Organization_UID,
BG_Organization_Name = MetricInfo.System_Organization1.Organization_Name,
FunPlant_Organization_UID = MetricInfo.FunPlant_Organization_UID,
FunPlant_Organization_Name = MetricInfo.System_Organization.Organization_Name,
Metric_ID = MetricInfo.Metric_ID,
Metric_Name = MetricInfo.Metric_Name,
Modified_UID = MetricInfo.Modified_UID,
Modified_Date = MetricInfo.Modified_Date,
};
//厂区
if (serchModel.Plant_Organization_UID != 0)
{
query = query.Where(p => p.Plant_Organization_UID == serchModel.Plant_Organization_UID);
}
//OP
if (serchModel.BG_Organization_UID != 0)
{
query = query.Where(p => p.BG_Organization_UID == serchModel.BG_Organization_UID);
}
//功能厂
if (serchModel.FunPlant_Organization_UID != 0 && serchModel.FunPlant_Organization_UID != null)
{
query = query.Where(p => p.FunPlant_Organization_UID == serchModel.FunPlant_Organization_UID);
}
//会议ID
if (!string.IsNullOrEmpty(serchModel.Metric_ID))
{
query = query.Where(p => p.Metric_ID == serchModel.Metric_ID);
}
//会议名称
if (!string.IsNullOrEmpty(serchModel.Metric_Name))
{
query = query.Where(p => p.Metric_Name == serchModel.Metric_Name);
}
var totalCount = query.Count();
query = query.OrderByDescending(m => m.Modified_Date).GetPage(page);
return(new PagedListModel <GL_MetricInfoDTO>(totalCount, query.ToList()));
}
public string UpdateMetricInfo(GL_MetricInfoDTO updateModel)
{
try
{
var entityContext = GL_MetricInfoRepository.GetById(updateModel.Metric_UID);
entityContext.Metric_ID = updateModel.Metric_ID;
entityContext.Metric_Name = updateModel.Metric_Name;
GL_MetricInfoRepository.Update(entityContext);
_unitOfWork.Commit();
return("SUCCESS");
}
catch (Exception ex)
{
return("修改失败，错误信息" + ex.Message.ToString());
}
}
public string AddOrEditMetricInfo(GL_MetricInfoDTO dto, bool isEdit)
{
string errorMessage = string.Empty;
try
{
GL_MetricInfo entityContext;
if (dto.Metric_UID == 0)
{
//判断是否重复
var result = GL_MetricInfoRepository.GetMany(p => p.Plant_Organization_UID == dto.Plant_Organization_UID && p.BG_Organization_UID == dto.BG_Organization_UID && p.Metric_ID == dto.Metric_ID && p.Metric_Name == dto.Metric_Name);
if (result.Count() > 0)
{
return("填加的数据已经存在，请检查！");
}
else
{
entityContext = new GL_MetricInfo();
entityContext.Plant_Organization_UID = dto.Plant_Organization_UID;
entityContext.BG_Organization_UID = dto.BG_Organization_UID;
entityContext.FunPlant_Organization_UID = dto.FunPlant_Organization_UID;
entityContext.Metric_ID = dto.Metric_ID;
entityContext.Metric_Name = dto.Metric_Name;
entityContext.Modified_UID = dto.Modified_UID;
entityContext.Modified_Date = dto.Modified_Date;
GL_MetricInfoRepository.Add(entityContext);
_unitOfWork.Commit();
}
}
else
{
entityContext = GL_MetricInfoRepository.GetById(dto.Metric_UID);
entityContext.Metric_ID = dto.Metric_ID;
entityContext.Metric_Name = dto.Metric_Name;
GL_MetricInfoRepository.Update(entityContext);
_unitOfWork.Commit();
}
return("0");
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ex.Message);
}
}
public string AddMetricInfoInfo(GL_MetricInfoDTO addModel)
{
try
{
var sql = @"
[dbo].[GL_MetricInfo]
([Plant_Organization_UID]
,[BG_Organization_UID]
,[FunPlant_Organization_UID]
,[Metric_ID]
,[Metric_Name]
,[Modified_UID]
,[Modified_Date])
VALUES (
{0} ,
{1} ,
{2} ,
N'{3}' ,
N'{4}' ,
{5} ,
'{6}'
)";
sql = string.Format(sql,
addModel.Plant_Organization_UID,
addModel.BG_Organization_UID,
addModel.FunPlant_Organization_UID,
addModel.Metric_ID,
addModel.Metric_Name,
addModel.Modified_UID,
addModel.Modified_Date);
var result = DataContext.Database.ExecuteSqlCommand(sql.ToString());
if (result > 0)
{
return("SUCCESS");
}
else
{
return("添加失败");
}
}
catch (Exception ex)
{
return("添加失败: 错误信息" + ex.Message.ToString());
}
}
public string AddMetricInfoInfo(GL_MetricInfoDTO serchModel)
{
var result = GL_MetricInfoRepository.AddMetricInfoInfo(serchModel);
return(result);
}
public PagedListModel <GL_MetricInfoDTO> QueryMetricInfo(GL_MetricInfoDTO serchModel, Page page)
{
var result = GL_MetricInfoRepository.QueryMetricInfoInfo(serchModel, page);
return(result);
}
public string AddOrEditMetricInfoAPI(GL_MetricInfoDTO dto, bool isEdit)
{
var result = gL_Service.AddOrEditMetricInfo(dto, isEdit);
return(result);
}
public IHttpActionResult AddMetricInfoInfoAPI(GL_MetricInfoDTO updateModel)
{
var result = gL_Service.AddMetricInfoInfo(updateModel);
return(Ok(result));
}
public IHttpActionResult UpdateMetricInfoAPI(GL_MetricInfoDTO addModel)
{
var result = gL_Service.UpdateMetricInfo(addModel);
return(Ok(result));
}
