public List <string> GetFaultsDept() { var db = new FaultContext(); var list = db.GetFaultsDept(); return(list); }
/// <summary> /// 查询值班记录分类 /// </summary> /// <returns></returns> public DataTable GetFL() { var db = new FaultContext(); string sql = "select DISTINCT FL from MAXIMO.V_YXJJBRZ "; DataTable dt = db.ExcuteDataTable(sql); return(dt); }
protected override void Execute(NativeActivityContext context) { FaultContext context2 = context.Properties.Find("{35ABC8C3-9AF1-4426-8293-A6DDBB6ED91D}") as FaultContext; if (context2 == null) { throw FxTrace.Exception.AsError(new InvalidOperationException(System.Activities.SR.FaultContextNotFound(base.DisplayName))); } context.RethrowException(context2); }
protected override void Execute(NativeActivityContext context) { FaultContext faultContext = context.Properties.Find(TryCatch.FaultContextId) as FaultContext; if (faultContext == null) { throw Microsoft.CoreWf.Internals.FxTrace.Exception.AsError(new InvalidOperationException(SR.FaultContextNotFound(this.DisplayName))); } context.RethrowException(faultContext); }
/// <summary> /// 分页查询班长值班交接日志 /// </summary> /// <param name="pageIndex">页码</param> /// <param name="pageSize">每个个数</param> /// <param name="bZMC">班组,班号</param> /// <param name="fL">分类</param> /// <param name="kEYWORD">关键字</param> /// <param name="sTARTDATE">开始时间</param> /// <param name="eNDDATE">结束时间</param> /// <param name="totalCount">返回的总条数</param> /// <returns></returns> public DataTable GetJJRZ(int pageIndex, int pageSize, string bZMC, string fL, string kEYWORD, string sTARTDATE, string eNDDATE, ref int totalCount) { string where = " 1=1 "; if (!string.IsNullOrWhiteSpace(bZMC)) { where += $" AND T.XT='{bZMC}'"; } if (!string.IsNullOrWhiteSpace(fL)) { string[] flArry = fL.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string flSql = "'" + string.Join("','", flArry) + "'"; where += $" AND T.FL IN ({flSql})"; } if (!string.IsNullOrWhiteSpace(kEYWORD)) { where += $" AND T.CZNR like '%{kEYWORD}%'"; } if (!string.IsNullOrWhiteSpace(sTARTDATE)) { DateTime start; if (DateTime.TryParse(sTARTDATE, out start)) { where += $" AND T.FSDATE>=to_date('{start.ToString("yyyy-MM-dd")}','yyyy-MM-dd')"; } } if (!string.IsNullOrWhiteSpace(eNDDATE)) { DateTime end; if (DateTime.TryParse(eNDDATE, out end)) { end = end.AddDays(1).Date; where += $" AND T.FSDATE<to_date('{end.ToString("yyyy-MM-dd")}','yyyy-MM-dd')"; } } string countSql = $"SELECT COUNT(*) FROM ( select rownum as ROWNO,T.* from ( select * from V_YXJJBRZ order by FSDATE desc ) T where {where} ) tt"; string selectSql = $"SELECT tt.* FROM ( select rownum as ROWNO,T.* from ( select * from V_YXJJBRZ order by FSDATE desc ) T where {where} ) tt where tt.ROWNO>{(pageIndex - 1) * pageSize} and tt.ROWNO <{(pageSize * pageIndex) + 1}"; var db = new FaultContext(); object obj = db.ExcuteScalar(countSql); totalCount = Convert.ToInt32(obj); DataTable dt = db.ExcuteDataTable(selectSql); return(dt); }
public List <string> GetUnits() { var db = new FaultContext(); var dt = db.GetUnits(); var result = new List <string>(); if (dt == null && dt.Rows.Count == 0) { return(result); } foreach (DataRow item in dt.Rows) { result.Add(item.Field <string>("SSJZ")); } return(result.OrderBy(x => x).ToList()); }
public List <FaultEntity> GetFaultsByClass(string[] deptname, string[] units, string specialty, int pagesize, int pageindex, out int total) { var db = new FaultContext(); var dt = db.GetFaultsByClass(deptname, units, specialty, pagesize, pageindex, out total); var result = new List <FaultEntity>(); if (dt == null && dt.Rows.Count == 0) { return(result); } foreach (DataRow item in dt.Rows) { var entity = new FaultEntity() { FaultId = item.Field <decimal>("SBFAULTID"), FaultNum = item.Field <string>("FAULTNUM"), Unit = item.Field <string>("SSJZ"), Specialty = item.Field <string>("ZY"), Category = item.Field <string>("QXFL"), FoundTime = item.Field <DateTime>("FXDATE"), FaultName = item.Field <string>("QXMC"), PlanCompleteTime = item.Field <DateTime?>("YQXQWCDATE"), Status = item.Field <string>("FAULTSTATUS"), ResolveGroup = item.Field <string>("XQBM"), DeviceName = item.Field <string>("DESCRIPTION"), RiskAnalysis = item.Field <string>("FXDFX"), RiskAssessment = item.Field <string>("ASSESSMENT"), Preventive = item.Field <string>("PREVENTIVE") }; result.Add(entity); } var faultids = result.Select(x => x.FaultId).ToList(); IRepository rep = new RepositoryFactory().BaseRepository(); var query = from q in rep.IQueryable <FaultRelationEntity>() where faultids.Contains(q.FaultId) select q.FaultId; var allocated = query.ToList(); result.ForEach(x => x.Allocated = allocated.Any(y => y == x.FaultId)); return(result); }
public List <FaultEntity> GetStatistical(string deptname, DateTime Start, DateTime End, string TeamType) { var db = new FaultContext(); var dt = db.GetStatistical(deptname, Start, End, TeamType); var result = new List <FaultEntity>(); if (dt == null && dt.Rows.Count == 0) { return(result); } foreach (DataRow item in dt.Rows) { var entity = new FaultEntity() { FaultId = item.Field <decimal>("SBFAULTID"), FaultNum = item.Field <string>("FAULTNUM"), Unit = item.Field <string>("SSJZ"), Specialty = item.Field <string>("ZY"), Category = item.Field <string>("QXFL"), FoundTime = item.Field <DateTime>("FXDATE"), FaultName = item.Field <string>("QXMC"), PlanCompleteTime = item.Field <DateTime?>("YQXQWCDATE"), Status = item.Field <string>("FAULTSTATUS"), TimeStatus = item.Field <string>("XQJSX"), ResolveGroup = item.Field <string>("XQBM"), DeviceName = item.Field <string>("DESCRIPTION") }; result.Add(entity); } //var faultids = result.Select(x => x.FaultId).ToList(); //IRepository rep = new RepositoryFactory().BaseRepository(); //var query = from q in rep.IQueryable<FaultRelationEntity>() // where faultids.Contains(q.FaultId) // select q.FaultId; //var allocated = query.ToList(); //result.ForEach(x => x.Allocated = allocated.Any(y => y == x.FaultId)); return(result); }
public FaultEntity GetDetail(decimal faultid) { var db = new FaultContext(); var dt = db.GetDetail(faultid); if (dt == null && dt.Rows.Count == 0) { return(null); } var result = new FaultEntity() { FaultId = dt.Rows[0].Field <decimal>("SBFAULTID"), FaultNum = dt.Rows[0].Field <string>("FAULTNUM"), Status = dt.Rows[0].Field <string>("FAULTSTATUS"), Unit = dt.Rows[0].Field <string>("SSJZ"), Specialty = dt.Rows[0].Field <string>("ZY"), FaultName = dt.Rows[0].Field <string>("QXMC"), DeviceName = dt.Rows[0].Field <string>("DESCRIPTION"), Category = dt.Rows[0].Field <string>("QXFL"), ResponsibleDepartment = dt.Rows[0].Field <string>("ZRBM"), PlanCompleteTime = dt.Rows[0].Field <DateTime?>("YQXQWCDATE"), ResolveGroup = dt.Rows[0].Field <string>("XQBM"), FoundPerson = dt.Rows[0].Field <string>("PERFXR"), FoundDepartment = dt.Rows[0].Field <string>("FXBM"), FoundTime = dt.Rows[0].Field <DateTime>("FXDATE"), Acceptor = dt.Rows[0].Field <string>("PERYSR"), AcceptanceDepartment = dt.Rows[0].Field <string>("YSBM"), AcceptanceTime = dt.Rows[0].Field <DateTime?>("YSDATE"), ResolveInTime = dt.Rows[0].Field <string>("XQJSX"), Qualified = dt.Rows[0].Field <string>("YSSFHG"), UndoReason = dt.Rows[0].Field <string>("UNTREATED") }; return(result); }