/// <summary>
/// 运维人员处理异常记录
/// </summary>
/// <param name="conn">OracleConnection</param>
/// <param name="model">FLOW_EXCEPTIONLOG</param>
/// <returns></returns>
public int Update(OracleConnection conn, FLOW_EXCEPTIONLOG model)
{
try
{
string updSql = "UPDATE FLOW_EXCEPTIONLOG SET STATE=:STATE,UPDATEDATE=:UPDATEDATE,UPDATENAME=:UPDATENAME,REMARK=:REMARK WHERE ID=:ID";
OracleParameter[] pageparm =
{
new OracleParameter(":ID", OracleType.NVarChar, 100),
new OracleParameter(":STATE", OracleType.NVarChar, 100),
new OracleParameter(":UPDATEDATE", OracleType.DateTime),
new OracleParameter(":UPDATENAME", OracleType.NVarChar, 100),
new OracleParameter(":REMARK", OracleType.NVarChar, 4000)
};
pageparm[0].Value = OracleDataProvider.GetValue(model.ID); //主键ID
pageparm[1].Value = OracleDataProvider.GetValue(model.STATE); //状态:未处理;已处理
pageparm[2].Value = OracleDataProvider.GetValue(DateTime.Now); //处理日期
pageparm[3].Value = OracleDataProvider.GetValue(model.UPDATENAME); //处理人
pageparm[4].Value = OracleDataProvider.GetValue(model.REMARK); //备注
return(ExecuteSQL(conn, updSql, pageparm));
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
/// <summary>
/// 增加异常记录(以实体传值)
/// </summary>
/// <param name="conn">OracleConnection </param>
/// <param name="model">FLOW_EXCEPTIONLOG</param>
/// <returns></returns>
public int Add(OracleConnection conn, FLOW_EXCEPTIONLOG model)
{
try
{
string insSql = "INSERT INTO FLOW_EXCEPTIONLOG (ID,FORMID,MODELCODE,CREATEDATE,CREATENAME,SUBMITINFO,LOGINFO,MODELNAME,OWNERID,OWNERNAME,OWNERCOMPANYID,OWNERCOMPANYNAME,OWNERDEPARMENTID,OWNERDEPARMENTNAME,OWNERPOSTID,OWNERPOSTNAME,AUDITSTATE) VALUES (:ID,:FORMID,:MODELCODE,:CREATEDATE,:CREATENAME,:SUBMITINFO,:LOGINFO,:MODELNAME,:OWNERID,:OWNERNAME,:OWNERCOMPANYID,:OWNERCOMPANYNAME,:OWNERDEPARMENTID,:OWNERDEPARMENTNAME,:OWNERPOSTID,:OWNERPOSTNAME,:AUDITSTATE)";
OracleParameter[] pageparm =
{
new OracleParameter(":ID", OracleType.NVarChar, 100),
new OracleParameter(":FORMID", OracleType.NVarChar, 100),
new OracleParameter(":MODELCODE", OracleType.NVarChar, 100),
new OracleParameter(":CREATEDATE", OracleType.DateTime),
new OracleParameter(":CREATENAME", OracleType.NVarChar, 100),
new OracleParameter(":SUBMITINFO", OracleType.NVarChar, 4000),
new OracleParameter(":LOGINFO", OracleType.Clob),
new OracleParameter(":MODELNAME", OracleType.NVarChar, 100),
new OracleParameter(":OWNERID", OracleType.NVarChar, 100),
new OracleParameter(":OWNERNAME", OracleType.NVarChar, 100),
new OracleParameter(":OWNERCOMPANYID", OracleType.NVarChar, 100),
new OracleParameter(":OWNERCOMPANYNAME", OracleType.NVarChar, 100),
new OracleParameter(":OWNERDEPARMENTID", OracleType.NVarChar, 100),
new OracleParameter(":OWNERDEPARMENTNAME", OracleType.NVarChar, 100),
new OracleParameter(":OWNERPOSTID", OracleType.NVarChar, 100),
new OracleParameter(":OWNERPOSTNAME", OracleType.NVarChar, 100),
new OracleParameter(":AUDITSTATE", OracleType.NVarChar, 100)
};
pageparm[0].Value = OracleDataProvider.GetValue(model.ID); //主键ID
pageparm[1].Value = OracleDataProvider.GetValue(model.FORMID); //业务ID
pageparm[2].Value = OracleDataProvider.GetValue(model.MODELCODE); //模块代码
pageparm[3].Value = OracleDataProvider.GetValue(model.CREATEDATE); //创建日期
pageparm[4].Value = OracleDataProvider.GetValue(model.CREATENAME); //创建人
pageparm[5].Value = OracleDataProvider.GetValue(model.SUBMITINFO); //提交信息
pageparm[6].Value = OracleDataProvider.GetValue(model.LOGINFO); //异常日志信息
pageparm[7].Value = OracleDataProvider.GetValue(model.MODELNAME); //模块名称
pageparm[8].Value = OracleDataProvider.GetValue(model.OWNERID); //单据所属人ID
pageparm[9].Value = OracleDataProvider.GetValue(model.OWNERNAME); //单据所属人姓名
pageparm[10].Value = OracleDataProvider.GetValue(model.OWNERCOMPANYID); //单据所属人公司ID
pageparm[11].Value = OracleDataProvider.GetValue(model.OWNERCOMPANYNAME); //单据所属人公司名称
pageparm[12].Value = OracleDataProvider.GetValue(model.OWNERDEPARMENTID); //单据所属人部门ID
pageparm[13].Value = OracleDataProvider.GetValue(model.OWNERDEPARMENTNAME); //单据所属人部门名称
pageparm[14].Value = OracleDataProvider.GetValue(model.OWNERPOSTID); //单据所属人岗位ID
pageparm[15].Value = OracleDataProvider.GetValue(model.OWNERPOSTNAME); //单据所属人岗位名称
pageparm[16].Value = OracleDataProvider.GetValue(model.AUDITSTATE); //审核状态;审核通过,审核不通过
return(ExecuteSQL(conn, insSql, pageparm));
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
/// <summary>
/// 将异常信息记录到流程监控表里
/// </summary>
/// <param name="submitData">SubmitData</param>
/// <param name="flowUser">FlowUser</param>
public static void AddFlowMonitor(SubmitData submitData, FlowUser flowUser)
{
try
{
#region 提交信息
StringBuilder sb = new StringBuilder();
sb.AppendLine("submitData.FlowSelectType =FlowSelectType." + submitData.FlowSelectType + ";");
sb.AppendLine("submitData.FormID = \"" + submitData.FormID + "\";");
sb.AppendLine("submitData.ModelCode = \"" + submitData.ModelCode + "\";");
sb.AppendLine("submitData.ApprovalUser = new UserInfo();");
sb.AppendLine("submitData.ApprovalUser.CompanyID = \"" + submitData.ApprovalUser.CompanyID + "\";");
sb.AppendLine("submitData.ApprovalUser.DepartmentID = \"" + submitData.ApprovalUser.DepartmentID + "\";");
sb.AppendLine("submitData.ApprovalUser.PostID = \"" + submitData.ApprovalUser.PostID + "\";");
sb.AppendLine("submitData.ApprovalUser.UserID = \"" + submitData.ApprovalUser.UserID + "\";");
sb.AppendLine("submitData.ApprovalUser.UserName = \"" + submitData.ApprovalUser.UserName + "\";");
sb.AppendLine("submitData.NextStateCode = \"" + (submitData.NextStateCode != null ? submitData.NextStateCode : "空") + "\";");
sb.AppendLine("submitData.NextApprovalUser = new UserInfo();");
sb.AppendLine("submitData.NextApprovalUser.CompanyID = \"" + (submitData.NextApprovalUser != null ? submitData.NextApprovalUser.CompanyID : "空") + "\";");
sb.AppendLine("submitData.NextApprovalUser.DepartmentID = \"" + (submitData.NextApprovalUser != null ? submitData.NextApprovalUser.DepartmentID : "空") + "\";");
sb.AppendLine("submitData.NextApprovalUser.PostID = \"" + (submitData.NextApprovalUser != null ? submitData.NextApprovalUser.PostID : "空") + "\";");
sb.AppendLine("submitData.NextApprovalUser.UserID = \"" + (submitData.NextApprovalUser != null ? submitData.NextApprovalUser.UserID : "空") + "\";");
sb.AppendLine("submitData.NextApprovalUser.UserName = \"" + (submitData.NextApprovalUser != null ? submitData.NextApprovalUser.UserName : "******") + "\";");
sb.AppendLine("submitData.SubmitFlag = SubmitFlag." + submitData.SubmitFlag + ";");
// sb.AppendLine("submitData.XML = \"" + submitData.XML + "\";");
sb.AppendLine("submitData.FlowType = FlowType." + submitData.FlowType.ToString() + ";");
sb.AppendLine("submitData.ApprovalResult = ApprovalResult." + submitData.ApprovalResult.ToString() + ";");
sb.AppendLine("submitData.ApprovalContent = \"" + submitData.ApprovalContent + "\";");
#region 提交人信息
sb.AppendLine("submitData.SumbitCompanyID = \"" + submitData.SumbitCompanyID + "\";");
sb.AppendLine("submitData.SumbitDeparmentID = \"" + submitData.SumbitDeparmentID + "\";");
sb.AppendLine("submitData.SumbitPostID = \"" + submitData.SumbitPostID + "\";");
sb.AppendLine("submitData.SumbitUserID = \"" + submitData.SumbitUserID + "\";");
sb.AppendLine("submitData.SumbitUserName = \"" + submitData.SumbitUserName + "\";");
#endregion
#endregion
FLOW_EXCEPTIONLOG entity = new FLOW_EXCEPTIONLOG();
entity.ID = Guid.NewGuid().ToString().Replace("-", ""); //主键ID
entity.FORMID = submitData.FormID; //业务ID
entity.MODELCODE = submitData.ModelCode; //模块代码
entity.CREATEDATE = DateTime.Now; //创建日期
entity.CREATENAME = submitData.SumbitUserID == null ? submitData.ApprovalUser.UserName : submitData.SumbitUserName; //创建人
entity.SUBMITINFO = sb.ToString(); //提交信息
entity.LOGINFO = flowUser.ErrorMsg; //异常日志信息
entity.MODELNAME = flowUser.ModelName; //模块名称
entity.OWNERID = submitData.ApprovalUser.UserID; //单据所属人ID
entity.OWNERNAME = submitData.ApprovalUser.UserName; //单据所属人姓名
entity.OWNERCOMPANYID = submitData.ApprovalUser.CompanyID; //单据所属人公司ID
entity.OWNERCOMPANYNAME = (submitData.SumbitUserID == submitData.ApprovalUser.UserID)?flowUser.CompayName: submitData.ApprovalUser.CompanyName; //单据所属人公司名称
entity.OWNERDEPARMENTID = submitData.ApprovalUser.DepartmentID; //单据所属人部门ID
entity.OWNERDEPARMENTNAME = (submitData.SumbitUserID == submitData.ApprovalUser.UserID) ? flowUser.DepartmentName : submitData.ApprovalUser.DepartmentName; //单据所属人部门名称
entity.OWNERPOSTID = submitData.ApprovalUser.PostID; //单据所属人岗位ID
entity.OWNERPOSTNAME = (submitData.SumbitUserID == submitData.ApprovalUser.UserID) ? flowUser.PostName : submitData.ApprovalUser.PostName; //单据所属人岗位名称
entity.AUDITSTATE = submitData.ApprovalResult == ApprovalResult.Pass ? "审核通过" : "审核不通过"; //审核状态;审核通过,审核不通过
FLOW_EXCEPTIONLOGDAL dal = new FLOW_EXCEPTIONLOGDAL();
dal.Add(dal.GetOracleConnection(), entity);
LogHelper.WriteLog("Formid=" + submitData.FormID + ";将异常信息记录到流程监控表里,成功!");
}
catch (Exception e)
{
LogHelper.WriteLog("Formid=" + submitData.FormID + ";将异常信息记录到流程监控表里,出错:异常信息:" + e.ToString());
// throw e;
}
}
