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