public string EditRepair(RepairRecord repair)
{
try
{
if (repair.Status == "P")
{
repair.Status = "O";
}
else if (repair.Status == "O")
{
repair.Status = "D";
}
else
{
repair.Status = "N";
}
var result = RestProxy.RepairRecordServiceProxy.Edit(repair);
if (result.HasError)
{
return("修改失败:" + result.Errors[0].ErrorMessage);
}
else
{
return("修改成功");
}
}
catch (RestException ex)
{
return("系统异常:" + ex.Message);
}
}
public DataResult GetReportLog([FromQuery] DateTime startTime, DateTime endTime, string account, int qId, int state = -1)
{
var field = RepairRecord.GetField(new List <string> {
"DeviceCode"
}, "a.");
var sql =
$"SELECT a.*, b.FaultTypeName, b.FaultDescription, IFNULL(c.`Name`, '') `Name`, IFNULL(c.`Account`, '') `Account`, IFNULL(c.`Phone`, '') `Phone`, IFNULL(d.`FaultTypeName`, '') `FaultTypeName1`, IFNULL(d.`FaultDescription`, '') `FaultDescription1` " +
$"FROM (SELECT {field}, IFNULL(b.`Code`, a.DeviceCode) DeviceCode FROM `fault_device_repair` a LEFT JOIN `device` b ON a.DeviceId = b.Id) a JOIN `fault_type` b ON a.FaultTypeId = b.Id " +
$"LEFT JOIN (SELECT * FROM (SELECT * FROM maintainer ORDER BY MarkedDelete) a GROUP BY a.Account) c ON a.Maintainer = c.Account " +
$"LEFT JOIN `fault_type` d ON a.FaultTypeId1 = d.Id ";
sql += $" WHERE a.FaultTime >= @startTime AND a.FaultTime <= @endTime AND " +
$"{(state == -1 ? "" : "`State` = @state AND ")}" +
$"{(account.IsNullOrEmpty() ? "" : "`Proposer` = @account AND ")}" +
$"{(qId == 0 ? "" : "a.Id = @qId AND ")}" + " a.MarkedDelete = 0 AND a.IsAdd = 1;";
var result = new DataResult();
result.datas.AddRange(ServerConfig.ApiDb.Query <RepairRecordDetail>(sql, new { startTime, endTime, state, account, qId })
.OrderByDescending(x => x.FaultTime));
if (qId != 0 && !result.datas.Any())
{
result.errno = Error.RepairRecordNotExist;
return(result);
}
return(result);
}
public string CreateRecord(string body)
{
RepairRecord repairRecord = JSONHelper.JSONToObject <RepairRecord>(body);
RepairRecord result = repairService.CreateRecord(repairRecord);
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(result)));
}
/// <summary>
/// 创建一条维修记录
/// </summary>
/// <param name="record">工夹具类</param>
/// <returns>RepairRecord</returns>
public RepairRecord CreateRecord(RepairRecord record)
{
record.GmtCreate = DateTime.Now.ToLocalTime();
record.GmtModified = DateTime.Now.ToLocalTime();
repairRecordDao.insertRepairRecord(record);
return(record);
}
public static RestServiceResponse Add(RepairRecord repairRecord)
{
return(new ServiceClientBase("operate-repair-record").Call <RestServiceResponse <RepairRecord> >(new RestServiceRequest <RepairRecord>()
{
Body = repairRecord,
ActionName = "Add"
}));
}
/// <summary>
/// 维修请求方法
/// </summary>
/// <param name="repairRecord"></param>
/// <returns></returns>
public RepairRecord MaintainRequest(RepairRecord repairRecord)
{
repairRecord.GmtCreate = DateTime.Now.ToLocalTime();
repairRecord.GmtModified = DateTime.Now.ToLocalTime();
repairRecord.Status = 0;
if (repairRecordDao.updateRepairRecord(repairRecord) == 1)
{
return(repairRecord);
}
return(null);
}
/// <summary>
/// 更新维修记录状态方法
/// </summary>
/// <param name="repairRecord"></param>
/// <param name="status"></param>
/// <returns></returns>
public RepairRecord UpdateRepairRecordStatus(RepairRecord repairRecord, int status)
{
repairRecord.GmtCreate = DateTime.Now.ToLocalTime();
repairRecord.GmtModified = DateTime.Now.ToLocalTime();
repairRecord.Status = status;
if (repairRecordDao.updateRepairRecord(repairRecord) == 1)
{
return(repairRecord);
}
return(null);
}
public string GetNotCompleteRecord()
{
string token = TokenHelper.GetTokenJson(HttpContext.Request.Headers["Authorization"]);//利用这个进行数据按部门进行隔离
TokenInfo tokenInfo = JSONHelper.JSONToObject <TokenInfo>(token);
int WorkcellId = tokenInfo.workCell;
RepairRecord repairRecord = new RepairRecord();
repairRecord.WorkcellId = WorkcellId;
List <RepairRecord> result = repairService.GetNotCompleteRecord(repairRecord);
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(result)));
}
public string MaintainStatus(int id, int status, string body)
{
RepairRecord repairRecord = JSONHelper.JSONToObject <RepairRecord>(body);
repairRecord.Id = id;
RepairRecord res = fixtureService.UpdateRepairRecordStatus(repairRecord, status);
if (res != null)
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(res)));
}
else
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Fail()));
}
}
public string UpdateRecord(int id, string body)
{
RepairRecord repairRecord = JSONHelper.JSONToObject <RepairRecord>(body);
repairRecord.Id = id;
RepairRecord result = repairService.UpdateRecord(repairRecord);
if (result != null)
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(result)));
}
else
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Fail()));
}
}
public string DeleteRecordById(int id)
{
RepairRecord repairRecord = new RepairRecord();
repairRecord.Id = id;
int result = repairService.DeleteRecordById(repairRecord);
if (result == 1)
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok()));
}
else
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Fail()));
}
}
public string MaintainEntity(int id, string body)
{
RepairRecord repairRecord = JSONHelper.JSONToObject <RepairRecord>(body);
repairRecord.Id = id;
RepairRecord res = fixtureService.MaintainRequest(repairRecord);
if (res != null)
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(res)));
}
else
{
return(null);
}
}
public Result PostRepairRecord([FromBody] RepairRecord repairRecord)
{
int cnt;
if (repairRecord.DeviceId == 0)
{
cnt = ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `device` WHERE `Code` = @Code AND `MarkedDelete` = 0;", new { Code = repairRecord.DeviceCode }).FirstOrDefault();
if (cnt > 0)
{
return(Result.GenError <Result>(Error.ReportDeviceCodeIsExist));
}
}
cnt = ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `fault_type` WHERE Id = @id AND MarkedDelete = 0;", new { id = repairRecord.FaultTypeId1 }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.FaultTypeNotExist));
}
var createUserId = Request.GetIdentityInformation();
if (!repairRecord.Maintainer.IsNullOrEmpty())
{
cnt =
ServerConfig.ApiDb.Query <int>("SELECT COUNT(1) FROM `maintainer` WHERE Account = @Account AND `MarkedDelete` = 0;", new { Account = repairRecord.Maintainer }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.MaintainerNotExist));
}
}
var device = ServerConfig.ApiDb.Query <DeviceDetail>("SELECT * FROM `device` WHERE Id = @DeviceId AND MarkedDelete = 0;;",
new { DeviceId = repairRecord.DeviceId }).FirstOrDefault();
repairRecord.CreateUserId = createUserId;
repairRecord.Administrator = device?.Admin ?? "";
repairRecord.DeviceCode = device?.Code ?? repairRecord.DeviceCode;
repairRecord.Maintainer = repairRecord.Maintainer ?? "";
repairRecord.State = RepairStateEnum.Complete;
repairRecord.IsAdd = true;
ServerConfig.ApiDb.Execute(
"INSERT INTO fault_device_repair (`CreateUserId`, `DeviceId`, `DeviceCode`, `FaultTime`, `Proposer`, `Supplement`, `Priority`, `Grade`, `State`, `FaultSolver`, `SolveTime`, `SolvePlan`, `FaultTypeId`, `FaultTypeId1`, `IsAdd`, `Administrator`, `Maintainer`) " +
"VALUES (@CreateUserId, @DeviceId, @DeviceCode, @FaultTime, @Proposer, @Supplement, @Priority, @Grade, @State, @FaultSolver, @SolveTime, @SolvePlan, @FaultTypeId, @FaultTypeId1, @IsAdd, @Administrator, @Maintainer);",
repairRecord);
return(Result.GenError <Result>(Error.Success));
}
//public CResult<List<WebRepairRecord>> GetRepairRecordListByDeviceID(string deviceID, out int totalCount, string searchInfo, int pageIndex = 1, int pageSize = 10, string orderby = null, bool ascending = false)
//{
// LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
// LogHelper.Info("deviceID", deviceID);
// using (DeviceMgmtEntities context = new DeviceMgmtEntities())
// {
// Expression<Func<RepairRecord, bool>> filter = t => t.DeviceID == deviceID && t.IsValid == true;
// if (string.IsNullOrWhiteSpace(searchInfo) == false)
// {
// searchInfo = searchInfo.Trim().ToUpper();
// filter = filter.And(t => t.Note.ToUpper().Contains(searchInfo));
// }
// var temp = context.RepairRecord.Where(filter).Page(out totalCount, pageIndex, pageSize, orderby, ascending, true);
// var result = temp.Select(t => new WebRepairRecord()
// {
// ID = t.ID,
// Note = t.Note,
// DeviceID = t.DeviceID,
// DeviceName = t.Device.Name,
// Operator = t.Operator,
// RepairDate = t.RepairDate,
// CreateDate = t.CreateDate,
// CreateUserID = t.CreateUserID,
// CreateUserName = t.User.Name,
// ProjectID = t.ProjectID
// }).ToList();
// LogHelper.Info("result", result);
// return new CResult<List<WebRepairRecord>>(result);
// }
//}
public CResult <string> InsertRepairRecord(WebRepairRecord model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ProjectID))
{
return(new CResult <string>(string.Empty, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
if (context.Project.Any(t => t.IsValid && t.ID == model.ProjectID) == false)
{
return(new CResult <string>(string.Empty, ErrorCode.ProjectNotExist));
}
if (context.Device.Any(t => t.ID == model.DeviceID) == false)
{
return(new CResult <string>(string.Empty, ErrorCode.DeviceNotExist));
}
var entity = new RepairRecord();
entity.CreateDate = DateTime.Now;
entity.CreateUserID = model.CreateUserID;
entity.ID = Guid.NewGuid().ToString();
entity.RepairDate = model.RepairDate;
entity.IsValid = true;
entity.Note = model.Note;
entity.ProjectID = model.ProjectID;
entity.Operator = model.Operator;
entity.DeviceID = model.DeviceID;
entity.Solution = model.Solution;
entity.Describe = model.Describe;
context.RepairRecord.Add(entity);
if (context.SaveChanges() > 0)
{
return(new CResult <string>(entity.ID));
}
else
{
return(new CResult <string>("", ErrorCode.SaveDbChangesFailed));
}
}
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public int DeleteRecordById(RepairRecord record)
{
RepairRecord repairRecord = repairRecordDao.selectRepairRecordById(record);
repairRecord.GmtModified = DateTime.Now.ToLocalTime();
repairRecordDao.updateRepairRecord(repairRecord);
int temp = repairRecordDao.deleteRepairRecordById(record);
if (temp == 1)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 修改一条维修记录
/// </summary>
/// <param name="id">id</param>
/// <param name="record">id</param>
/// <returns>RepairRecord</returns>
public RepairRecord UpdateRecord(RepairRecord record)
{
RepairRecord repairRecord = repairRecordDao.selectRepairRecordById(record);
record.GmtCreate = repairRecord.GmtCreate;
record.GmtModified = DateTime.Now.ToLocalTime();
int result = repairRecordDao.updateRepairRecord(record);
if (result == 0)
{
return(null);
}
else
{
return(record);
}
}
public Result PostRepairRecord([FromBody] RepairRecord repairRecord)
{
var cnt =
ServerConfig.RepairDb.Query <int>("SELECT COUNT(1) FROM `fault_type` WHERE Id = @id AND MarkedDelete = 0;", new { id = repairRecord.FaultTypeId }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.FaultTypeNotExist));
}
repairRecord.CreateUserId = Request.GetIdentityInformation();
repairRecord.MarkedDateTime = DateTime.Now;
ServerConfig.RepairDb.Execute(
"INSERT INTO repair_record (`CreateUserId`, `MarkedDateTime`, `MarkedDelete`, `ModifyId`, `DeviceCode`, `FaultTime`, `Proposer`, `FaultDescription`, `Priority`, `FaultSolver`, `SolveTime`, `SolvePlan`, `FaultTypeId`) " +
"VALUES (@CreateUserId, @MarkedDateTime, @MarkedDelete, @ModifyId, @DeviceCode, @FaultTime, @Proposer, @FaultDescription, @Priority, @FaultSolver, @SolveTime, @SolvePlan, @FaultTypeId);",
repairRecord);
return(Result.GenError <Result>(Error.Success));
}
public string AddRepair(RepairRecord repair)
{
try
{
var result = RestProxy.RepairRecordServiceProxy.Add(repair);
if (result.HasError)
{
return("添加失败:" + result.Errors[0].ErrorMessage);
}
else
{
return("添加成功");
}
}
catch (RestException ex)
{
return("系统异常:" + ex.Message);
}
}
public Result PutRepairRecord([FromRoute] int id, [FromBody] RepairRecord repairRecord)
{
var cnt =
ServerConfig.RepairDb.Query <int>("SELECT COUNT(1) FROM `repair_record` WHERE Id = @id AND MarkedDelete = 0;", new { id }).FirstOrDefault();
if (cnt == 0)
{
return(Result.GenError <Result>(Error.RepairRecordNotExist));
}
repairRecord.Id = id;
repairRecord.CreateUserId = Request.GetIdentityInformation();
repairRecord.MarkedDateTime = DateTime.Now;
ServerConfig.RepairDb.Execute(
"UPDATE repair_record SET `CreateUserId` = @CreateUserId, `MarkedDateTime` = @MarkedDateTime, `MarkedDelete` = @MarkedDelete, `ModifyId` = @ModifyId, " +
"`DeviceCode` = @DeviceCode, `FaultTime` = @FaultTime, `Proposer` = @Proposer, `FaultDescription` = @FaultDescription, `Priority` = @Priority, " +
"`FaultSolver` = @FaultSolver, `SolveTime` = @SolveTime, `SolvePlan` = @SolvePlan, `FaultTypeId` = @FaultTypeId WHERE `Id` = @Id;", repairRecord);
return(Result.GenError <Result>(Error.Success));
}
public string GetRecord(int id)
{
string token = TokenHelper.GetTokenJson(HttpContext.Request.Headers["Authorization"]);//利用这个进行数据按部门进行隔离
TokenInfo tokenInfo = JSONHelper.JSONToObject <TokenInfo>(token);
int WorkcellId = tokenInfo.workCell;
RepairRecord repairRecord = new RepairRecord();
repairRecord.Id = id;
repairRecord.WorkcellId = WorkcellId;
RepairRecord result = repairService.GetRecord(repairRecord);
if (result != null)
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Ok(result)));
}
else
{
return(JSONHelper.ObjectToJSON(ResponseUtil.Fail()));
}
}
public Result PutRepairRecordComment([FromBody] RepairRecord repairRecord)
{
var record =
ServerConfig.ApiDb.Query <RepairRecord>("SELECT * FROM `fault_device_repair` WHERE Id = @id AND MarkedDelete = 0;", new { id = repairRecord.Id }).FirstOrDefault();
if (record == null)
{
return(Result.GenError <Result>(Error.RepairRecordNotExist));
}
if (record.State != RepairStateEnum.Complete)
{
return(Result.GenError <Result>(Error.RepairRecordNotComplete));
}
repairRecord.Comment = repairRecord.Comment ?? "";
ServerConfig.ApiDb.Execute(
"UPDATE fault_device_repair SET `Comment` = @Comment WHERE `Id` = @Id;", repairRecord);
return(Result.GenError <Result>(Error.Success));
}
//添加
protected void btn_Save_Click(object sender, EventArgs e)
{
lab_Error.Text = "";
RepairRecord model = new RepairRecord();
try
{
if (hid_id.Value != "")
{
model = RepairRecord.Load(Convert.ToInt32(hid_id.Value));
}
model.ApplicantName =txt_ApplicantName.Text.Trim();
model.ApplyingDate =Convert.ToDateTime(txt_ApplyingDate.Text.Trim());
model.ApproverName = txt_ApproverName.Text.Trim();
model.BuildingNbr = txt_BuildingNbr.Text.Trim();
model.Content = txt_Content.Text.Trim();
model.RepairState =Convert.ToByte(ddl_RepairState.SelectedValue);
model.RoomNbr = txt_RoomNbr.Text.Trim();
model.Remark = txt_Remark.Text.Trim();
if (hid_id.Value != "")
{
model.Save();
Page.ClientScript.RegisterStartupScript(typeof(string), "", "alert('修改成功'); window.location.href='MaintainList.aspx';", true);
hid_id.Value = "";
}
else
{
model.Save();
Page.ClientScript.RegisterStartupScript(typeof(string), "", "alert('添加成功'); window.location.href='MaintainList.aspx';", true);
}
}
catch (Exception ex)
{
lab_Error.Text = ex.Message;
}
}
/// <summary>
/// 删除单条维修记录
/// </summary>
/// <param name="id"></param>
/// <returns>操作状态码</returns>
public int deleteRepairRecordById(RepairRecord repairRecord)
{
return(BaseDao.Delete <RepairRecord>("DeleteRepairRecordById", repairRecord));
}
/// <summary>
/// 获取工夹具维修报表
/// </summary>
/// <returns></returns>
public List <RepairRecord> GetRepairChart(RepairRecord record)
{
return(repairRecordDao.selectAllRepairRecords(record).ToList());
}
/// <summary>
/// 搜索维修记录
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public RepairRecord GetRecord(RepairRecord record)
{
return(repairRecordDao.selectRepairRecordById(record));
}
/// <summary>
/// 得到所有维修未完成的记录
/// </summary>
/// <returns></returns>
public List <RepairRecord> GetNotCompleteRecord(RepairRecord record)
{
return(repairRecordDao.selectAllNotCompleteRecords(record).ToList());
}
/// <summary>
/// 插入未完成维修记录
/// </summary>
/// <param name="repairRecord"></param>
/// <returns>未完成维修记录列表</returns>
public IList <RepairRecord> selectAllNotCompleteRecords(RepairRecord repairRecord)
{
return(BaseDao.QueryForList <RepairRecord>("SelectAllNotCompleteRecords", repairRecord));
}
/// <summary>
/// 查询单条维修记录
/// </summary>
/// <param name="repairRecord"></param>
/// <returns>维修记录</returns>
public RepairRecord selectRepairRecordById(RepairRecord repairRecord)
{
return(BaseDao.QueryForObject <RepairRecord>("SelectRepairRecordById", repairRecord));
}
/// <summary>
/// 插入单条维修记录
/// </summary>
/// <param name="repairRecord"></param>
/// <returns>操作状态码</returns>
public int insertRepairRecord(RepairRecord repairRecord)
{
return(BaseDao.Insert <RepairRecord>("InsertRepairRecord", repairRecord));
}
/// <summary>
/// 更新单条维修记录
/// </summary>
/// <param name="repairRecord"></param>
/// <returns>操作状态码</returns>
public int updateRepairRecord(RepairRecord repairRecord)
{
return(BaseDao.Update <RepairRecord>("UpdateRepairRecord", repairRecord));
}
