public int AddRepairReport(RepairReport repairReport) { _db.RepairReports.Add(repairReport); _db.SaveChanges(); return(repairReport.Id); }
private void btnDelivered_Click(object sender, EventArgs e) { var indices = lvOrderList.SelectedItems.Count; if (indices < 1) { return; } int id = Convert.ToInt32(lvOrderList.SelectedItems[0].SubItems[0].Text); var rr = new RepairReport(id); rr.Show(); }
public RepairReport UpdateRepairReport(int id, RepairReport repairReport) { var currentRecord = _db.RepairReports.First(rr => rr.Id == id); foreach (PropertyInfo property in repairReport.GetType().GetProperties()) { var value = repairReport.GetType().GetProperty(property.Name).GetValue(repairReport, null); if (value != null && property.Name.ToLower() != "id") { currentRecord.GetType().GetProperty(property.Name).SetValue(currentRecord, value); } } _db.SaveChanges(); return(currentRecord); }
public GetRepairReportDto RepairReportToGetRepairReportDto(RepairReport repairReport) { if (repairReport == null) { return(null); } return(new GetRepairReportDto { Id = repairReport.Id, Description = repairReport.Description, Cost = repairReport.Cost, Time = repairReport.Time, IsDeleted = repairReport.IsDeleted, OrderId = repairReport.OrderId }); }
public ActionResult Create([Bind(Include = "Id,cus_id,header,body,File,date_time")] RepairReport repairreport) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Content/RepairReport"), fileName); file.SaveAs(path); repairreport.File = fileName; } repairreport.date_time = DateTime.Now; repairreport.cus_id = User.Identity.GetUserId(); db.RepairReport.Add(repairreport); db.SaveChanges(); return(View("ReportSuccess")); }
//public static StatusReport GetRepairReport1(string ztcode, string level) //{ // StatusReport sr = new StatusReport(); // string sqlStr = // " select " + // " ID,序号,部门,地址,报修人,联系电话,服务项目,服务类别," + // " 紧急程度,报修说明,报修时间,预约服务时间,谈好上门时间,发单人,接单人,派工时间," + // " 到场时间,操作人,完成时间,收费类别,材料费,人工费,是否已收,是否阅读,状态,完成情况及所耗物料,报修前照片1," + // " 报修前照片2,报修前照片3,处理后照片1,处理后照片2,处理后照片3,延期原因,预计延期到,回访人,回访意见,回访时间, " + // " 是否满意,业主确认完成,业主确认完成时间,是否满意,业主评价,是否入户 " + // " from 小程序_工单管理 "; // string sqlString = ""; // string condition = ""; // if (level == "助理") // { // DataTable dt = null; // List<Repair> repairList = null; // List<RepairReportProject> rrpList = new List<RepairReportProject>(); // RepairReportProject rrp = null; // condition = " where 帐套代码 = @帐套代码 and isnull(完成时间,'') = '' " + // " and left(CONVERT(varchar(10),getdate(),112),8) = left(CONVERT(varchar(10),报修时间,112),8) " + // " and cast(left(CONVERT(varchar(20),getdate(),114),2) as int) >= 17 ";//当日未完工 // sqlString = sqlStr + condition; // dt = SQLHelper.ExecuteQuery("wyt", sqlString, // new SqlParameter("@帐套代码", ztcode)); // rrp = new RepairReportProject(); // rrp.type = "当日未完成"; // if (dt.Rows.Count != 0) // { // rrp = new RepairReportProject(); // rrp.type = "当日未完成"; // repairList = GetRepair(dt); // rrp.repairs = repairList.ToArray(); // } // rrpList.Add(rrp); // condition = " where " + // " 帐套代码 = @帐套代码 and ((预估完成时间 is not null " + // " and isnull(完成时间,'') = '' " + // " and DATEDIFF (hour, 预估完成时间, getdate()) >= 0) " + // " or (预估完成时间 is not null " + // " and DATEDIFF (hour, 预估完成时间, 完成时间) > 0" + // " and DATEDIFF (hour, 预估完成时间, getdate()) >= 0)) ";//超过预估完成时间 // sqlString = sqlStr + condition; // dt = SQLHelper.ExecuteQuery("wyt", sqlString, // new SqlParameter("@帐套代码", ztcode)); // rrp = new RepairReportProject(); // rrp.type = "超过预估完成时间"; // if (dt.Rows.Count != 0) // { // repairList = GetRepair(dt); // rrp.repairs = repairList.ToArray(); // } // rrpList.Add(rrp); // sr.status = "success"; // sr.result = "成功"; // sr.data = rrpList.ToArray(); // return sr; // } // else // { // condition = " where 帐套代码 = @帐套代码 and 是否满意 = '不满意' "; // RepairReportCompany rrc = new RepairReportCompany(); // rrc.type = "业主不满意"; // sqlString = sqlStr + condition; // DataTable dt = SQLHelper.ExecuteQuery("wyt", sqlString, // new SqlParameter("@帐套代码", ztcode)); // if (dt.Rows.Count == 0) // { // sr.status = "Fail"; // sr.result = "未查询到任何数据"; // return sr; // } // List<Repair> repairList = GetRepair(dt); // rrc.repairs = repairList.ToArray(); // sr.status = "Success"; // sr.result = "成功"; // sr.data = rrc; // return sr; // } //} private static List <RepairReport> GetRepairReport(DataTable dt) { List <RepairReport> repairList = new List <RepairReport>(); foreach (DataRow row in dt.Rows) { List <string> beforeList = new List <string>(); List <string> afterList = new List <string>(); RepairReport r = new RepairReport(); r.Id = DataTypeHelper.GetIntValue(row["ID"]); r.SerialNumber = DataTypeHelper.GetStringValue(row["序号"]); r.Department = DataTypeHelper.GetStringValue(row["部门"]); r.Address = DataTypeHelper.GetStringValue(row["地址"]); r.RepairPerson = DataTypeHelper.GetStringValue(row["报修人"]); r.PhoneNumber = DataTypeHelper.GetStringValue(row["联系电话"]); r.ServiceProject = DataTypeHelper.GetStringValue(row["服务项目"]); r.ServiceCategory = DataTypeHelper.GetStringValue(row["服务类别"]); r.Level = DataTypeHelper.GetStringValue(row["紧急程度"]); //r.Identity = DataTypeHelper.GetStringValue(row["身份"]); r.NeedIn = DataTypeHelper.GetStringValue(row["是否入户"]); r.RepairExplain = DataTypeHelper.GetStringValue(row["报修说明"]); r.RepairTime = DataTypeHelper.GetDateStringValue(row["报修时间"]); r.OrderTime = DataTypeHelper.GetDateStringValue(row["预约服务时间"]); r.VisitTime = DataTypeHelper.GetDateStringValue(row["谈好上门时间"]); r.SendPerson = DataTypeHelper.GetStringValue(row["发单人"]); r.ReceivePerson = DataTypeHelper.GetStringValue(row["接单人"]); r.DispatchTime = DataTypeHelper.GetDateStringValue(row["派工时间"]); r.ArriveTime = DataTypeHelper.GetDateStringValue(row["到场时间"]); r.OperatePerson = DataTypeHelper.GetStringValue(row["操作人"]); r.CompleteTime = DataTypeHelper.GetDateStringValue(row["完成时间"]); r.ChargeType = DataTypeHelper.GetStringValue(row["收费类别"]); r.MaterialExpense = DataTypeHelper.GetDoubleValue(row["材料费"]); r.LaborExpense = DataTypeHelper.GetDoubleValue(row["人工费"]); r.IsPaid = DataTypeHelper.GetStringValue(row["是否已收"]); r.IsRead = DataTypeHelper.GetIntValue(row["是否阅读"]); r.AffirmComplete = DataTypeHelper.GetStringValue(row["业主确认完成"]); r.AffirmCompleteEvaluation = DataTypeHelper.GetStringValue(row["业主评价"]); r.AffirmCompleteTime = DataTypeHelper.GetDateStringValue(row["业主确认完成时间"]); r.IsSatisfying = DataTypeHelper.GetStringValue(row["是否满意"]); r.CallBackEvaluation = DataTypeHelper.GetStringValue(row["回访意见"]); r.CallBackPerson = DataTypeHelper.GetStringValue(row["回访人"]); r.CallBackTime = DataTypeHelper.GetDateStringValue(row["回访时间"]); r.status = DataTypeHelper.GetStringValue(row["状态"]); r.status = string.IsNullOrEmpty(r.AffirmComplete) ? r.status : "业主已确认"; r.status = string.IsNullOrEmpty(r.CallBackPerson) ? r.status : "已回访"; r.CompleteStatus = DataTypeHelper.GetStringValue(row["完成情况及所耗物料"]); r.LateTime = DataTypeHelper.GetDateStringValue(row["预计延期到"]); r.type = DataTypeHelper.GetStringValue(row["上报原因"]); r.LateReason = DataTypeHelper.GetStringValue(row["延期原因"]); beforeList.Add(DataTypeHelper.GetStringValue(row["报修前照片1"])); beforeList.Add(DataTypeHelper.GetStringValue(row["报修前照片2"])); beforeList.Add(DataTypeHelper.GetStringValue(row["报修前照片3"])); r.BeforeImage = beforeList.ToArray(); afterList.Add(DataTypeHelper.GetStringValue(row["处理后照片1"])); afterList.Add(DataTypeHelper.GetStringValue(row["处理后照片2"])); afterList.Add(DataTypeHelper.GetStringValue(row["处理后照片3"])); r.AfterImage = afterList.ToArray(); repairList.Add(r); } return(repairList); }