/// <summary> /// 更新: [咨询] /// </summary> /// <param name="model">FLOW_CONSULTATION_T</param> /// <returns></returns> public static int Update(OracleConnection con, FLOW_CONSULTATION_T model) { try { if (con.State != ConnectionState.Open) { con.Open(); } model.REPLYDATE = DateTime.Now; model.FLAG = "1"; string updSql = "UPDATE FLOW_CONSULTATION_T SET FLOWRECORDDETAILID=:FLOWRECORDDETAILID,CONSULTATIONUSERID=:CONSULTATIONUSERID,CONSULTATIONUSERNAME=:CONSULTATIONUSERNAME,CONSULTATIONCONTENT=:CONSULTATIONCONTENT,CONSULTATIONDATE=:CONSULTATIONDATE,REPLYUSERID=:REPLYUSERID,REPLYUSERNAME=:REPLYUSERNAME,REPLYCONTENT=:REPLYCONTENT,REPLYDATE=:REPLYDATE,FLAG=:FLAG WHERE CONSULTATIONID=:CONSULTATIONID"; OracleParameter[] pageparm = { new OracleParameter(":CONSULTATIONID", OracleType.NVarChar), new OracleParameter(":FLOWRECORDDETAILID", OracleType.NVarChar), new OracleParameter(":CONSULTATIONUSERID", OracleType.NVarChar), new OracleParameter(":CONSULTATIONUSERNAME", OracleType.NVarChar), new OracleParameter(":CONSULTATIONCONTENT", OracleType.NVarChar), new OracleParameter(":CONSULTATIONDATE", OracleType.DateTime), new OracleParameter(":REPLYUSERID", OracleType.NVarChar), new OracleParameter(":REPLYUSERNAME", OracleType.NVarChar), new OracleParameter(":REPLYCONTENT", OracleType.NVarChar), new OracleParameter(":REPLYDATE", OracleType.DateTime), new OracleParameter(":FLAG", OracleType.NVarChar) }; pageparm[0].Value = MsOracle.GetValue(model.CONSULTATIONID); // pageparm[1].Value = MsOracle.GetValue(model.FLOW_FLOWRECORDDETAIL_T.FLOWRECORDDETAILID); // pageparm[2].Value = MsOracle.GetValue(model.CONSULTATIONUSERID); // pageparm[3].Value = MsOracle.GetValue(model.CONSULTATIONUSERNAME); // pageparm[4].Value = MsOracle.GetValue(model.CONSULTATIONCONTENT); // pageparm[5].Value = MsOracle.GetValue(model.CONSULTATIONDATE); // pageparm[6].Value = MsOracle.GetValue(model.REPLYUSERID); // pageparm[7].Value = MsOracle.GetValue(model.REPLYUSERNAME); // pageparm[8].Value = MsOracle.GetValue(model.REPLYCONTENT); // pageparm[9].Value = MsOracle.GetValue(model.REPLYDATE); // pageparm[10].Value = MsOracle.GetValue(model.FLAG); //0未回复,1回复 return(MsOracle.ExecuteSQLByTransaction(con, updSql, pageparm)); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw new Exception("FLOW_CONSULTATION_TDAL_Update:" + ex.Message); } }
/// <summary> /// 新增[咨询] /// </summary> /// <param name="con">OracleConnection</param> /// <param name="model">FLOW_CONSULTATION_T</param> /// <returns></returns> public static int Add(OracleConnection con, FLOW_CONSULTATION_T model) { try { if (con.State != ConnectionState.Open) { con.Open(); } string insSql = "INSERT INTO FLOW_CONSULTATION_T (CONSULTATIONID,FLOWRECORDDETAILID,CONSULTATIONUSERID,CONSULTATIONUSERNAME,CONSULTATIONCONTENT,CONSULTATIONDATE,REPLYUSERID,REPLYUSERNAME,REPLYCONTENT,REPLYDATE,FLAG) VALUES (:CONSULTATIONID,:FLOWRECORDDETAILID,:CONSULTATIONUSERID,:CONSULTATIONUSERNAME,:CONSULTATIONCONTENT,:CONSULTATIONDATE,:REPLYUSERID,:REPLYUSERNAME,:REPLYCONTENT,:REPLYDATE,:FLAG)"; OracleParameter[] pageparm = { new OracleParameter(":CONSULTATIONID", OracleType.NVarChar), new OracleParameter(":FLOWRECORDDETAILID", OracleType.NVarChar), new OracleParameter(":CONSULTATIONUSERID", OracleType.NVarChar), new OracleParameter(":CONSULTATIONUSERNAME", OracleType.NVarChar), new OracleParameter(":CONSULTATIONCONTENT", OracleType.NVarChar), new OracleParameter(":CONSULTATIONDATE", OracleType.DateTime), new OracleParameter(":REPLYUSERID", OracleType.NVarChar), new OracleParameter(":REPLYUSERNAME", OracleType.NVarChar), new OracleParameter(":REPLYCONTENT", OracleType.NVarChar), new OracleParameter(":REPLYDATE", OracleType.DateTime), new OracleParameter(":FLAG", OracleType.NVarChar) }; pageparm[0].Value = MsOracle.GetValue(model.CONSULTATIONID); // pageparm[1].Value = MsOracle.GetValue(model.FLOW_FLOWRECORDDETAIL_T.FLOWRECORDDETAILID); // pageparm[2].Value = MsOracle.GetValue(model.CONSULTATIONUSERID); // pageparm[3].Value = MsOracle.GetValue(model.CONSULTATIONUSERNAME); // pageparm[4].Value = MsOracle.GetValue(model.CONSULTATIONCONTENT); // pageparm[5].Value = MsOracle.GetValue(model.CONSULTATIONDATE); // pageparm[6].Value = MsOracle.GetValue(model.REPLYUSERID); // pageparm[7].Value = MsOracle.GetValue(model.REPLYUSERNAME); // pageparm[8].Value = MsOracle.GetValue(model.REPLYCONTENT); // pageparm[9].Value = MsOracle.GetValue(model.REPLYDATE); // pageparm[10].Value = MsOracle.GetValue(model.FLAG); //0未回复,1回复 return(MsOracle.ExecuteSQLByTransaction(con, insSql, pageparm)); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw new Exception("FLOW_CONSULTATION_TDAL_Add:" + ex.Message); } }
/// <summary> /// 更新元数据 /// </summary> /// <param name="formid">formid</param> /// <param name="xml"></param> /// <returns></returns> public static bool UpdateMetadataByFormid(string formid, string xml) { try { string sql = "UPDATE FLOW_FLOWRECORDMASTER_T set BUSINESSOBJECT=:BUSINESSOBJECT where FORMID=:FORMID "; string sql2 = "UPDATE T_WF_DOTASK set APPXML=:APPXML where ORDERID=:FORMID "; using (OracleConnection con = new OracleConnection(ADOHelper.ContextOracleConnection)) { try { con.Open(); MsOracle.BeginTransaction(con); #region 审核主表 OracleParameter[] pageparm = { new OracleParameter(":FORMID", OracleType.NVarChar), new OracleParameter(":BUSINESSOBJECT", OracleType.Clob) }; pageparm[0].Value = MsOracle.GetValue(formid); // pageparm[1].Value = MsOracle.GetValue(xml); // int n = MsOracle.ExecuteSQLByTransaction(con, sql, pageparm); LogHelper.WriteLog("时间:" + DateTime.Now.ToString() + "UpdateMetadataByFormid:【审核主表FLOW_FLOWRECORDMASTER_T】[更新元数据]成功 影响记录数:" + n + ";formid=" + formid + ";xml=" + xml); #endregion #region 待办任务 OracleParameter[] pageparm2 = { new OracleParameter(":FORMID", OracleType.NVarChar), new OracleParameter(":APPXML", OracleType.Clob) }; pageparm2[0].Value = MsOracle.GetValue(formid); // pageparm2[1].Value = MsOracle.GetValue(xml); // int n2 = MsOracle.ExecuteSQLByTransaction(con, sql2, pageparm2); LogHelper.WriteLog("时间:" + DateTime.Now.ToString() + "UpdateMetadataByFormid:【待办任务T_WF_DOTASK】[更新元数据]成功 影响记录数:" + n2 + ";formid=" + formid + ";xml=" + xml); #endregion MsOracle.CommitTransaction(con); if ((n + n2) > 0) { return(true); } else { return(false); } } catch (Exception ex) { LogHelper.WriteLog("更新元数据 UpdateMetadataByFormid 异常信息:" + ex.Message); return(false); } finally { if (con.State == ConnectionState.Open) { con.Close(); } LogHelper.WriteLog("更新元数据:UpdateMetadataByFormid-> SQL=" + sql); } } } catch (Exception ex) { LogHelper.WriteLog("更新元数据:UpdateMetadataByFormid:异常信息:" + ex.Message); return(false); } }
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); } }