protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { //插入新纪录,应先做检查是否合法 FaultEntity fauEntity = new FaultEntity(); fauEntity.COMPANY_CODE = theCompanyCode; fauEntity.FAULT_CODE = e.NewValues["FAULT_CODE"].ToString().Trim(); fauEntity.FAULT_NAME = e.NewValues["FAULT_NAME"].ToString().Trim(); fauEntity.FAULT_DESC = e.NewValues["FAULT_DESC"].ToString().Trim(); fauEntity.FAULT_CLASS = e.NewValues["FAULT_CLASS"].ToString().Trim(); fauEntity.FAULT_TYPE = e.NewValues["FAULT_TYPE"].ToString().Trim(); fauEntity.INPUT_TIME = DateTime.Now; fauEntity.INPUT_PERSON = theUserId; db.Insert(fauEntity); //插入到日志表20161101 try { string Sql2 = "INSERT INTO CODE_FAULT_LOG (RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,user_code,flag,rqsj)" + " SELECT RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,'" + theUserCode + "' , 'ADD', SYSDATE FROM CODE_FAULT WHERE FAULT_CODE = '" + e.NewValues["FAULT_CODE"].ToString().Trim() + "' AND FAULT_NAME = '" + e.NewValues["FAULT_NAME"].ToString().Trim() + "' "; dc.ExeSql(Sql2); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { //判断当前记录是否可以删除 //string strDelCode = e.Values["PLAN_CODE"].ToString(); string rmes_id = e.Values["RMES_ID"].ToString(); FaultEntity fauEntity = new FaultEntity { RMES_ID = rmes_id }; //插入到日志表20161101 try { string Sql2 = "INSERT INTO CODE_FAULT_LOG (RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,user_code,flag,rqsj)" + " SELECT RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,'" + theUserCode + "' , 'DEL', SYSDATE FROM CODE_FAULT WHERE RMES_ID = '" + rmes_id + "'"; dc.ExeSql(Sql2); } catch { return; } db.Delete(fauEntity); setCondition(); e.Cancel = true; }
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { //修改记录 string rmes_id = e.OldValues["RMES_ID"].ToString(); FaultEntity fauEntity = db.First <FaultEntity>("where RMES_ID=@0", rmes_id); fauEntity.FAULT_CODE = e.NewValues["FAULT_CODE"].ToString().Trim(); fauEntity.FAULT_NAME = e.NewValues["FAULT_NAME"].ToString().Trim(); fauEntity.FAULT_DESC = e.NewValues["FAULT_DESC"].ToString().Trim(); fauEntity.FAULT_CLASS = e.NewValues["FAULT_CLASS"].ToString().Trim(); fauEntity.FAULT_TYPE = e.NewValues["FAULT_TYPE"].ToString().Trim(); fauEntity.INPUT_TIME = DateTime.Now; fauEntity.INPUT_PERSON = theUserId; db.Update(fauEntity); //插入到日志表20161101 try { string Sql2 = "INSERT INTO CODE_FAULT_LOG (RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,user_code,flag,rqsj)" + " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.OldValues["FAULT_CODE"].ToString() + "'," + e.OldValues["FAULT_NAME"].ToString() + "','" + e.OldValues["FAULT_DESC"].ToString() + "','" + e.OldValues["FAULT_CLASS"].ToString() + "','" + e.OldValues["FAULT_TYPE"].ToString() + "','" + theUserCode + "','BEFOREEDIT',SYSDATE) "; dc.ExeSql(Sql2); string Sql3 = "INSERT INTO CODE_FAULT_LOG (RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,user_code,flag,rqsj)" + " VALUES( '" + rmes_id + "','" + theCompanyCode + "','" + e.NewValues["FAULT_CODE"].ToString() + "'," + e.NewValues["FAULT_NAME"].ToString() + "','" + e.NewValues["FAULT_DESC"].ToString() + "','" + e.NewValues["FAULT_CLASS"].ToString() + "','" + e.NewValues["FAULT_TYPE"].ToString() + "','" + theUserCode + "','AFTEREDIT',SYSDATE) "; dc.ExeSql(Sql3); } catch { return; } e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
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); }