using Microsoft.Extensions.DependencyInjection; using Opsoft.Data; using Opsoft.NetCore.O3App.Domain; using Opsoft.NetCore.O3App.Domain.Interface; using Opsoft.NetCore.O3App.Domain.UnitOfWork.Equipment.IRepositories; using Opsoft.NetCore.O3App.Domain.UnitOfWork.Equipment.Model; using Opsoft.NetCore.O3App.Shared; using Opsoft.NetCore.O3App.Shared.Utils; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Threading.Tasks; namespace Opsoft.NetCore.O3App.Repositories.Equipment { /// /// 设备维护AND维修 /// [MapTo(typeof(IRepairOrderRepository), ServiceLifetime.Transient)] public class RepairOrderRepository : RepositoryBase, IRepairOrderRepository { public RepairOrderRepository() : base() { } /// /// 获取设备信息、故障类别、故障程度、设备部位、设备供应商、备件出入库类型(basicType:1=维修,2=保养) /// /// /// public async Task> GetEquipmentBasicData(dynamic data) { dynamic getData = JsonOperator.JsonDeserialize(data.ToString()); using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); string SQL = string.Empty; string type = "0"; if (!string.IsNullOrEmpty(getData.type.ToString())) { type = getData.type.ToString(); } //basicType:0=设备信息、1=故障类别、2=故障程度、3=设备部位、4=设备供应商、5=备件出入库类型 switch (getData.basicType.ToString()) { case "0": SQL = $@"SELECT S.FINTERID AS FID, S.FNUMBER AS FNO, S.FNAME, S.FCOMPANYID FROM T_ENG_EQUIPMENT S WHERE S.FSTATUS=40 AND S.FDELETED=0 "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FNUMBER='{getData.fNO}'"; } break; case "1": SQL = $@"SELECT S.FINTERID AS FID, S.FNUMBER AS FNO, S.FNAME, S.FCOMPANYID FROM T_ENG_EQFAULTTYPE S WHERE S.FSTATUS=40 "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FNUMBER='{getData.fNO}'"; } break; case "2": SQL = $@"SELECT S.FINTERID AS FID, S.FNUMBER AS FNO, S.FNAME, S.FCOMPANYID FROM T_ENG_EQFAULTDEGREE S WHERE S.FSTATUS=40 "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FNUMBER='{getData.fNO}'"; } break; case "3": SQL = $@"SELECT S.FDETAILID AS FID, S.FPARTNO AS FNO, S.FPARTNAME AS FNAME, S.FCOMPANYID FROM T_ENG_EQUIPMENTENTRY3 S WHERE S.UID<>'' "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FINTERID='{getData.fNO}'"; } break; case "4": SQL = $@"SELECT S.FINTERID AS FID, S.FNUMBER AS FNO, S.FNAME, S.FCOMPANYID FROM T_ENG_EQSUPPLIER S WHERE S.FSTATUS=40 AND S.FDELETED=0 "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FNUMBER='{getData.fNO}'"; } break; case "5": SQL = $@"SELECT S.FINTERID AS FID, S.FNUMBER AS FNO, S.FNAME, S.FCOMPANYID FROM T_ENG_EQFADDSUBTRACTINVENTORY S WHERE S.FSTATUS=40 "; if (!string.IsNullOrEmpty(getData.fNO.ToString())) { SQL += $@" AND S.FNUMBER='{getData.fNO}'"; } switch (type) {//0=查询全部 -1=出库 1=入库 2=盘点类型 case "-1": SQL += " AND S.FADDSUBTRACT=1"; break; case "1": SQL += " AND S.FADDSUBTRACT=2"; break; case "2": SQL += " AND S.FADDSUBTRACT=3"; break; } break; } if (!string.IsNullOrEmpty(getData.fName.ToString())) { SQL += $@" AND S.FNAME LIKE'%{getData.fName}%'"; } var departments = await context.Database.SqlQueryAsync(SQL); return departments; } /// /// 获取维修,保养工单列表(按部位显示)(basicType:1=维修,2=保养)(statusType:1=未验收,2=已验收) /// /// /// public async Task> RepairOrder(dynamic data) { dynamic getData = JsonOperator.JsonDeserialize(data.ToString()); using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); string SQL = string.Empty, whereSQL = string.Empty; //basicType:1=维修,2=保养 switch (getData.basicType.ToString()) { case "1": //statusType:1=未验收,2=已验收 switch (getData.statusType.ToString()) { case "1": whereSQL = $@" (T1.FORDERSTATUS=0 OR T1.FORDERSTATUS=1)"; break; case "2": whereSQL = $@" (T1.FORDERSTATUS=2 OR T1.FORDERSTATUS=3)"; break; } if (!LoginInfo.PAID.IsNullOrEmpty()&&LoginInfo.PAType.Equals("1")) { whereSQL += $@" AND (ISNULL(T1.FREPAIRPERSON,'')='' OR T5.FNUMBER='{LoginInfo.PAID}')"; } else { whereSQL += $@" AND ISNULL(T1.FREPAIRPERSON,'')=''"; } if (!string.IsNullOrEmpty(getData.fNO.ToString())) { whereSQL += $@" AND T2.FNUMBER='{getData.fNO}'"; } SQL = $@" SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FISFINISHED, S.FDATE, S.FORDERSTATUS, S.FMACHINENAME, S.FMACHINENUMBER, S.FITEMID FROM ( SELECT ROW_NUMBER() OVER(ORDER BY T1.FAPPLYFORDATE ASC) AS RowNumber, T1.FINTERID, T1.FBILLNO, T1.FNAME, CONVERT(VARCHAR(100),T1.FAPPLYFORDATE) AS FDATE, T1.FORDERSTATUS, T2.FINTERID AS FITEMID, T2.FNAME AS FMACHINENAME, T2.FNUMBER AS FMACHINENUMBER, CASE WHEN T1.FORDERSTATUS=3 THEN 1 ELSE 0 END AS FISFINISHED FROM T_ENG_EPMTWOMANAGE T1 INNER JOIN T_ENG_EQUIPMENT T2 ON T2.FINTERID=T1.FMACHINEID LEFT JOIN T_HR_EMPINFO T5 ON T5.FINTERID=T1.FREPAIRPERSON WHERE{whereSQL} ) AS S WHERE S.RowNumber BETWEEN ({getData.PageNumber}-1)*({getData.BarNumber}+1) AND ({getData.PageNumber}*{getData.BarNumber}) ORDER BY RowNumber"; break; case "2": //statusType:1=未验收,2=已验收 switch (getData.statusType.ToString()) { case "1": whereSQL = $@" AND (T1.FORDERSTATUS=0 OR T1.FORDERSTATUS=1)"; break; case "2": whereSQL = $@" AND (T1.FORDERSTATUS=2 OR T1.FORDERSTATUS=3)"; break; } if (!LoginInfo.PAID.IsNullOrEmpty() && LoginInfo.PAType == "1") { whereSQL += $@" AND (ISNULL(T1.FREPAIRPERSON,'')='' OR T5.FNUMBER='{LoginInfo.PAID}')"; } else { whereSQL += $@" AND ISNULL(T1.FREPAIRPERSON,'')=''"; } if (!string.IsNullOrEmpty(getData.fNO.ToString())) { whereSQL += $@" AND T2.FNUMBER='{getData.fNO}'"; } SQL = $@" SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FISFINISHED, CONVERT(varchar(100), S.FDATE, 23) AS FDATE, S.FORDERSTATUS, S.FMACHINENAME, S.FMACHINENUMBER, S.FITEMID FROM ( SELECT ROW_NUMBER() OVER(ORDER BY T1.FMAINTDATE ASC) AS RowNumber, T1.FINTERID, T1.FBILLNO, T1.FNAME, T1.FMAINTDATE AS FDATE, T1.FORDERSTATUS, T2.FINTERID AS FITEMID, T2.FNAME AS FMACHINENAME, T2.FNUMBER AS FMACHINENUMBER, CASE WHEN T1.FORDERSTATUS=3 THEN 1 ELSE 0 END AS FISFINISHED FROM T_ENG_WORKORDERMANAGE T1 INNER JOIN T_ENG_EQUIPMENT T2 ON T2.FINTERID=T1.FMACHINEID LEFT JOIN T_HR_EMPINFO T5 ON T5.FINTERID=T1.FREPAIRLEADER WHERE T1.FISCASECLOSED=0{whereSQL} ) AS S WHERE S.RowNumber BETWEEN ({getData.PageNumber}-1)*({getData.BarNumber}+1) AND ({getData.PageNumber}*{getData.BarNumber}) ORDER BY RowNumber"; break; } var departments = await context.Database.SqlQueryAsync(SQL); return departments; } /// /// 按单据编号获取维修,保养工单详情(basicType:1=维修,2=保养) /// /// /// public async Task> MaintenanceOrder(dynamic data) { dynamic getData = JsonOperator.JsonDeserialize(data.ToString()); using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量 string SQL = string.Empty; List MaintenanceOrder = new List(); List departments = new List(); #endregion switch (getData.basicType.ToString()) { case "1": SQL = $@"SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FORDERFROM,--1=申请故障维修;2=申请事故维修;3=事后事故维修;4=事后故障维修;5=其它 S.FORDERSTATUS,--0=未安排;1=已安排;2=完工;3=验收 S.FORDERTYPE,--0=申请产生;1=事后产生;2=其它 S.FSTATUSAFTERMAINT AS FSTATUS,--0=正常;1=维修中;2=维护中;3=恶劣 S.FAPPLYFORDATE AS FDATE, S.FISSTOPMACHINE, S.FASTARTTIME, S.FAENDTIME, CONVERT(VARCHAR(50),S.FMACHINESTOPSTART,120) AS FMACHINESTOPSTART, CONVERT(VARCHAR(50),S.FMACHINESTOPEND,120) AS FMACHINESTOPEND, S.FCONDITIONRESUME, S.FTOTALSCORE, S.FFAULTCLEARANCE, T2.FNAME AS FMACHINENAME, T2.FNUMBER AS FMACHINENUMBER, T2.FINTERID AS FITEMID, T5.FNAME AS FEMPNAME FROM T_ENG_EPMTWOMANAGE S INNER JOIN T_ENG_EQUIPMENT T2 ON T2.FINTERID=S.FMACHINEID LEFT JOIN T_HR_EMPINFO T5 ON T5.FINTERID=S.FREPAIRLEADER WHERE S.FBILLNO='{getData.billNO}'"; departments = await context.Database.SqlQueryAsync(SQL); if (departments.Count == 0) { throw new O3AppException("当前单据信息未找到", 400); } MaintenanceOrder.Add(departments[0]); //查询保养记录 SQL = $@" SELECT S1.FENTRYID, S1.FDETAILID, S1.FORDERSTATUS,--0=未执行,1=执行中,2=完成 S1.FNAME, S1.FCONTENTSANDREQUIREMENTS, S2.FPARTNAME, S2.FDETAILID as FITEMID, S4.FNAME AS FEMPNAME FROM T_ENG_EPMTWOMANAGEENTRY1 S1 LEFT JOIN T_ENG_EPMTWOMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S2.FDETAILID=S1.FMACHINEPARTID LEFT JOIN T_ENG_EPMTWOMANAGEENTRY3 S3 ON S1.FDETAILID=S3.FRELATIONID LEFT JOIN T_HR_EMPINFO S4 ON S3.FMAINTMANID=S4.FINTERID WHERE S.FBILLNO='{getData.billNO}' ORDER BY S1.FENTRYID;"; MaintenanceOrder[0].Body1 = context.Database.SqlQuery(SQL); //查询备件领用 SQL = $@"SELECT S1.FDETAILID, S1.FCOUNT AS FQTY, S2.FNAME AS FSPAREPARTNAME, S2.FBILLNO AS FSPAREPARTNUMBER, S2.FPRICE, S2.FUNITNAME, S2.FEQMODEL, S3.FPARTNAME FROM T_ENG_EPMTWOMANAGEENTRY2 S1 LEFT JOIN T_ENG_EPMTWOMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQSPAREPARTSLIST S2 on S1.FSPAREPARTID= S2.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S3 on S3.FDETAILID=S1.FMACHINEPARTID WHERE S.FBILLNO='{getData.billNO}' ORDER BY S1.FENTRYID"; MaintenanceOrder[0].Body2 = context.Database.SqlQuery(SQL); //查询保养人 SQL = $@"SELECT S1.FDETAILID, S1.FMAINTMANID, S1.FACRAFTTIME, S2.FPARTNO, S2.FPARTNAME, S3.FNUMBER AS FEMPNUMBER, S3.FNAME AS FEMPNAME FROM T_ENG_EPMTWOMANAGEENTRY3 S1 LEFT JOIN T_ENG_EPMTWOMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S1.FMACHINEPARTID= S2.FDETAILID LEFT JOIN T_HR_EMPINFO S3 on S3.FINTERID=S1.FMAINTMANID WHERE S.FBILLNO='{getData.billNO}' ORDER BY S1.FENTRYID"; MaintenanceOrder[0].Body3 = context.Database.SqlQuery(SQL); break; case "2": SQL = $@"SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FORDERFROM,--0=自动生成;1=手动添加 S.FORDERSTATUS,--0=未安排;1=已安排;2=完工;3=验收 S.FORDERTYPE,--0=任务产生;1=计划产生 S.FSTATUSAFTERMAINT AS FSTATUS,--0=正常;1=维修中;2=维护中;3=恶劣 S.FMAINTDATE AS FDATE, S.FISSTOPMACHINE, S.FASTARTTIME, S.FAENDTIME, CONVERT(VARCHAR(50),S.FMACHINESTOPSTART,120) AS FMACHINESTOPSTART, CONVERT(VARCHAR(50),S.FMACHINESTOPEND,120) AS FMACHINESTOPEND, S.FCONDITIONRESUME, S.FTOTALSCORE, T2.FNAME AS FMACHINENAME, T2.FNUMBER AS FMACHINENUMBER, T2.FINTERID AS FITEMID, T5.FNAME AS FEMPNAME FROM T_ENG_WORKORDERMANAGE S INNER JOIN T_ENG_EQUIPMENT T2 ON T2.FINTERID=S.FMACHINEID LEFT JOIN T_HR_EMPINFO T5 ON T5.FINTERID=S.FREPAIRLEADER WHERE S.FBILLNO='{getData.billNO}'"; departments = await context.Database.SqlQueryAsync(SQL); if (departments.Count == 0) { throw new O3AppException("当前单据信息未找到", 400); } MaintenanceOrder.Add(departments[0]); //查询保养记录 SQL = $@"SELECT S1.FENTRYID, S1.FDETAILID, S1.FORDERSTATUS,--0=未执行,1=执行中,2=完成 S1.FPART, S1.FCONTENTSANDREQUIREMENTS, S2.FPARTNAME, S2.FDETAILID as FITEMID, S3.FNAME AS FEMPNAME FROM T_ENG_WORKORDERMANAGEENTRY1 S1 LEFT JOIN T_ENG_WORKORDERMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S2.FDETAILID=S1.FMACHINEPARTID LEFT JOIN T_ENG_WORKORDERMANAGEENTRY5 S4 on S1.FDETAILID=S4.FRELATIONID LEFT JOIN T_HR_EMPINFO S3 ON S3.FINTERID=S4.FMAINTMANID WHERE S.FBILLNO='{getData.billNO}'"; MaintenanceOrder[0].Body1 = context.Database.SqlQuery(SQL); //查询备件领用 SQL = $@"SELECT S1.FDETAILID, S1.FSPAREPARTCOUNT AS FQTY, S2.FNAME AS FSPAREPARTNAME, S2.FBILLNO AS FSPAREPARTNUMBER, S2.FPRICE, S2.FUNITNAME, S2.FEQMODEL, S3.FPARTNAME FROM T_ENG_WORKORDERMANAGEENTRY2 S1 LEFT JOIN T_ENG_WORKORDERMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQSPAREPARTSLIST S2 on S1.FSPAREPARTID= S2.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S3 on S3.FDETAILID=S1.FMACHINEPARTID WHERE S.FBILLNO='{getData.billNO}' ORDER BY S1.FENTRYID"; MaintenanceOrder[0].Body2 = context.Database.SqlQuery(SQL); //查询保养人 SQL = $@"SELECT S1.FDETAILID, S1.FMAINTMANID, S1.FACRAFTTIME, S2.FPARTNO, S2.FPARTNAME, S3.FNUMBER AS FEMPNUMBER, S3.FNAME AS FEMPNAME FROM T_ENG_WORKORDERMANAGEENTRY5 S1 LEFT JOIN T_ENG_WORKORDERMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S1.FMACHINEPARTID= S2.FDETAILID LEFT JOIN T_HR_EMPINFO S3 on S3.FINTERID=S1.FMAINTMANID WHERE S.FBILLNO='{getData.billNO}' ORDER BY S1.FENTRYID"; MaintenanceOrder[0].Body3 = context.Database.SqlQuery(SQL); break; } return MaintenanceOrder; } /// /// 按单据表体内码获取维修,保养工单部位信息(basicType:1=维修,2=保养) /// /// /// public async Task> MaintenanceOrderEntry(dynamic data) { dynamic getData = JsonOperator.JsonDeserialize(data.ToString()); using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量 Dictionary reData = new Dictionary(); string SQL = string.Empty; DataTable Body = new DataTable(); #endregion //basicType:1=维修,2=保养 switch (getData.basicType.ToString()) { case "1": //工单明细 SQL = $@"SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FASTARTTIME, S.FAENDTIME, S.FMACHINESTOPSTART, S.FMACHINESTOPEND, S.FISSTOPMACHINE, S1.FENTRYID, S1.FDETAILID, S1.FORDERSTATUS, S1.FNAME AS FPART, S1.FCONTENTSANDREQUIREMENTS, S1.FMACHINEPARTID, S1.FMAINTMANID, S1.FIMAGE, S1.FNOTE, S1.FCONDITION, S1.FSCORE, S1.FEXPLAIN, S2.FPARTNAME, S3.FNAME AS FEMPNAME FROM T_ENG_EPMTWOMANAGEENTRY1 S1 LEFT JOIN T_ENG_EPMTWOMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S2.FDETAILID=S1.FMACHINEPARTID LEFT JOIN T_HR_EMPINFO S3 ON S3.FINTERID=S1.FMAINTMANID WHERE S1.FDETAILID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body1", Body); //备件/材料 SQL = $@"SELECT S3.FENTRYID, S1.FDETAILID, S1.FSPAREPARTID, S1.FMACHINEPARTID, S1.FCOUNT AS FQTY, S2.FNAME AS FSPAREPARTNAME FROM T_ENG_EPMTWOMANAGEENTRY2 S1 LEFT JOIN T_ENG_EQSPAREPARTSLIST S2 on S1.FSPAREPARTID= S2.FINTERID LEFT JOIN T_ENG_EPMTWOMANAGEENTRY1 S3 on S1.FRELATIONID=S3.FDETAILID WHERE S1.FRELATIONID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body2", Body); //维修工种/检修人 SQL = $@"SELECT S2.FENTRYID, S1.FDETAILID, S1.FMAINTMANID, S1.FACRAFTTIME, S3.FNUMBER AS FEMPNUMBER, S3.FNAME AS FEMPNAME FROM T_ENG_EPMTWOMANAGEENTRY3 S1 LEFT JOIN T_HR_EMPINFO S3 on S3.FINTERID=S1.FMAINTMANID LEFT JOIN T_ENG_EPMTWOMANAGEENTRY1 S2 on S1.FRELATIONID=S2.FDETAILID WHERE S1.FRELATIONID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body3", Body); break; case "2": //工单明细 SQL = $@"SELECT S.FINTERID, S.FBILLNO, S.FNAME, S.FASTARTTIME, S.FAENDTIME, S.FMACHINESTOPSTART, S.FMACHINESTOPEND, S.FISSTOPMACHINE, S1.FENTRYID, S1.FDETAILID, S1.FORDERSTATUS, S1.FPART, S1.FCONTENTSANDREQUIREMENTS, S1.FMACHINEPARTID, S1.FMAINTMANID, S1.FIMAGE, S1.FNOTE, S1.FCONDITION, S1.FSCORE, S1.FEXPLAIN, S2.FPARTNAME, S3.FNAME AS FEMPNAME FROM T_ENG_WORKORDERMANAGEENTRY1 S1 LEFT JOIN T_ENG_WORKORDERMANAGE S ON S.FINTERID=S1.FINTERID LEFT JOIN T_ENG_EQUIPMENTENTRY3 S2 on S2.FDETAILID=S1.FMACHINEPARTID LEFT JOIN T_HR_EMPINFO S3 ON S3.FINTERID=S1.FMAINTMANID WHERE S1.FDETAILID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body1", Body); //备件/材料 SQL = $@" SELECT S3.FENTRYID, S1.FDETAILID, S1.FSPAREPARTID, S1.FMACHINEPARTID, S1.FSPAREPARTCOUNT AS FQTY, S2.FNAME AS FSPAREPARTNAME FROM T_ENG_WORKORDERMANAGEENTRY2 S1 LEFT JOIN T_ENG_EQSPAREPARTSLIST S2 ON S2.FINTERID=S1.FSPAREPARTID LEFT JOIN T_ENG_WORKORDERMANAGEENTRY1 S3 on S1.FRELATIONID=S3.FDETAILID WHERE S1.FRELATIONID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body2", Body); //维修工种/检修人 SQL = $@"SELECT S2.FENTRYID, S1.FDETAILID, S1.FMAINTMANID, S1.FACRAFTTIME, S3.FNUMBER AS FEMPNUMBER, S3.FNAME AS FEMPNAME FROM T_ENG_WORKORDERMANAGEENTRY5 S1 LEFT JOIN T_HR_EMPINFO S3 on S3.FINTERID=S1.FMAINTMANID LEFT JOIN T_ENG_WORKORDERMANAGEENTRY1 S2 on S1.FRELATIONID=S2.FDETAILID WHERE S1.FRELATIONID='{getData.detailID}'"; Body = context.Database.SqlQuery(SQL); reData.Add("Body3", Body); break; } return await Task.Run(() => reData); } /// /// 修改维修,保养工单部位信息(完工提交)(basicType:1=维修,2=保养) /// /// /// public async Task MaintenanceReport(UpdateMaintenanceReport SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty, detailID = string.Empty, startTime = string.Empty, maintDate = string.Empty; int FORDERSTATUS = 0; DataTable dtResult = null; List sqlList = new List(), idList = new List(); List> repair = SData.repair;//提交的单据明细详情 List> spareParts = SData.spareParts;//提交的备件领用信息 List> empData = SData.empData;//提交的保养人信息 int entryID = 1; object obj; #endregion dtResult = context.Database.SqlQuery("SELECT FVALUE FROM SYS_PARAMETERS WHERE FNUMBER='IsAutoCheck'"); bool isAutoCheck = dtResult.Rows[0]["FVALUE"].ToStringEx().Equals("Y"); //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTDATE FROM T_ENG_EPMTWOMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FORDERSTATUS"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } startTime = dtResult.Rows[0]["FAStartTime"].ToStringEx(); maintDate = dtResult.Rows[0]["FMaintDate"].ToStringEx(); context.Database.BeginTransaction(); #region 表头信息 if (startTime.IsNullOrEmpty()) { startTime = DateTime.Now.ToString(); } switch (repair[0]["FOrderStatus"].ToStringEx()) { case "1": await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_EPMTWOMANAGE SET FASTARTTIME='{startTime.ToDateTime()}',FSTATUSAFTERMAINT=2,FORDERSTATUS=1 WHERE FINTERID='{repair[0]["FInterID"]}'"); break; case "2": DataTable ojb = context.Database.SqlQuery($@"SELECT FDETAILID FROM T_ENG_EPMTWOMANAGEENTRY1 WHERE FORDERSTATUS<>2 AND FINTERID='{repair[0]["FInterID"]}' AND FDETAILID<>'{repair[0]["FDetailID"]}'"); if (ojb.Rows.Count < 1) { TimeSpan FAMANUALCOST = (DateTime.Now) - startTime.ToDateTime(); decimal FMAMIN = FAMANUALCOST.TotalMinutes.ToDecimal(); if (isAutoCheck) { FORDERSTATUS = 3; } else { FORDERSTATUS = 2; } await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_EPMTWOMANAGE SET FAENDTIME='{DateTime.Now}',FAMANUALCOST={FMAMIN},FSTATUSAFTERMAINT=0, FORDERSTATUS={FORDERSTATUS} WHERE FINTERID='{repair[0]["FInterID"]}'"); } else { await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_EPMTWOMANAGE SET FSTATUSAFTERMAINT=2, FORDERSTATUS=1 WHERE FINTERID='{repair[0]["FInterID"]}'"); } break; } #endregion #region 工单信息 string FMaintManID = string.Empty; if (repair[0]["IsNew"].ToBoolean()) { obj = context.Database.SqlQuery($@"SELECT MAX(FENTRYID) FROM T_ENG_EPMTWOMANAGEENTRY1 WHERE FInterID='{repair[0]["FInterID"]}'"); repair[0]["FDetailID"] = Guid.NewGuid().ToStringEx(); int fentryID = obj.IsNullOrEmpty() ? 1 : obj.ToInt() + 1; if (empData.Count > 0) { FMaintManID = empData[0]["FMaintID"].ToString(); } else { FMaintManID = ""; } await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EPMTWOMANAGEENTRY1 (FINTERID,FENTRYID,FDETAILID,FMACHINEPARTID,FISFINISHED,FORDERSTATUS,FIMAGE, FCONTENTSANDREQUIREMENTS,FNOTE,FMAINTMANID,UID) VALUES('{repair[0]["FInterID"]}',{fentryID},'{repair[0]["FDetailID"]}', '{repair[0]["FMachinePartID"]}','{repair[0]["FOrderStatus"].ToInt() == 2}', {repair[0]["FOrderStatus"].ToInt()},'{repair[0]["FImage"].ToStringEx()}', '{repair[0]["FRequirements"].ToStringEx()}','{repair[0]["FNote"].ToStringEx()}', '{FMaintManID}','{Guid.NewGuid().ToStringEx()}')"); } else { if (empData.Count > 0) { FMaintManID = empData[0]["FMaintID"].ToString(); } else { FMaintManID = ""; } await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_EPMTWOMANAGEENTRY1 SET FISFINISHED='{repair[0]["FOrderStatus"].ToInt() == 2}' ,FORDERSTATUS={repair[0]["FOrderStatus"].ToInt()} ,FIMAGE='{repair[0]["FImage"].ToStringEx()}' ,FCONTENTSANDREQUIREMENTS='{repair[0]["FRequirements"].ToStringEx()}' ,FNOTE='{repair[0]["FNote"].ToStringEx()}' ,FMAINTMANID='{FMaintManID}' WHERE FDETAILID='{repair[0]["FDetailID"].ToStringEx()}'"); } #endregion #region 备件信息 dtResult = context.Database.SqlQuery($@"SELECT FRELATIONID FROM T_ENG_EPMTWOMANAGEENTRY2 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID='{repair[0]["FDetailID"]}'"); if (dtResult != null && dtResult.Rows.Count > 0) { idList = dtResult.AsEnumerable().Select(o => o["FRELATIONID"].ToStringEx()).Distinct().ToList(); await context.Database.SqlNonQueryAsync($@"DELETE FROM T_ENG_EPMTWOMANAGEENTRY2 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID IN('{string.Join("','", idList) }')"); } if (spareParts.Count > 0) { entryID = 1; idList.Clear(); for (int i = 0; i < spareParts.Count; i++) { detailID = Guid.NewGuid().ToStringEx(); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EPMTWOMANAGEENTRY2 (FINTERID,FRELATIONID,FDETAILID,FENTRYID,FSPAREPARTID ,FCOUNT,FMACHINEPARTID,UID) VALUES('{repair[0]["FInterID"]}','{repair[0]["FDetailID"]}' ,'{detailID}',{entryID++},'{spareParts[i]["FInterID"]}' ,{spareParts[i]["FQty"].ToDecimal()},'{repair[0]["FMachinePartID"].ToStringEx()}' ,'{Guid.NewGuid().ToStringEx()}')"); } } #endregion #region 维修人信息 dtResult = context.Database.SqlQuery($@"SELECT FRELATIONID FROM T_ENG_EPMTWOMANAGEENTRY3 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID='{repair[0]["FDetailID"]}'"); if (dtResult != null && dtResult.Rows.Count > 0) { idList = dtResult.AsEnumerable().Select(o => o["FRELATIONID"].ToStringEx()).Distinct().ToList(); await context.Database.SqlNonQueryAsync($@"DELETE FROM T_ENG_EPMTWOMANAGEENTRY3 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID IN('{string.Join("','", idList)}')"); } if (empData.Count > 0) { entryID = 1; idList.Clear(); for (int i = 0; i < empData.Count; i++) { detailID = Guid.NewGuid().ToStringEx(); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EPMTWOMANAGEENTRY3 (FINTERID,FRELATIONID,FDETAILID,FENTRYID ,FMAINTMANID,FACRAFTTIME,FMACHINEPARTID,UID) VALUES('{repair[0]["FInterID"]}','{repair[0]["FDetailID"]}' ,'{detailID}',{entryID++},'{empData[i]["FMaintID"].ToStringEx()}' ,{empData[i]["FACraftTime"].ToDecimal()} ,'{repair[0]["FMachinePartID"].ToStringEx()}' ,'{Guid.NewGuid().ToStringEx()}')"); } } #endregion context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTTYPE,FMAINTDATE FROM T_ENG_WORKORDERMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FORDERSTATUS"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } bool isFirstFinish = dtResult.Rows[0]["FORDERSTATUS"].ToInt() != 2; int maintType = dtResult.Rows[0]["FMAINTTYPE"].ToInt(); startTime = dtResult.Rows[0]["FASTARTTIME"].ToStringEx(); maintDate = dtResult.Rows[0]["FMAINTDATE"].ToStringEx(); context.Database.BeginTransaction(); #region 表头信息 if (startTime.IsNullOrEmpty()) { startTime = DateTime.Now.ToString(); } switch (repair[0]["FOrderStatus"].ToStringEx()) { case "1": await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_WORKORDERMANAGE SET FASTARTTIME='{startTime.ToDateTime()}',FSTATUSAFTERMAINT=2,FORDERSTATUS=1 WHERE FINTERID='{repair[0]["FInterID"]}'"); break; case "2": var dt = context.Database.SqlQuery($@"SELECT FDETAILID FROM T_ENG_WORKORDERMANAGEENTRY1 WHERE FORDERSTATUS<>2 AND FINTERID='{repair[0]["FInterID"]}' AND FDETAILID<>'{repair[0]["FDetailID"]}'"); if (dt == null || dt.Rows.Count<1) { TimeSpan FAMANUALCOST = (DateTime.Now) - startTime.ToDateTime(); decimal FMAMIN = FAMANUALCOST.TotalMinutes.ToDecimal(); if (isAutoCheck) { FORDERSTATUS = 3; } else { FORDERSTATUS = 2; } await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_WORKORDERMANAGE SET FAENDTIME='{DateTime.Now}',FAMANUALCOST={FMAMIN},FSTATUSAFTERMAINT=0, FORDERSTATUS={FORDERSTATUS} WHERE FINTERID='{repair[0]["FInterID"]}'"); } else { await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_WORKORDERMANAGE SET FSTATUSAFTERMAINT=2, FORDERSTATUS=1 WHERE FINTERID='{repair[0]["FInterID"]}'"); } break; } #endregion #region 工单信息 //string FMaintManID = string.Empty; dtResult = context.Database.SqlQuery($@"SELECT * FROM T_ENG_WORKORDERMANAGEENTRY1 WHERE FDETAILID='{repair[0]["FDetailID"]}'"); if (dtResult.Rows.Count > 0) { if (empData.Count > 0) { FMaintManID = empData[0]["FMaintID"].ToString(); } else { FMaintManID = ""; } await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_WORKORDERMANAGEENTRY1 SET FISFINISHED='{repair[0]["FOrderStatus"].ToInt() == 2}' ,FORDERSTATUS={repair[0]["FOrderStatus"].ToInt()} ,FIMAGE='{repair[0]["FImage"].ToStringEx()}' ,FCONTENTSANDREQUIREMENTS='{repair[0]["FRequirements"].ToStringEx()}' ,FNOTE='{repair[0]["FNote"].ToStringEx()}' ,FISSTOPMACHINE={repair[0]["FIsStopMachine"].ToInt()} ,FMAINTDATE='{DateTime.Now.ToStringEx()}' ,FMAINTMANID='{FMaintManID}' WHERE FDETAILID='{repair[0]["FDetailID"].ToStringEx()}'"); } #endregion #region 备件信息 dtResult = context.Database.SqlQuery($@"SELECT FRELATIONID FROM T_ENG_WORKORDERMANAGEENTRY2 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID='{repair[0]["FDetailID"]}'"); if (dtResult != null && dtResult.Rows.Count > 0) { idList = dtResult.AsEnumerable().Select(o => o["FRELATIONID"].ToStringEx()).Distinct().ToList(); await context.Database.SqlNonQueryAsync($@"DELETE FROM T_ENG_WORKORDERMANAGEENTRY2 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID IN('{string.Join("','", idList) }')"); } if (spareParts.Count > 0) { entryID = 1; for (int i = 0; i < spareParts.Count; i++) { detailID = Guid.NewGuid().ToStringEx(); idList.Add(detailID); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_WORKORDERMANAGEENTRY2 (FINTERID,FRELATIONID,FDETAILID,FENTRYID,FSPAREPARTID ,FSPAREPARTCOUNT,FMACHINEPARTID,UID) VALUES('{repair[0]["FInterID"]}','{repair[0]["FDetailID"]}' ,'{detailID}',{entryID++},'{spareParts[i]["FInterID"]}' ,{spareParts[i]["FQty"].ToDecimal()},'{repair[0]["FMachinePartID"].ToStringEx()}' ,'{Guid.NewGuid().ToStringEx()}')"); } } #endregion #region 维修人信息 dtResult = context.Database.SqlQuery($@"SELECT FRELATIONID FROM T_ENG_WORKORDERMANAGEENTRY5 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID='{repair[0]["FDetailID"]}'"); if (dtResult != null && dtResult.Rows.Count > 0) { idList = dtResult.AsEnumerable().Select(o => o["FRELATIONID"].ToStringEx()).Distinct().ToList(); await context.Database.SqlNonQueryAsync($@"DELETE FROM T_ENG_WORKORDERMANAGEENTRY5 WHERE FINTERID='{repair[0]["FInterID"]}' AND FRELATIONID IN('{string.Join("','", idList)}')"); } if (empData.Count > 0) { entryID = 1; for (int i = 0; i < empData.Count; i++) { detailID = Guid.NewGuid().ToStringEx(); idList.Add(detailID); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_WORKORDERMANAGEENTRY5 (FINTERID,FRELATIONID,FDETAILID,FENTRYID ,FMAINTMANID,FACRAFTTIME,FMACHINEPARTID,UID) VALUES('{repair[0]["FInterID"]}','{repair[0]["FDetailID"]}' ,'{detailID}',{entryID++},'{empData[i]["FMaintID"].ToStringEx()}' ,{empData[i]["FACraftTime"].ToDecimal()} ,'{repair[0]["FMachinePartID"].ToStringEx()}' ,'{Guid.NewGuid().ToStringEx()}')"); } } #endregion #region 更新设备维护计划中下次到期日 if (isFirstFinish && !maintDate.IsNullOrEmpty() && (maintType == 1 || maintType == 2 || maintType == 3)) { string tableName = string.Empty; switch (maintType) { case 1: tableName = "T_ENG_EQMTTASKPROJECTENTRY1"; break; case 2: tableName = "T_ENG_EQMTTASKPROJECTENTRY2"; break; case 3: tableName = "T_ENG_EQMTTASKPROJECTENTRY3"; break; } dtResult = context.Database.SqlQuery($@" SELECT S.FMAINTCOUNT, S.FUNIT, S.FCYCLE, S.FDETAILID FROM {tableName} S INNER JOIN T_ENG_WORKORDERMANAGEENTRY1 S2 ON S2.FEQMAINTENTRYDETAILID=S.FDETAILID WHERE S2.FDETAILID='{repair[0]["FDetailID"]}'"); if (dtResult.Rows.Count > 0) { int eqMaintCount = dtResult.Rows[0]["FMAINTCOUNT"].ToInt() + 1; string eqMaintDetailID = dtResult.Rows[0]["FDETAILID"].ToStringEx(); DateTime newDateTime = Convert.ToDateTime(maintDate); DateTime nextMaintDate = DateTime.Now; switch (dtResult.Rows[0]["FUNIT"].ToInt()) { case 1://天 nextMaintDate = newDateTime.AddDays(dtResult.Rows[0]["FCYCLE"].ToInt()); break; case 2://周 nextMaintDate = newDateTime.AddDays(dtResult.Rows[0]["FCYCLE"].ToInt() * 7); break; case 3://月 nextMaintDate = newDateTime.AddMonths(dtResult.Rows[0]["FCYCLE"].ToInt()); break; } sqlList.Add($@"UPDATE {tableName} SET FMAINTCOUNT={eqMaintCount}, FPREVMAINTDATE='{newDateTime}', FNEXTMAINTDATE='{nextMaintDate}' WHERE FDETAILID='{eqMaintDetailID}'"); } } #endregion #region 执行SQL if (sqlList.Count > 0) { await context.Database.SqlNonQueryAsync(sqlList.ToStringEx()); } #endregion context.Database.CommitTransaction(); break; #endregion } if (retMsg == "") { retMsg = "提交成功"; } return retMsg; } /// /// 修改维修,保养工单部位信息(验收提交)(basicType:1=维修,2=保养) /// /// /// public async Task PartReportAcceptance(UpdatePartReportAcceptance SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty; DataTable dtResult = null; List> repair = SData.SData;//验收提交的单据明细详情 #endregion dtResult = context.Database.SqlQuery("SELECT FVALUE FROM SYS_PARAMETERS WHERE FNUMBER='IsAutoCheck'"); bool isAutoCheck = dtResult.Rows[0]["FVALUE"].ToStringEx().Equals("Y"); //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTDATE FROM T_ENG_EPMTWOMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FORDERSTATUS"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT * FROM T_ENG_EPMTWOMANAGEENTRY1 WHERE FDETAILID='{repair[0]["FDetailID"]}'"); if (dtResult.Rows.Count > 0) { await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_EPMTWOMANAGEENTRY1 SET FCONDITION='{repair[0]["FCondition"]}' ,FSCORE={repair[0]["FScore"].ToDecimal()} ,FEXPLAIN='{repair[0]["FExplain"]}' WHERE FDETAILID='{repair[0]["FDetailID"]}'"); } context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTTYPE,FMAINTDATE FROM T_ENG_WORKORDERMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT * FROM T_ENG_WORKORDERMANAGEENTRY1 WHERE FDETAILID='{repair[0]["FDetailID"]}'"); if (dtResult.Rows.Count > 0) { await context.Database.SqlNonQueryAsync($@"UPDATE T_ENG_WORKORDERMANAGEENTRY1 SET FCONDITION='{repair[0]["FCondition"]}' ,FSCORE={repair[0]["FScore"].ToDecimal()} ,FEXPLAIN='{repair[0]["FExplain"]}' WHERE FDETAILID='{repair[0]["FDetailID"]}'"); } context.Database.CommitTransaction(); break; #endregion } if (retMsg == "") { retMsg = "提交成功"; } return retMsg; } /// /// 修改维修,保养工单信息(验收提交)(basicType:1=维修,2=保养) /// /// /// public async Task OrderReportAcceptance(UpdatePartReportAcceptance SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty, sqlAdd = string.Empty; DataTable dtResult = null; List> repair = SData.SData;//验收提交的单据明细详情 #endregion dtResult = context.Database.SqlQuery("SELECT FVALUE FROM SYS_PARAMETERS WHERE FNUMBER='IsAutoCheck'"); bool isAutoCheck = dtResult.Rows[0]["FVALUE"].ToStringEx().Equals("Y"); //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTDATE FROM T_ENG_EPMTWOMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT * FROM T_ENG_EPMTWOMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult.Rows.Count > 0) { if (CheckDateTime.IsDate(repair[0]["FMachineStopStart"].ToStringEx())) { sqlAdd += $@",FMACHINESTOPSTART='{repair[0]["FMachineStopStart"]}'"; } if (CheckDateTime.IsDate(repair[0]["FMachineStopEnd"].ToStringEx())) { sqlAdd += $@",FMACHINESTOPEND='{repair[0]["FMachineStopEnd"]}'"; } decimal stopTime = CheckDateTime.CalculateMaintTime(repair[0]["FMachineStopStart"], repair[0]["FMachineStopEnd"]); string sql = $@"UPDATE T_ENG_EPMTWOMANAGE SET FFAULTCLEARANCE='{repair[0]["FFaultClearance"]}' {sqlAdd} ,FASTOPTIME='{stopTime}' ,FISSTOPMACHINE='{stopTime > 0}' ,FTOTALSCORE={repair[0]["FTotalScore"].ToDecimal()} ,FSTATUSAFTERMAINT={repair[0]["FStatusAfterMaint"].ToInt()} ,FORDERSTATUS=3 WHERE FINTERID='{repair[0]["FInterID"]}'"; await context.Database.SqlNonQueryAsync(sql); } context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 dtResult = context.Database.SqlQuery($@"SELECT FBILLNO,FORDERSTATUS,FASTARTTIME,FMAINTTYPE,FMAINTDATE FROM T_ENG_WORKORDERMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("当前单据已验收"); } context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT * FROM T_ENG_WORKORDERMANAGE WHERE FINTERID='{repair[0]["FInterID"]}'"); if (dtResult.Rows.Count > 0) { if (CheckDateTime.IsDate(repair[0]["FMachineStopStart"].ToStringEx())) { sqlAdd += $@",FMACHINESTOPSTART='{repair[0]["FMachineStopStart"]}'"; } if (CheckDateTime.IsDate(repair[0]["FMachineStopEnd"].ToStringEx())) { sqlAdd += $@",FMACHINESTOPEND='{repair[0]["FMachineStopEnd"]}'"; } decimal stopTime = CheckDateTime.CalculateMaintTime(repair[0]["FMachineStopStart"], repair[0]["FMachineStopEnd"]); string SQL = $@"UPDATE T_ENG_WORKORDERMANAGE SET FASTOPTIME='{stopTime}' {sqlAdd} ,FISSTOPMACHINE='{stopTime > 0}' ,FTOTALSCORE={repair[0]["FTotalScore"].ToDecimal()} ,FSTATUSAFTERMAINT={repair[0]["FStatusAfterMaint"].ToInt()} ,FORDERSTATUS=3 WHERE FINTERID='{repair[0]["FInterID"]}'"; await context.Database.SqlNonQueryAsync(SQL); } context.Database.CommitTransaction(); break; #endregion } if (retMsg == "") { retMsg = "提交成功"; } return retMsg; } /// /// 按单据表体内码删除工单部位信息(basicType:1=维修,2=保养) /// /// /// public async Task DelBodyAndSparePart(DeleteBill SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty, sqlAdd = string.Empty; DataTable dtResult = null; #endregion //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT S.FBILLNO, S.FORDERSTATUS FROM T_ENG_EPMTWOMANAGE S LEFT JOIN T_ENG_EPMTWOMANAGEENTRY1 S2 ON S2.FINTERID=S.FINTERID WHERE S2.FDETAILID='{SData.fID}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("删除失败,当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("删除失败,当前单据已验收"); } await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_EPMTWOMANAGEENTRY2 S LEFT JOIN T_ENG_EPMTWOMANAGEENTRY1 S2 ON S2.FINTERID=S.FINTERID AND S2.FMACHINEPARTID=S.FMACHINEPARTID WHERE S2.FDETAILID='{SData.fID}'"); await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_EPMTWOMANAGEENTRY1 S WHERE S.FDETAILID='{SData.fID}'"); context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT S.FBILLNO, S.FORDERSTATUS FROM T_ENG_WORKORDERMANAGE S LEFT JOIN T_ENG_WORKORDERMANAGEENTRY1 S2 ON S2.FINTERID=S.FINTERID WHERE S2.FDETAILID='{SData.fID}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("删除失败,当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("删除失败,当前单据已验收"); } await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_WORKORDERMANAGEENTRY2 S LEFT JOIN T_ENG_WORKORDERMANAGEENTRY1 S2 ON S2.FINTERID=S.FINTERID AND S2.FMACHINEPARTID=S.FMACHINEPARTID WHERE S2.FDETAILID='{SData.fID}'"); await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_WORKORDERMANAGEENTRY1 S WHERE S.FDETAILID='{SData.fID}'"); context.Database.CommitTransaction(); break; #endregion } if (retMsg == "") { retMsg = "删除成功"; } return await Task.Run(() => retMsg); } /// /// 按内码删除维修、保养工单(basicType:1=维修,2=保养) /// /// /// public async Task DelOrderService(DeleteBill SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty, sqlAdd = string.Empty; DataTable dtResult = null; #endregion //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT S.FBILLNO, S.FORDERSTATUS FROM T_ENG_EPMTWOMANAGE S WHERE S.FINTERID='{SData.fID}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("删除失败,当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("删除失败,当前单据已验收"); } await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_EPMTWOMANAGE S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_EPMTWOMANAGEENTRY1 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_EPMTWOMANAGEENTRY2 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_EPMTWOMANAGEENTRY3 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_EPMTWOMANAGEENTRY4 S WHERE S.FINTERID='{SData.fID}'"); context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 context.Database.BeginTransaction(); dtResult = context.Database.SqlQuery($@"SELECT S.FBILLNO, S.FORDERSTATUS FROM T_ENG_WORKORDERMANAGE S WHERE S.FINTERID='{SData.fID}'"); if (dtResult == null || dtResult.Rows.Count <= 0) { throw new O3AppException("删除失败,当前单据信息未找到"); } if (dtResult.Rows[0]["FOrderStatus"].ToInt() == 3) { throw new O3AppException("删除失败,当前单据已验收"); } await context.Database.SqlNonQueryAsync($@"DELETE S FROM T_ENG_WORKORDERMANAGE S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_WORKORDERMANAGEENTRY1 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_WORKORDERMANAGEENTRY2 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_WORKORDERMANAGEENTRY4 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_WORKORDERMANAGEENTRY5 S WHERE S.FINTERID='{SData.fID}' DELETE S FROM T_ENG_WORKORDERMANAGEENTRY7 S WHERE S.FINTERID='{SData.fID}'"); context.Database.CommitTransaction(); break; #endregion } if (retMsg == "") { retMsg = "删除成功"; } return await Task.Run(() => retMsg); } /// /// 创建维修、保养工单(basicType:1=维修,2=保养) /// /// /// public async Task CreateOrder(CreateOrder SData) { using APPServerContext context = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID); #region 自定义变量AND传入参数 string retMsg = string.Empty, sqlAdd = string.Empty, billNO = string.Empty; List> repair = SData.repair;//传入工单信息 #endregion //basicType(1=维修,2=保养) switch (SData.basicType.ToString()) { case "1": #region 设备维修 context.Database.BeginTransaction(); billNO = CreateBilllNO(context, JsonOperator.JsonSerialize(new { FACCIDENTDATE = DateTime.Now }), "ENG_EPMTWOMANAGE", "T_ENG_EPMTWOMANAGE", "FBILLNO", "", ""); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_EPMTWOMANAGE (FORDERSTATUS,FORDERTYPE,FORDERFROM,FNAME,FMAINTDATE,FMACHINEID,FPRIORITY ,FREPAIRBYSELF,FISSTOPMACHINE,FCASESKETCH,FCAUSESKETCH,FREPAIRLEADER,FACCIDENTDATE ,FAPPLYFORDATE,FACCIDENTTYPE,FFAULTDEGREE,FINTERID,FBILLNO,UID) VALUES({1},{2},{5},'{repair[0]["FName"]}','{repair[0]["FMaintDate"]}' ,'{repair[0]["FMachineID"]}',{repair[0]["FPriority"].ToInt()} ,'{repair[0]["FRepairBySelf"]}','{repair[0]["FIsStopMachine"]}' ,'{repair[0]["FConditionResume"]}','{repair[0]["FReasonResume"]}' ,'{repair[0]["FMaintManID"]}','{repair[0]["FAccidentDate"]}' ,'{repair[0]["FApplyForDate"]}','{repair[0]["FAccidentType"]}' ,'{repair[0]["FFaultDegree"]}','{Guid.NewGuid().ToStringEx()}' ,'{billNO}','{Guid.NewGuid().ToStringEx()}')"); context.Database.CommitTransaction(); break; #endregion case "2": #region 设备保养 context.Database.BeginTransaction(); billNO = CreateBilllNO(context, JsonOperator.JsonSerialize(new { FMAINTDATE = DateTime.Now }), "ENG_WorkOrderManage", "T_ENG_WORKORDERMANAGE", "FBILLNO", "", ""); await context.Database.SqlNonQueryAsync($@"INSERT INTO T_ENG_WORKORDERMANAGE (FORDERSTATUS,FORDERTYPE,FORDERFROM,FNAME,FMAINTDATE,FMACHINEID,FPRIORITY ,FREPAIRBYSELF,FISSTOPMACHINE,FCONDITIONRESUME,FREASONRESUME,FREPAIRLEADER ,FINTERID,FBILLNO,UID) VALUES({1},{2},{1},'{repair[0]["FName"]}','{repair[0]["FMaintDate"]}' ,'{repair[0]["FMachineID"]}',{repair[0]["FPriority"].ToInt()} ,'{repair[0]["FRepairBySelf"]}','{repair[0]["FIsStopMachine"]}' ,'{repair[0]["FConditionResume"]}','{repair[0]["FReasonResume"]}' ,'{repair[0]["FMaintManID"]}','{Guid.NewGuid().ToStringEx()}' ,'{billNO}','{Guid.NewGuid().ToStringEx()}')"); context.Database.CommitTransaction(); break; #endregion } retMsg = billNO; return await Task.Run(() => retMsg); } } }