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