/// <summary>
/// 新增我的单据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddPersonalRecord(OracleConnection con, T_PF_PERSONALRECORD model)
{
try
{
string sql = @"INSERT INTO T_WF_PERSONALRECORD(PERSONALRECORDID,SYSTYPE,MODELCODE,MODELID,CHECKSTATE,OWNERID,OWNERPOSTID,OWNERDEPARTMENTID,
OWNERCOMPANYID,CONFIGINFO,MODELDESCRIPTION,ISFORWARD) VALUES
('" + Guid.NewGuid().ToString() + "','" + model.SYSTYPE + "','" + model.MODELCODE + "','" + model.MODELID + "'," + model.CHECKSTATE+ ",";
sql += @"'" + model.OWNERID + "','" + model.OWNERPOSTID + "','" + model.OWNERDEPARTMENTID + "',";
//sql += @"to_date('" + Convert.ToDateTime(entity.TRIGGERTIME).ToString("yyyy/MM/dd hh:mm") + "','YYYY-MM-DD hh24:mi:ss')
sql += @"'" + model.OWNERCOMPANYID + "','" + model.CONFIGINFO + "','" + model.MODELDESCRIPTION + "'," + (model.ISFORWARD == "1" ? 1 : 0) + ")";
Log.WriteLog("AddPersonalRecord():" + sql + "");
// dao.Open();
//LogHelper.WriteLog("新增我的单据 FormID=" + model.MODELID + "");
//return dao.ExecuteNonQuery(sql) > 0 ? true : false;
return MsOracle.ExecuteSQLByTransaction(con, sql) >= 0 ? true : false;
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "AddPersonalRecord()", "新增我的单据发生异常 FormID=" + model.MODELID + "", ex);
return false;
}
finally
{
// dao.Close();
}
}
/// <summary>
/// 我的单据新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddPersonalRecordList(T_PF_PERSONALRECORD model)
{
try
{
PersonalRecordDAL dal = new PersonalRecordDAL();
string recordID = dal.GetExistRecord(model.SYSTYPE, model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID, model.ISFORWARD);
if (recordID != "")
{
return dal.UpdatePersonalRecord(model, recordID);
}
else
{
var bol= dal.AddPersonalRecord(model);
if (bol)
{
PersonnelWS.PersonnelServiceClient HRClient = new PersonnelWS.PersonnelServiceClient();
var user = HRClient.GetEmployeeByID(model.OWNERID);
SendEmail("你有新的单据请登录系统查看!", user.EMAIL);
Log.WriteLog("FormID=" + model.MODELID + ";MODELDESCRIPTION=" + model.MODELDESCRIPTION + ";接收EMAIL=" + user.EMAIL+";所属人ID="+user.OWNERID);
}
return bol;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool UpdatePersonalRecord(T_PF_PERSONALRECORD model)
{
string message = "修改UpdatePersonalRecord():SYSTYPE:" + model.SYSTYPE + "||MODELCODE:" + model.MODELCODE + "||MODELID:" + model.MODELID + "||OWNERID" + model.OWNERID + "||OWNERCOMPANYID:" + model.OWNERCOMPANYID + "";
message += "||CHECKSTATE:" + model.CHECKSTATE + "||CONFIGINFO:" + model.CONFIGINFO + "||PERSONALRECORDID:" + model.PERSONALRECORDID + "||OWNERPOSTID" + model.OWNERPOSTID + "";
Record.WriteLogFunction(message);
PersonalRecordBLL bll = new PersonalRecordBLL();
return bll.UpdatePersonalRecord(model);
}
/// <summary>
/// 我的单据新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddPersonalRecord(T_PF_PERSONALRECORD model)
{
try
{
PersonalRecordDAL dal = new PersonalRecordDAL();
string recordID = dal.GetExistDoTask(model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID);
if (model.CHECKSTATE == "0" && string.IsNullOrWhiteSpace(recordID))
{
SMTEngine.EngineWcfGlobalFunctionClient client = new SMTEngine.EngineWcfGlobalFunctionClient();
client.TaskCacheReflesh(model.OWNERID);
return dal.AddDoTask(model);
}
else
{
return true; //修改状态该为流程来做
}
}
catch (Exception ex)
{
Tracer.Debug("新增我的代办 CHECKSTATE=" + model.MODELCODE + "Exception:"+ex.Message);
throw new Exception(ex.Message, ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="recordID"></param>
/// <returns></returns>
public bool UpdatePersonalRecord(T_PF_PERSONALRECORD model, string recordID)
{
try
{
string sql = "UPDATE T_WF_PERSONALRECORD SET CHECKSTATE=" + model.CHECKSTATE + ",CONFIGINFO='" + model.CONFIGINFO + "',MODELDESCRIPTION='" + model.MODELDESCRIPTION + "',";
sql += "UPDATEDATE=to_date('" + DateTime.Now.ToString("yyyy/MM/dd hh:mm") + "','YYYY-MM-DD hh24:mi') WHERE PERSONALRECORDID='" + recordID + "'";
Log.WriteLog("UpdatePersonalRecord():" + sql + "");
Tracer.Debug("修改我的单据 FormID=" + model.MODELID + " SQL语句＝" + sql);
return dao.ExecuteNonQuery(sql) >= 0 ? true : false;
}
catch (Exception ex)
{
Tracer.Debug("UpdatePersonalRecord()修改我的单据发生异常 FormID=" + model.MODELID + ""+ex.ToString());
return false;
}
finally
{
}
}
/// <summary>
/// 获取我的单据（两种状态；未提交、转发）
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public List<T_PF_PERSONALRECORD> GetPersonalRecordList(int pageSize, string strFilter, int pageIndex, string strOrderBy, ref int pageCount)
{
try
{
if (string.IsNullOrEmpty(strOrderBy))
{
strOrderBy = "CREATEDATE DESC";
}
if (pageSize == 0)
{
pageSize = 15;
}
int number = pageIndex <= 1 ? 1 : (pageIndex - 1) * pageSize + 1;
string countSql = @"SELECT count(1) from T_WF_PERSONALRECORD where (1=1)";
if (!string.IsNullOrWhiteSpace(strFilter))
{
countSql += strFilter + "";
}
string sql = @"SELECT * FROM (SELECT A.*, ROWNUM Page FROM (select * from T_WF_PERSONALRECORD
order by " + strOrderBy + " ) A WHERE (1=1) AND ROWNUM<= " + pageIndex * pageSize + "";
if (!string.IsNullOrWhiteSpace(strFilter))
{
sql += strFilter + ")";
}
sql += "WHERE Page >= " + number + "";
DataTable dt = dao.GetDataTable(sql);
Tracer.Debug("查找我的单据SQL："+sql);
pageCount = Convert.ToInt32(dao.ExecuteScalar(countSql));
//Tracer.Debug(countSql);
pageCount = pageCount / pageSize + (pageCount % pageSize > 0 ? 1 : 0);
List<T_PF_PERSONALRECORD> list = new List<T_PF_PERSONALRECORD>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
T_PF_PERSONALRECORD entity = new T_PF_PERSONALRECORD();
entity.PERSONALRECORDID = dr["PERSONALRECORDID"].ToString();
entity.SYSTYPE = dr["SYSTYPE"].ToString();
entity.MODELCODE = dr["MODELCODE"].ToString();
entity.MODELID = dr["MODELID"].ToString();
entity.CHECKSTATE = dr["CHECKSTATE"].ToString();
entity.MODELDESCRIPTION = dr["MODELDESCRIPTION"].ToString();
entity.CREATEDATE = Convert.ToDateTime(dr["CREATEDATE"].ToString());
entity.CONFIGINFO = dr["CHECKSTATE"].ToString() == "3" ? dr["CONFIGINFO"].ToString().Replace("<FormTypes>Audit", "<FormTypes>Resubmit").Replace("<FormTypes>Edit", "<FormTypes>Resubmit") : dr["CONFIGINFO"].ToString(); ;
list.Add(entity);
}
}
return list;
}
catch (Exception ex)
{
Tracer.Debug("GetPersonalRecordList()获取我的单据（两种状态；未提交、转发）"+ex.ToString());
return null;
}
finally
{
}
}
/// <summary>
/// 获取我的单据列表（三种状态，审核中，审核通过，审核不通过）
/// </summary>
/// <param name="strOrderBy"></param>
/// <param name="strCreateID"></param>
/// <param name="pageIndex"></param>
/// <param name="checkstate"></param>
/// <param name="strFilter"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List<T_PF_PERSONALRECORD> GetPersonalRecord(int pageSize, string strOrderBy, string strCreateID, int pageIndex, string checkstate, string strFilter,
string BeginDate, string EndDate, ref int pageCount)
{
try
{
if (string.IsNullOrEmpty(strOrderBy))
{
strOrderBy = "CREATEDATE DESC";
}
if (pageSize == 0)
{
pageSize = 15;
}
string filter = "";
if (!string.IsNullOrEmpty(checkstate))
{
filter += " AND CHECKSTATE=" + checkstate + "";
}
if (!string.IsNullOrEmpty(strCreateID))
{
filter += " AND CREATEUSERID='" + strCreateID + "'";
}
int number = pageIndex <= 1 ? 1 : (pageIndex - 1) * pageSize + 1;
string countSql = @"SELECT COUNT(1) FROM(
SELECT FORMID, MODELCODE FROM FLOW_FLOWRECORDMASTER_T WHERE (1=1) {0} GROUP BY FORMID,MODELCODE
) B
INNER JOIN (SELECT ORDERID,MODELCODE FROM T_WF_DOTASK GROUP BY ORDERID ,MODELCODE) C
ON C.ORDERID=B.FORMID AND B.MODELCODE=C.MODELCODE WHERE (1=1) ";
countSql = string.Format(countSql, filter);
string sql = @"SELECT D.*,C.DESCRIPTION FROM
(
SELECT B.SYSTYPE,B.MODELCODE,A.FORMID MODELID,A.CHECKSTATE,A.CREATEDATE,B.CONFIGINFO,rownum page FROM
(
SELECT FORMID,MAX(CHECKSTATE) CHECKSTATE,MAX(CREATEDATE) CREATEDATE, MODELCODE FROM FLOW_FLOWRECORDMASTER_T WHERE (1=1) {0} GROUP BY FORMID,MODELCODE ORDER BY CREATEDATE DESC
) A
INNER JOIN (SELECT ORDERID,MODELCODE,MAX(APPLICATIONURL) CONFIGINFO,MAX(SYSTEMCODE) SYSTYPE,MAX(CREATEDATETIME) CREATEDATE FROM T_WF_DOTASK GROUP BY ORDERID ,MODELCODE order by
CREATEDATE desc) B
ON B.ORDERID=A.FORMID AND A.MODELCODE=B.MODELCODE where rownum<={1}
) D
LEFT OUTER JOIN FLOW_MODELDEFINE_T C ON C.MODELCODE= D.MODELCODE where D.page>={2} order by D.CREATEDATE desc";
sql = string.Format(sql, filter, pageIndex * pageSize, number);
DataTable dt = dao.GetDataTable(sql);
pageCount = Convert.ToInt32(dao.ExecuteScalar(countSql));
pageCount = pageCount / pageSize + (pageCount % pageSize > 0 ? 1 : 0);
List<T_PF_PERSONALRECORD> list = new List<T_PF_PERSONALRECORD>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
T_PF_PERSONALRECORD entity = new T_PF_PERSONALRECORD();
entity.PERSONALRECORDID = Guid.NewGuid().ToString();
entity.SYSTYPE = dr["SYSTYPE"].ToString();
entity.MODELCODE = dr["MODELCODE"].ToString();
entity.MODELID = dr["MODELID"].ToString();
entity.CHECKSTATE = dr["CHECKSTATE"].ToString();
entity.MODELDESCRIPTION = string.Format("{0:F}", Convert.ToDateTime(dr["CREATEDATE"].ToString())) + " " + dr["DESCRIPTION"].ToString();
entity.CREATEDATE = Convert.ToDateTime(dr["CREATEDATE"].ToString());
entity.CONFIGINFO = dr["CHECKSTATE"].ToString() == "3" ? dr["CONFIGINFO"].ToString().Replace("Audit", "Resubmit").Replace("Edit", "Resubmit") : dr["CONFIGINFO"].ToString();
list.Add(entity);
}
}
return list;
}
catch (Exception ex)
{
Tracer.Debug(ex.ToString());
return null;
}
finally
{
}
}
public bool AddDoTask(T_PF_PERSONALRECORD model)
{
ClosedDoTaskStatus(model.SYSTYPE, model.MODELID, model.OWNERID);
try
{
string insSql = @"INSERT INTO T_WF_DOTASK (DOTASKID,COMPANYID,ORDERID,ORDERUSERID,ORDERUSERNAME,ORDERSTATUS,MESSAGEBODY,
APPLICATIONURL,RECEIVEUSERID,BEFOREPROCESSDATE,ENGINECODE,DOTASKTYPE,DOTASKSTATUS,MAILSTATUS,
RTXSTATUS,SYSTEMCODE,MODELCODE,REMARK)
VALUES (:DOTASKID,:COMPANYID,:ORDERID,:ORDERUSERID,:ORDERUSERNAME,:ORDERSTATUS,:MESSAGEBODY,
:APPLICATIONURL,:RECEIVEUSERID,:BEFOREPROCESSDATE,:ENGINECODE,:DOTASKTYPE,:DOTASKSTATUS,:MAILSTATUS,
:RTXSTATUS,:SYSTEMCODE,:MODELCODE,:REMARK)";
#region
#region
Parameter[] pageparm =
{
new Parameter(":DOTASKID",null),
new Parameter(":COMPANYID",null),
new Parameter(":ORDERID",null),
new Parameter(":ORDERUSERID",null),
new Parameter(":ORDERUSERNAME",null),
new Parameter(":ORDERSTATUS",null),
new Parameter(":MESSAGEBODY",null),
new Parameter(":APPLICATIONURL",null),
new Parameter(":RECEIVEUSERID",null),
new Parameter(":BEFOREPROCESSDATE",null),
new Parameter(":ENGINECODE",null),
new Parameter(":DOTASKTYPE",null),
new Parameter(":DOTASKSTATUS",null),
new Parameter(":MAILSTATUS",null),
new Parameter(":RTXSTATUS",null),
new Parameter(":SYSTEMCODE",null),
new Parameter(":MODELCODE",null),
new Parameter(":REMARK",null),
};
#endregion
pageparm[0].ParameterValue = GetValue(Guid.NewGuid().ToString());//待办任务ID
pageparm[1].ParameterValue = GetValue(model.OWNERCOMPANYID);//公司ID
pageparm[2].ParameterValue = GetValue(model.MODELID);//单据ID
pageparm[3].ParameterValue = GetValue(model.OWNERID);//单据所属人ID
pageparm[4].ParameterValue = GetValue("");//单据所属人名称
pageparm[5].ParameterValue = GetValue(0);//单据状态
pageparm[6].ParameterValue = GetValue(model.MODELDESCRIPTION);
pageparm[7].ParameterValue = GetValue(model.CONFIGINFO);
pageparm[8].ParameterValue = GetValue(model.OWNERID);
pageparm[9].ParameterValue = GetValue(DateTime.Now.AddDays(3));
pageparm[10].ParameterValue = GetValue("");//
pageparm[11].ParameterValue = GetValue(4);//待办任务类型(0、待办任务、1、流程咨询、3 )
pageparm[12].ParameterValue = GetValue(0);//代办任务状态(0、未处理 1、已处理 、2、任务撤销 10、删除)
pageparm[13].ParameterValue = GetValue(1);//邮件状态(0、未发送 1、已发送、2、未知 )
pageparm[14].ParameterValue = GetValue(1);//RTX状态(0、未发送 1、已发送、2、未知 )
pageparm[15].ParameterValue = GetValue(model.SYSTYPE);
pageparm[16].ParameterValue = GetValue(model.MODELCODE);
pageparm[17].ParameterValue = GetValue("未提交单据");
#endregion
ParameterCollection paras = new ParameterCollection();
foreach (var item in pageparm)
{
paras.Add(item);
}
return dao.ExecuteNonQuery(insSql, CommandType.Text, paras) > 0 ? true : false;
}
catch (Exception ex)
{
Tracer.Debug("新增未提交单据待办消息出错:" + ex);
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// 调整内容，原来是写入我的单据的数据，现在改为代办，查询做删除的时间要删除代办
/// </summary>
/// <param name="sysType"></param>
/// <param name="modelCode"></param>
/// <param name="modelID"></param>
/// <param name="IsForward"></param>
/// <returns></returns>
public T_PF_PERSONALRECORD GetEntity(string sysType, string modelCode, string modelID, string IsForward)
{
try
{
string sql = "SELECT * FROM T_WF_DOTASK WHERE (1=1)";
if (!string.IsNullOrEmpty(sysType))
{
sql += " AND SYSTEMCODE='" + sysType + "'";
}
if (!string.IsNullOrEmpty(modelCode))
{
sql += " AND MODELCODE ='" + modelCode + "'";
}
if (!string.IsNullOrEmpty(modelID))
{
sql += " AND ORDERID='" + modelID + "'";
}
sql += " AND DOTASKSTATUS = 0";
T_PF_PERSONALRECORD record = new T_PF_PERSONALRECORD();
DataTable dt = dao.GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
record.PERSONALRECORDID = dt.Rows[0]["DOTASKID"].ToString();
record.SYSTYPE = dt.Rows[0]["SYSTEMCODE"].ToString();
record.MODELCODE = dt.Rows[0]["MODELCODE"].ToString();
record.MODELID = dt.Rows[0]["ORDERID"].ToString();
record.CHECKSTATE = "0";
record.OWNERID = dt.Rows[0]["RECEIVEUSERID"].ToString();
//record.OWNERPOSTID = dt.Rows[0]["OWNERPOSTID"].ToString();
//record.OWNERDEPARTMENTID = dt.Rows[0]["OWNERDEPARTMENTID"].ToString();
//record.OWNERCOMPANYID = dt.Rows[0]["OWNERCOMPANYID"].ToString();
record.CONFIGINFO = dt.Rows[0]["APPLICATIONURL"].ToString();
//record.MODELDESCRIPTION = dt.Rows[0]["MODELDESCRIPTION"].ToString();
//record.ISFORWARD = dt.Rows[0]["ISFORWARD"].ToString();
//record.ISVIEW = dt.Rows[0]["ISVIEW"].ToString();
record.CREATEDATE = Convert.ToDateTime(dt.Rows[0]["CREATEDATETIME"].ToString());
}
return record;
}
catch (Exception ex)
{
Tracer.Debug( "GetEntity()获取我的单据代办实体"+ex.ToString());
return null;
}
finally
{
}
}
public T_PF_PERSONALRECORD GetEntity(string RecordID)
{
try
{
string sql = "SELECT * FROM T_WF_PERSONALRECORD WHERE PERSONALRECORDID='" + RecordID + "'";
T_PF_PERSONALRECORD record = new T_PF_PERSONALRECORD();
DataTable dt = dao.GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
record.PERSONALRECORDID = dt.Rows[0]["PERSONALRECORDID"].ToString();
record.SYSTYPE = dt.Rows[0]["SYSTYPE"].ToString();
record.MODELCODE = dt.Rows[0]["MODELCODE"].ToString();
record.MODELID = dt.Rows[0]["MODELID"].ToString();
record.CHECKSTATE = dt.Rows[0]["CHECKSTATE"].ToString();
record.OWNERID = dt.Rows[0]["OWNERID"].ToString();
record.OWNERPOSTID = dt.Rows[0]["OWNERPOSTID"].ToString();
record.OWNERDEPARTMENTID = dt.Rows[0]["OWNERDEPARTMENTID"].ToString();
record.OWNERCOMPANYID = dt.Rows[0]["OWNERCOMPANYID"].ToString();
record.CONFIGINFO = dt.Rows[0]["CONFIGINFO"].ToString();
record.MODELDESCRIPTION = dt.Rows[0]["MODELDESCRIPTION"].ToString();
record.ISFORWARD = dt.Rows[0]["ISFORWARD"].ToString();
record.ISVIEW = dt.Rows[0]["ISVIEW"].ToString();
record.CREATEDATE = Convert.ToDateTime(dt.Rows[0]["CREATEDATE"].ToString());
}
return record;
}
catch (Exception ex)
{
Tracer.Debug("GetEntity()获取单据实体"+ex.ToString());
return null;
}
finally
{
}
}
public bool AddPersonalRecord(T_PF_PERSONALRECORD model)
{
Tracer.Debug("新增AddPersonalRecord():SYSTYPE:" + model.SYSTYPE + "||MODELCODE:" + model.MODELCODE + "||MODELID:" + model.MODELID + "||OWNERID" + model.OWNERID + "||转发ISFORWARD:" + model.ISFORWARD + "");
PersonalRecordBLL bll = new PersonalRecordBLL();
return bll.AddPersonalRecord(model);
}
/// <summary>
/// 修改的单据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdatePersonalRecord(T_PF_PERSONALRECORD model)
{
PersonalRecordDAL dal = new PersonalRecordDAL();
if (string.IsNullOrWhiteSpace(model.PERSONALRECORDID))
{
string recordID = dal.GetExistRecord(model.SYSTYPE, model.MODELCODE, model.MODELID, model.OWNERID, model.OWNERCOMPANYID, model.ISFORWARD);
return dal.UpdatePersonalRecord(model, recordID);
}
else
{
return dal.UpdatePersonalRecord(model, model.PERSONALRECORDID);
}
}
/// <summary>
/// 我的单据新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddPersonalRecord( SubmitData submitData, string state, FlowUser user, FLOW_FLOWRECORDMASTER_T entity)
{
try
{
string SystemCode = string.Empty;
string modeCode = string.Empty;
string modeName = string.Empty;
string strEntityKey = string.Empty;
string msgOpen = string.Empty;
string strBusiness = submitData.XML;
SetFileFromBusinessXml(strBusiness, ref SystemCode, ref modeCode, ref modeName, ref strEntityKey, ref msgOpen);
Tracer.Debug("在填写我的单据时候的参数CHECKSTATE:" + state + "||模块名称：" + user.ModelName);
T_PF_PERSONALRECORD model = new T_PF_PERSONALRECORD();
model.SYSTYPE = user.SysCode;
model.PERSONALRECORDID = Guid.NewGuid().ToString();
model.ISFORWARD = "0";
model.ISVIEW = "0";
switch (state)
{
case "1":
model.MODELCODE = submitData.ModelCode;
model.MODELID = submitData.FormID;
if (string.IsNullOrWhiteSpace(submitData.SumbitUserID) && string.IsNullOrWhiteSpace(submitData.SumbitCompanyID))
{
//预算有这样情况submitData.SumbitUserID为空
model.OWNERCOMPANYID = submitData.ApprovalUser.CompanyID;
model.OWNERDEPARTMENTID = submitData.ApprovalUser.DepartmentID;
model.OWNERID = submitData.ApprovalUser.UserID;
model.OWNERPOSTID = submitData.ApprovalUser.PostID;
}
else
{
model.OWNERCOMPANYID = submitData.SumbitCompanyID;
model.OWNERDEPARTMENTID = submitData.SumbitDeparmentID;
model.OWNERID = submitData.SumbitUserID;
model.OWNERPOSTID = submitData.SumbitPostID;
}
model.MODELDESCRIPTION = string.Format("您{0}的[{1}]正在审核中！", DateTime.Now.ToString("MM月dd日HH:mm"), user.ModelName.Trim());
break;
case "2":
model.MODELID = submitData.FormID;
model.MODELCODE = entity.MODELCODE;
model.MODELDESCRIPTION = string.Format("您{0}的[{1}]已经审核通过！", entity.CREATEDATE.Value.ToString("MM月dd日HH:mm"), user.ModelName.Trim());
break;
case "3":
model.MODELID = submitData.FormID;
model.MODELCODE = entity.MODELCODE;
model.MODELDESCRIPTION = string.Format("您{0}的[{1}]已经审核不通过！", entity.CREATEDATE.Value.ToString("MM月dd日HH:mm"), user.ModelName.Trim());
break;
}
model.CHECKSTATE = state;
model.CREATEDATE = DateTime.Now;
model.CONFIGINFO = msgOpen;// ConvertXML(submitData);
if (!string.IsNullOrWhiteSpace(model.CONFIGINFO))
{
EnginFlowDAL dal = new EnginFlowDAL();
string recordID = dal.GetExistRecord(model.SYSTYPE, model.MODELCODE, model.MODELID, model.ISFORWARD);
if (recordID != "")
{
return dal.UpdatePersonalRecord(model, recordID);
}
else
{
return dal.AddPersonalRecord(model);
}
}
else
{
Tracer.Debug("在填写我的单据时候获取不到配置FormID:" + submitData.FormID + "");
}
return false;
}
catch (Exception ex)
{
Tracer.Debug("在填写我的单据时候错误FormID:" + submitData.FormID + "||Exception" + ex.Message);
throw new Exception(ex.Message, ex);
}
}
public bool AddDoTask(T_PF_PERSONALRECORD model)
{
ClosedDoTaskStatus(model.SYSTYPE, model.MODELID, model.OWNERID);
try
{
using (OracleConnection con = new OracleConnection(dao.DatabaseString))
{
string insSql = @"INSERT INTO T_WF_DOTASK (DOTASKID,COMPANYID,ORDERID,ORDERUSERID,ORDERUSERNAME,ORDERSTATUS,MESSAGEBODY,
APPLICATIONURL,RECEIVEUSERID,BEFOREPROCESSDATE,ENGINECODE,DOTASKTYPE,DOTASKSTATUS,MAILSTATUS,
RTXSTATUS,SYSTEMCODE,MODELCODE,REMARK)
VALUES (:DOTASKID,:COMPANYID,:ORDERID,:ORDERUSERID,:ORDERUSERNAME,:ORDERSTATUS,:MESSAGEBODY,
:APPLICATIONURL,:RECEIVEUSERID,:BEFOREPROCESSDATE,:ENGINECODE,:DOTASKTYPE,:DOTASKSTATUS,:MAILSTATUS,
:RTXSTATUS,:SYSTEMCODE,:MODELCODE,:REMARK)";
#region
#region
OracleParameter[] pageparm =
{
new OracleParameter(":DOTASKID",OracleType.NVarChar,100),
new OracleParameter(":COMPANYID",OracleType.NVarChar,100),
new OracleParameter(":ORDERID",OracleType.NVarChar,100),
new OracleParameter(":ORDERUSERID",OracleType.NVarChar,100),
new OracleParameter(":ORDERUSERNAME",OracleType.NVarChar,100),
new OracleParameter(":ORDERSTATUS",OracleType.Number),
new OracleParameter(":MESSAGEBODY",OracleType.NVarChar,4000),
new OracleParameter(":APPLICATIONURL",OracleType.NVarChar,2000),
new OracleParameter(":RECEIVEUSERID",OracleType.NVarChar,100),
new OracleParameter(":BEFOREPROCESSDATE",OracleType.DateTime),
new OracleParameter(":ENGINECODE",OracleType.NVarChar,100),
new OracleParameter(":DOTASKTYPE",OracleType.Number),
new OracleParameter(":DOTASKSTATUS",OracleType.Number),
new OracleParameter(":MAILSTATUS",OracleType.Number),
new OracleParameter(":RTXSTATUS",OracleType.Number),
new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100),
new OracleParameter(":MODELCODE",OracleType.NVarChar,100),
new OracleParameter(":REMARK",OracleType.NVarChar,200),
};
#endregion
pageparm[0].Value = MsOracle.GetValue(Guid.NewGuid().ToString());//待办任务ID
pageparm[1].Value = MsOracle.GetValue(model.OWNERCOMPANYID);//公司ID
pageparm[2].Value = MsOracle.GetValue(model.MODELID);//单据ID
pageparm[3].Value = MsOracle.GetValue(model.OWNERID);//单据所属人ID
pageparm[4].Value = MsOracle.GetValue("");//单据所属人名称
pageparm[5].Value = MsOracle.GetValue(0);//单据状态
pageparm[6].Value = MsOracle.GetValue(model.MODELDESCRIPTION);
pageparm[7].Value = MsOracle.GetValue(model.CONFIGINFO);
pageparm[8].Value = MsOracle.GetValue(model.OWNERID);
pageparm[9].Value = MsOracle.GetValue(DateTime.Now.AddDays(3));
pageparm[10].Value = MsOracle.GetValue("");//
pageparm[11].Value = MsOracle.GetValue(4);//待办任务类型(0、待办任务、1、流程咨询、3 )
pageparm[12].Value = MsOracle.GetValue(0);//代办任务状态(0、未处理 1、已处理 、2、任务撤销 10、删除)
pageparm[13].Value = MsOracle.GetValue(1);//邮件状态(0、未发送 1、已发送、2、未知 )
pageparm[14].Value = MsOracle.GetValue(1);//RTX状态(0、未发送 1、已发送、2、未知 )
pageparm[15].Value = MsOracle.GetValue(model.SYSTYPE);
pageparm[16].Value = MsOracle.GetValue(model.MODELCODE);
pageparm[17].Value = MsOracle.GetValue("未提交单据");
#endregion
return MsOracle.ExecuteNonQuery(con, CommandType.Text, insSql, pageparm) > 0 ? true : false;
}
}
catch (Exception ex)
{
LogHelper.WriteLog("新增未提交单据待办消息出错:" + ex);
throw new Exception(ex.Message, ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="recordID"></param>
/// <returns></returns>
public bool UpdatePersonalRecord(OracleConnection con, T_PF_PERSONALRECORD model, string recordID)
{
try
{
string sql = "UPDATE T_WF_PERSONALRECORD SET CHECKSTATE=" + model.CHECKSTATE + ",CONFIGINFO='" + model.CONFIGINFO + "',MODELDESCRIPTION='" +model.MODELDESCRIPTION + "',";
sql += "UPDATEDATE=to_date('" + DateTime.Now.ToString("yyyy/MM/dd hh:mm") + "','YYYY-MM-DD hh24:mi') WHERE PERSONALRECORDID='" + recordID + "'";
Log.WriteLog("UpdatePersonalRecord():" + sql + "");
//dao.Open();
LogHelper.WriteLog("修改我的单据 FormID=" + model.MODELID + " SQL语句＝" + sql);
// return dao.ExecuteNonQuery(sql) >= 0 ? true : false;
return MsOracle.ExecuteSQLByTransaction(con, sql) >= 0 ? true : false;
}
catch (Exception ex)
{
LogHelper.WriteLog(this, "UpdatePersonalRecord()", "修改我的单据发生异常 FormID=" + model.MODELID + "", ex);
return false;
}
finally
{
// dao.Close();
}
}