/// <summary> /// KPI调用 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="filterString"></param> /// <param name="paras"></param> /// <param name="pageCount"></param> /// <returns></returns> public List<SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T> GetModelFlowRelationInfosListBySearch(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount) { //OracleConnection con = ADOHelper.GetOracleConnection(); try { List<SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T> ents = new List<SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T>(); string sql = " select t.MODELFLOWRELATIONID,t.COMPANYID,t.DEPARTMENTID,t.FLOWCODE,a.DESCRIPTION,t.FLAG from smtwf.FLOW_MODELFLOWRELATION_T t left join smtwf.FLOW_FLOWDEFINE_T a on t.flowcode=a.flowcode"; if (!string.IsNullOrEmpty(sort)) { sql += " order by " + sort + ""; } DataTable dt = dao.GetDataTable( sql); foreach (DataRow row in dt.Rows) { SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T ent = new SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T(); ent.MODELFLOWRELATIONID = row["MODELFLOWRELATIONID"] == null ? "" : row["MODELFLOWRELATIONID"].ToString(); ent.MODELFLOWRELATIONID = row["COMPANYID"] == null ? "" : row["COMPANYID"].ToString(); ent.MODELFLOWRELATIONID = row["DEPARTMENTID"] == null ? "" : row["DEPARTMENTID"].ToString(); ent.MODELFLOWRELATIONID = row["FLOWCODE"] == null ? "" : row["FLOWCODE"].ToString(); ent.MODELFLOWRELATIONID = row["DESCRIPTION"] == null ? "" : row["DESCRIPTION"].ToString(); ent.MODELFLOWRELATIONID = row["FLAG"] == null ? "" : row["FLAG"].ToString(); ents.Add(ent); } IQueryable<SMT.Workflow.Common.Model.FLOW_MODELFLOWRELATION_T> listTemp = ents.AsQueryable(); int Count = ents.Count; pageCount = Count / pageSize + (Count % pageSize > 0 ? 1 : 0); var entList = listTemp.Skip((pageIndex - 1) * pageSize).Take(pageSize); return entList.ToList(); } catch (Exception ex) { return null; throw (ex); } finally { } }
/// <summary> /// 新增流程关系 /// </summary> /// <param name="conn">数据库链接</param> /// <param name="command">数据库命令</param> /// <param name="relation">关系实体</param> /// <returns>bool</returns> private bool AddRelation(FLOW_MODELFLOWRELATION_T relation) { try { // string relationSql = @"INSERT INTO FLOW_MODELFLOWRELATION_T (MODELFLOWRELATIONID,COMPANYID,DEPARTMENTID,COMPANYNAME,DEPARTMENTNAME, // SYSTEMCODE,MODELCODE,FLOWCODE,FLAG,FLOWTYPE,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID, // CREATEPOSTID,CREATEDATE,EDITUSERID,EDITUSERNAME,EDITDATE) VALUES (MODELFLOWRELATIONID,COMPANYID,DEPARTMENTID, // COMPANYNAME,DEPARTMENTNAME,SYSTEMCODE,MODELCODE,FLOWCODE,FLAG,FLOWTYPE,CREATEUSERID,CREATEUSERNAME, // CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE,EDITUSERID,EDITUSERNAME,EDITDATE)"; string relationSql = @"INSERT INTO FLOW_MODELFLOWRELATION_T (MODELFLOWRELATIONID,COMPANYID,DEPARTMENTID,COMPANYNAME,DEPARTMENTNAME, SYSTEMCODE,MODELCODE,FLOWCODE,FLAG,FLOWTYPE,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID, CREATEPOSTID,CREATEDATE,EDITUSERID,EDITUSERNAME,EDITDATE) VALUES (@MODELFLOWRELATIONID,@COMPANYID,@DEPARTMENTID, @COMPANYNAME,@DEPARTMENTNAME,@SYSTEMCODE,@MODELCODE,@FLOWCODE,@FLAG,@FLOWTYPE,@CREATEUSERID,@CREATEUSERNAME, @CREATECOMPANYID,@CREATEDEPARTMENTID,@CREATEPOSTID,@CREATEDATE,@EDITUSERID,@EDITUSERNAME,@EDITDATE)"; Parameter[] relationParm = { new Parameter("@MODELFLOWRELATIONID",null), new Parameter("@COMPANYID",null), new Parameter("@DEPARTMENTID",null), new Parameter("@COMPANYNAME",null), new Parameter("@DEPARTMENTNAME",null), new Parameter("@SYSTEMCODE",null), new Parameter("@MODELCODE",null), new Parameter("@FLOWCODE",null), new Parameter("@FLAG",null), new Parameter("@FLOWTYPE",null), new Parameter("@CREATEUSERID",null), new Parameter("@CREATEUSERNAME",null), new Parameter("@CREATECOMPANYID",null), new Parameter("@CREATEDEPARTMENTID",null), new Parameter("@CREATEPOSTID",null), new Parameter("@CREATEDATE",null), new Parameter("@EDITUSERID",null), new Parameter("@EDITUSERNAME",null), new Parameter("@EDITDATE",null) }; relationParm[0].ParameterValue = Guid.NewGuid().ToString();//关联ID relationParm[1].ParameterValue = GetValue(relation.COMPANYID);//公司ID relationParm[2].ParameterValue = GetValue(relation.DEPARTMENTID);//部门ID relationParm[3].ParameterValue = GetValue(relation.COMPANYNAME);//公司名称 relationParm[4].ParameterValue = GetValue(relation.DEPARTMENTNAME);//部门名称 relationParm[5].ParameterValue = GetValue(relation.SYSTEMCODE);//系统代码 relationParm[6].ParameterValue = GetValue(relation.MODELCODE);//模块代码 relationParm[7].ParameterValue = GetValue(relation.FLOWCODE);//流程代码 relationParm[8].ParameterValue = "1";//1这可用,0为不可用 relationParm[9].ParameterValue = GetValue(relation.FLOWTYPE);//0:审批流程,1:任务流程 relationParm[10].ParameterValue = GetValue(relation.CREATEUSERID);//操作人员ID relationParm[11].ParameterValue = GetValue(relation.CREATEUSERNAME);//操作人员名 relationParm[12].ParameterValue = GetValue(relation.CREATECOMPANYID);//创建公司ID relationParm[13].ParameterValue = GetValue(relation.CREATEDEPARTMENTID);//创建部门ID relationParm[14].ParameterValue = GetValue(relation.CREATEPOSTID);//创建岗位ID relationParm[15].ParameterValue = DateTime.Now;//创建时间 relationParm[16].ParameterValue = GetValue(relation.CREATEUSERID);//修改人ID relationParm[17].ParameterValue = GetValue(relation.CREATEUSERNAME);//修改人用户名 relationParm[18].ParameterValue = DateTime.Now;//修改时间 ParameterCollection pras = new ParameterCollection(); foreach(var item in relationParm) { pras.Add(item); } int k = dao.ExecuteNonQuery(relationSql, CommandType.Text, pras); if (k > 0) { return true; } return false; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// 查询 [模块与流程定义关联] /// </summary> /// <param name="CompanyID">创建公司ID</param> /// <param name="DepartID">创建部门ID</param> /// <param name="ModelCode">模块代码</param> /// <param name="FlowType">0:审批流程,1:任务流程</param> /// <param name="OrgType">1:代表部门ID为空,否则部门ID不为空</param> /// <returns></returns> public static List<FLOW_MODELFLOWRELATION_T> GetFlowByModelName(string CompanyID, string DepartID, string ModelCode, string FlowType, string OrgType) { List<FLOW_MODELFLOWRELATION_T> listRelation = new List<FLOW_MODELFLOWRELATION_T>(); IDataReader dr = null; string sql = ""; try { sql = @" select * from FLOW_MODELFLOWRELATION_T where COMPANYID='{0}' and FLOWTYPE='{1}' and FLAG='1' and MODELCODE='{2}'"; if (OrgType != "1") { sql = sql + " and (DEPARTMENTID is null or DEPARTMENTID ='')"; } else { sql = sql + " and DEPARTMENTID='{3}'"; } sql = string.Format(sql, CompanyID, FlowType, ModelCode, DepartID); #region ////OracleCommand cmd = con.CreateCommand(); ////cmd.CommandText = sql; //dr = cmd.ExecuteReader(); Tracer.Debug("FLOW_MODELFLOWRELATION_TDAL->GetFlowByModelName SQL语句:" + sql); dr = dao.ExecuteReader(sql); while (dr.Read()) { #region FLOW_MODELFLOWRELATION_T FLOW_MODELFLOWRELATION_T relation = new FLOW_MODELFLOWRELATION_T(); relation.COMPANYID = dr["COMPANYID"] == DBNull.Value ? null : dr["COMPANYID"].ToString(); relation.CREATECOMPANYID = dr["CREATECOMPANYID"] == DBNull.Value ? null : dr["CREATECOMPANYID"].ToString(); relation.CREATEDATE = (DateTime)dr["CREATEDATE"]; relation.CREATEDEPARTMENTID = dr["CREATEDEPARTMENTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString(); relation.CREATEPOSTID = dr["CREATEPOSTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString(); relation.CREATEUSERID = dr["CREATEUSERID"] == DBNull.Value ? null : dr["CREATEUSERID"].ToString(); relation.CREATEUSERNAME = dr["CREATEUSERNAME"] == DBNull.Value ? null : dr["CREATEUSERNAME"].ToString(); relation.DEPARTMENTID = dr["DEPARTMENTID"] == DBNull.Value ? null : dr["DEPARTMENTID"].ToString(); relation.EDITDATE = dr["EDITDATE"] == DBNull.Value ? null : (DateTime?)dr["EDITDATE"]; relation.EDITUSERID = dr["EDITUSERID"] == DBNull.Value ? null : dr["EDITUSERID"].ToString(); relation.EDITUSERNAME = dr["EDITUSERNAME"] == DBNull.Value ? null : dr["EDITUSERNAME"].ToString(); relation.FLAG = dr["FLAG"] == DBNull.Value ? null : dr["FLAG"].ToString(); relation.FLOWTYPE = dr["FLOWTYPE"] == DBNull.Value ? null : dr["FLOWTYPE"].ToString(); relation.MODELFLOWRELATIONID = dr["MODELFLOWRELATIONID"] == DBNull.Value ? null : dr["MODELFLOWRELATIONID"].ToString(); relation.FLOW_FLOWDEFINE_T = new FLOW_FLOWDEFINE_T(); relation.FLOW_FLOWDEFINE_T.FLOWCODE = dr["FLOWCODE"] == DBNull.Value ? null : dr["FLOWCODE"].ToString(); listRelation.Add(relation); break; #endregion } dr.Close(); if (listRelation.Count > 0) { sql = @"select * from FLOW_FLOWDEFINE_T where FLOWCODE='" + listRelation[0].FLOW_FLOWDEFINE_T.FLOWCODE + "'"; //dr = cmd.ExecuteReader(); dr = dao.ExecuteReader(sql); while (dr.Read()) { #region FLOW_FLOWDEFINE_T FLOW_FLOWDEFINE_T define = new FLOW_FLOWDEFINE_T(); define.CREATECOMPANYID = dr["CREATECOMPANYID"] == DBNull.Value ? null : dr["CREATECOMPANYID"].ToString(); define.CREATEDATE = (DateTime)dr["CREATEDATE"]; define.CREATEDEPARTMENTID = dr["CREATEDEPARTMENTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString(); define.CREATEPOSTID = dr["CREATEPOSTID"] == DBNull.Value ? null : dr["CREATEDEPARTMENTID"].ToString(); define.CREATEUSERID = dr["CREATEUSERID"] == DBNull.Value ? null : dr["CREATEUSERID"].ToString(); define.CREATEUSERNAME = dr["CREATEUSERNAME"] == DBNull.Value ? null : dr["CREATEUSERNAME"].ToString(); define.DESCRIPTION = dr["DESCRIPTION"] == DBNull.Value ? null : dr["DESCRIPTION"].ToString(); define.EDITDATE = dr["EDITDATE"] == DBNull.Value ? null : (DateTime?)dr["EDITDATE"]; define.EDITUSERID = dr["EDITUSERID"] == DBNull.Value ? null : dr["EDITUSERID"].ToString(); define.EDITUSERNAME = dr["EDITUSERNAME"] == DBNull.Value ? null : dr["EDITUSERNAME"].ToString(); define.FLOWCODE = dr["FLOWCODE"] == DBNull.Value ? null : dr["FLOWCODE"].ToString(); define.FLOWTYPE = dr["FLOWTYPE"] == DBNull.Value ? null : dr["FLOWTYPE"].ToString(); define.FLOWDEFINEID = dr["FLOWDEFINEID"] == DBNull.Value ? null : dr["FLOWDEFINEID"].ToString(); define.LAYOUT = dr["LAYOUT"] == DBNull.Value ? null : dr["LAYOUT"].ToString(); define.RULES = dr["RULES"] == DBNull.Value ? null : dr["RULES"].ToString(); define.XOML = dr["XOML"] == DBNull.Value ? null : dr["XOML"].ToString(); ; listRelation[0].FLOW_FLOWDEFINE_T = define; break; #endregion } dr.Close(); } #endregion return listRelation; } catch (Exception ex) { if (dr != null && !dr.IsClosed) { dr.Close(); } throw new Exception("GetFlowByModelName-->" + ex.Message); } }
/// <summary> /// 新增流程关系 /// </summary> /// <param name="conn">数据库链接</param> /// <param name="command">数据库命令</param> /// <param name="relation">关系实体</param> /// <returns>bool</returns> private bool AddRelation(OracleConnection conn, OracleCommand command, FLOW_MODELFLOWRELATION_T relation) { try { string relationSql = @"INSERT INTO FLOW_MODELFLOWRELATION_T (MODELFLOWRELATIONID,COMPANYID,DEPARTMENTID,COMPANYNAME,DEPARTMENTNAME, SYSTEMCODE,MODELCODE,FLOWCODE,FLAG,FLOWTYPE,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID, CREATEPOSTID,CREATEDATE,EDITUSERID,EDITUSERNAME,EDITDATE) VALUES (:MODELFLOWRELATIONID,:COMPANYID,:DEPARTMENTID, :COMPANYNAME,:DEPARTMENTNAME,:SYSTEMCODE,:MODELCODE,:FLOWCODE,:FLAG,:FLOWTYPE,:CREATEUSERID,:CREATEUSERNAME, :CREATECOMPANYID,:CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE,:EDITUSERID,:EDITUSERNAME,:EDITDATE)"; OracleParameter[] relationParm = { new OracleParameter(":MODELFLOWRELATIONID",OracleType.NVarChar,100), new OracleParameter(":COMPANYID",OracleType.NVarChar,100), new OracleParameter(":DEPARTMENTID",OracleType.NVarChar,100), new OracleParameter(":COMPANYNAME",OracleType.NVarChar,100), new OracleParameter(":DEPARTMENTNAME",OracleType.NVarChar,100), new OracleParameter(":SYSTEMCODE",OracleType.NVarChar,100), new OracleParameter(":MODELCODE",OracleType.NVarChar,100), new OracleParameter(":FLOWCODE",OracleType.NVarChar,100), new OracleParameter(":FLAG",OracleType.NVarChar,2), new OracleParameter(":FLOWTYPE",OracleType.NVarChar,2), new OracleParameter(":CREATEUSERID",OracleType.NVarChar,100), new OracleParameter(":CREATEUSERNAME",OracleType.NVarChar,100), new OracleParameter(":CREATECOMPANYID",OracleType.NVarChar,100), new OracleParameter(":CREATEDEPARTMENTID",OracleType.NVarChar,100), new OracleParameter(":CREATEPOSTID",OracleType.NVarChar,100), new OracleParameter(":CREATEDATE",OracleType.DateTime), new OracleParameter(":EDITUSERID",OracleType.NVarChar,100), new OracleParameter(":EDITUSERNAME",OracleType.NVarChar,100), new OracleParameter(":EDITDATE",OracleType.DateTime) }; relationParm[0].Value = Guid.NewGuid().ToString();//关联ID relationParm[1].Value = GetValue(relation.COMPANYID);//公司ID relationParm[2].Value = GetValue(relation.DEPARTMENTID);//部门ID relationParm[3].Value = GetValue(relation.COMPANYNAME);//公司名称 relationParm[4].Value = GetValue(relation.DEPARTMENTNAME);//部门名称 relationParm[5].Value = GetValue(relation.SYSTEMCODE);//系统代码 relationParm[6].Value = GetValue(relation.MODELCODE);//模块代码 relationParm[7].Value = GetValue(relation.FLOWCODE);//流程代码 relationParm[8].Value = "1";//1这可用,0为不可用 relationParm[9].Value = GetValue(relation.FLOWTYPE);//0:审批流程,1:任务流程 relationParm[10].Value = GetValue(relation.CREATEUSERID);//操作人员ID relationParm[11].Value = GetValue(relation.CREATEUSERNAME);//操作人员名 relationParm[12].Value = GetValue(relation.CREATECOMPANYID);//创建公司ID relationParm[13].Value = GetValue(relation.CREATEDEPARTMENTID);//创建部门ID relationParm[14].Value = GetValue(relation.CREATEPOSTID);//创建岗位ID relationParm[15].Value = DateTime.Now;//创建时间 relationParm[16].Value = GetValue(relation.CREATEUSERID);//修改人ID relationParm[17].Value = GetValue(relation.CREATEUSERNAME);//修改人用户名 relationParm[18].Value = DateTime.Now;//修改时间 int k = MicrosoftOracle.ExecuteSQL(conn, command, relationSql, relationParm); if (k > 0) { return true; } return false; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }