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