/// <summary> /// 新增模块代码 /// </summary> /// <param name="FlowModel"></param> /// <returns></returns> public string AddModelDefine(FLOW_MODELDEFINE_T FlowModel) { try { return FlowModelBll.AddModelDefine(FlowModel); } catch (Exception ex) { Tracer.Debug("新增模块定义出错:" + ex.Message); return "0"; } }
/// <summary> /// 模块定义 /// </summary> /// <param name="con">//OracleConnection</param> /// <param name="ModelCode">模块代码</param> /// <returns></returns> public static List<FLOW_MODELDEFINE_T> GetModelDefineByCode(string ModelCode) { List<FLOW_MODELDEFINE_T> list = new List<FLOW_MODELDEFINE_T>(); IDataReader dr = null; try { #region ////OracleCommand cmd = con.CreateCommand(); ////cmd.CommandText = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'"; //dr = cmd.ExecuteReader(); string sql = "select * from FLOW_MODELDEFINE_T where MODELCODE='" + ModelCode + "'"; dr= dao.ExecuteReader(sql); while (dr.Read()) { #region define FLOW_MODELDEFINE_T define = new FLOW_MODELDEFINE_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.MODELCODE = dr["MODELCODE"] == DBNull.Value ? null : dr["MODELCODE"].ToString(); define.MODELDEFINEID = dr["MODELDEFINEID"] == DBNull.Value ? null : dr["MODELDEFINEID"].ToString(); define.PARENTMODELCODE = dr["PARENTMODELCODE"] == DBNull.Value ? null : dr["PARENTMODELCODE"].ToString(); define.SYSTEMCODE = dr["SYSTEMCODE"] == DBNull.Value ? null : dr["SYSTEMCODE"].ToString(); list.Add(define); #endregion } dr.Close(); #endregion return list; } catch (Exception ex) { if (dr != null && !dr.IsClosed) { dr.Close(); } throw new Exception("GetModelDefineByCode-->" + ex.Message); } }
/// <summary> /// 修改模块代码 /// </summary> /// <param name="FlowModel"></param> /// <returns></returns> public string UpdateModelDefine(FLOW_MODELDEFINE_T FlowModel) { try { if (dal.GetExistModelDefine(FlowModel.MODELCODE, FlowModel.DESCRIPTION,FlowModel.MODELDEFINEID)) { return "10"; } else { return dal.UpdateModelDefine(FlowModel); } } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// 新增模块代码 /// </summary> /// <param name="flowModel">FlowModel</param> /// <returns>string</returns> public string AddModelDefine(FLOW_MODELDEFINE_T flowModel) { try { ////OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString); StringBuilder inssql = new StringBuilder(); inssql.Append("INSERT INTO FLOW_MODELDEFINE_T (MODELDEFINEID,SYSTEMCODE,SYSTEMNAME,MODELCODE,PARENTMODELCODE,DESCRIPTION,"); inssql.Append("CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) VALUES (:MODELDEFINEID,"); inssql.Append(":SYSTEMCODE,:SYSTEMNAME,:MODELCODE,:PARENTMODELCODE,:DESCRIPTION,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,"); inssql.Append(":CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)"); Parameter[] pageparm = { new Parameter(":MODELDEFINEID",GetValue(flowModel.MODELDEFINEID)), //模块ID new Parameter(":SYSTEMCODE",GetValue(flowModel.SYSTEMCODE)), //系统代码 new Parameter(":SYSTEMNAME",GetValue(flowModel.SYSTEMNAME)), //系统代码 new Parameter(":MODELCODE",GetValue(flowModel.MODELCODE)), //模块代码 new Parameter(":PARENTMODELCODE",GetValue(flowModel.PARENTMODELCODE)), //上级模块代码 new Parameter(":DESCRIPTION",GetValue(flowModel.DESCRIPTION)), //模块描述 new Parameter(":CREATEUSERID",GetValue(flowModel.CREATEUSERID)), //创建人ID new Parameter(":CREATEUSERNAME",GetValue(flowModel.CREATEUSERNAME)), //创建人名 new Parameter(":CREATECOMPANYID",GetValue(flowModel.CREATECOMPANYID)), //创建公司ID new Parameter(":CREATEDEPARTMENTID",GetValue(flowModel.CREATEDEPARTMENTID)), //创建部门ID new Parameter(":CREATEPOSTID",GetValue(flowModel.CREATEPOSTID)), //创建岗位ID new Parameter(":CREATEDATE",GetValue(DateTime.Now)) //创建时间 }; ParameterCollection pras = new ParameterCollection(); foreach (var item in pageparm) { pras.Add(item); } int result = dao.ExecuteNonQuery(inssql.ToString(), CommandType.Text, pras); //MicrosoftOracle.Close(conn); return result > 0 ? "1" : "0"; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// 修改模块代码 /// </summary> /// <param name="flowModel">flowModel</param> /// <returns>string</returns> public string UpdateModelDefine(FLOW_MODELDEFINE_T flowModel) { try { OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString); string updSql = "UPDATE FLOW_MODELDEFINE_T SET MODELDEFINEID=:MODELDEFINEID,SYSTEMCODE=:SYSTEMCODE,SYSTEMNAME=:SYSTEMNAME,PARENTMODELCODE=:PARENTMODELCODE,DESCRIPTION=:DESCRIPTION,EDITUSERID=:EDITUSERID,EDITUSERNAME=:EDITUSERNAME,EDITDATE=:EDITDATE WHERE MODELCODE=:MODELCODE"; OracleParameter[] pageparm = { new OracleParameter(":MODELDEFINEID",GetValue(flowModel.MODELDEFINEID)), //模块ID new OracleParameter(":SYSTEMCODE",GetValue(flowModel.SYSTEMCODE)), //系统代码 new OracleParameter(":SYSTEMNAME",GetValue(flowModel.SYSTEMNAME)), //系统代码 new OracleParameter(":MODELCODE",GetValue(flowModel.MODELCODE)), //模块代码 new OracleParameter(":PARENTMODELCODE",GetValue(flowModel.PARENTMODELCODE)), //上级模块代码 new OracleParameter(":DESCRIPTION",GetValue(flowModel.DESCRIPTION)), //模块描述 new OracleParameter(":EDITUSERID",GetValue(flowModel.EDITUSERID)), //修改人ID new OracleParameter(":EDITUSERNAME",GetValue(flowModel.EDITUSERNAME)), //修改人用户名 new OracleParameter(":EDITDATE",GetValue(DateTime.Now)) //修改时间 }; int result = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, updSql, pageparm); if (result > 0) { #region 哪些公司在模块中可以允许自选流程 if (flowModel.FreeFlowCompanyList != null && flowModel.FreeFlowCompanyList.Count > 0) { foreach (var ent in flowModel.FreeFlowCompanyList) { StringBuilder sb = new StringBuilder(); sb.AppendLine("declare "); sb.AppendLine(" i integer;"); sb.AppendLine(" MODELDEFINEFREEFLOWID varchar2(50) :='" + ent.MODELDEFINEFREEFLOWID + "';"); sb.AppendLine(" MODELCODE_temp varchar2(50) :='" + ent.MODELCODE + "';"); sb.AppendLine(" COMPANYNAME_temp varchar2(50) :='" + ent.COMPANYNAME + "';"); sb.AppendLine(" COMPANYID_temp varchar2(50) :='" + ent.COMPANYID + "';"); sb.AppendLine(" CREATEUSERID_temp varchar2(50) :='" + ent.CREATEUSERID + "';"); sb.AppendLine(" CREATEUSERNAME_temp varchar2(50) :='" + ent.CREATEUSERNAME + "';"); sb.AppendLine(" CREATECOMPANYID_temp varchar2(50) :='" + ent.CREATECOMPANYID + "';"); sb.AppendLine(" CREATEDEPARTMENTID_temp varchar2(50) :='" + ent.CREATEDEPARTMENTID + "';"); sb.AppendLine(" CREATEPOSTID_temp varchar2(50) :='" + ent.CREATEPOSTID + "';"); sb.AppendLine(" CREATEDATE_temp date :=to_date('" + DateTime.Now.ToString() + "', 'yyyy/mm/dd hh24:mi:ss');"); sb.AppendLine("begin"); sb.AppendLine(" select count(1) into i from FLOW_MODELDEFINE_FREEFLOW t where t.MODELCODE='" + ent.MODELCODE + "' and t.COMPANYID='" + ent.COMPANYID + "';"); sb.AppendLine(" if i<1 then"); sb.AppendLine(" execute immediate 'INSERT INTO FLOW_MODELDEFINE_FREEFLOW (MODELDEFINEFREEFLOWID,MODELCODE,COMPANYNAME,COMPANYID,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) values (:MODELDEFINEFREEFLOWID,:MODELCODE,:COMPANYNAME,:COMPANYID,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,:CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)'"); sb.AppendLine(" using MODELDEFINEFREEFLOWID,MODELCODE_temp,COMPANYNAME_temp,COMPANYID_temp,CREATEUSERID_temp,CREATEUSERNAME_temp,CREATECOMPANYID_temp,CREATEDEPARTMENTID_temp,CREATEPOSTID_temp,CREATEDATE_temp; "); sb.AppendLine(" --commit; "); sb.AppendLine(" end if;"); sb.AppendLine("end;"); int n = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, sb.ToString()); } } #endregion #region 哪些公司在模块中可以允许提单人撒回流程 if (flowModel.FlowCancelCompanyList != null && flowModel.FlowCancelCompanyList.Count > 0) { foreach (var ent in flowModel.FlowCancelCompanyList) { StringBuilder sb = new StringBuilder(); sb.AppendLine("declare "); sb.AppendLine(" i integer;"); sb.AppendLine(" MODELDEFINEFLOWCANCLEID_temp varchar2(50) :='" + ent.MODELDEFINEFLOWCANCLEID + "';"); sb.AppendLine(" MODELCODE_temp varchar2(50) :='" + ent.MODELCODE + "';"); sb.AppendLine(" COMPANYNAME_temp varchar2(50) :='" + ent.COMPANYNAME + "';"); sb.AppendLine(" COMPANYID_temp varchar2(50) :='" + ent.COMPANYID + "';"); sb.AppendLine(" CREATEUSERID_temp varchar2(50) :='" + ent.CREATEUSERID + "';"); sb.AppendLine(" CREATEUSERNAME_temp varchar2(50) :='" + ent.CREATEUSERNAME + "';"); sb.AppendLine(" CREATECOMPANYID_temp varchar2(50) :='" + ent.CREATECOMPANYID + "';"); sb.AppendLine(" CREATEDEPARTMENTID_temp varchar2(50) :='" + ent.CREATEDEPARTMENTID + "';"); sb.AppendLine(" CREATEPOSTID_temp varchar2(50) :='" + ent.CREATEPOSTID + "';"); sb.AppendLine(" CREATEDATE_temp date :=to_date('" + DateTime.Now.ToString() + "', 'yyyy/mm/dd hh24:mi:ss');"); sb.AppendLine("begin"); sb.AppendLine(" select count(1) into i from FLOW_MODELDEFINE_FLOWCANCLE t where t.MODELCODE='" + ent.MODELCODE + "' and t.COMPANYID='" + ent.COMPANYID + "';"); sb.AppendLine(" if i<1 then"); sb.AppendLine(" execute immediate 'INSERT INTO FLOW_MODELDEFINE_FLOWCANCLE (MODELDEFINEFLOWCANCLEID,MODELCODE,COMPANYNAME,COMPANYID,CREATEUSERID,CREATEUSERNAME,CREATECOMPANYID,CREATEDEPARTMENTID,CREATEPOSTID,CREATEDATE) values (:MODELDEFINEFLOWCANCLEID,:MODELCODE,:COMPANYNAME,:COMPANYID,:CREATEUSERID,:CREATEUSERNAME,:CREATECOMPANYID,:CREATEDEPARTMENTID,:CREATEPOSTID,:CREATEDATE)'"); sb.AppendLine(" using MODELDEFINEFLOWCANCLEID_temp,MODELCODE_temp,COMPANYNAME_temp,COMPANYID_temp,CREATEUSERID_temp,CREATEUSERNAME_temp,CREATECOMPANYID_temp,CREATEDEPARTMENTID_temp,CREATEPOSTID_temp,CREATEDATE_temp; "); sb.AppendLine(" --commit; "); sb.AppendLine(" end if;"); sb.AppendLine("end;"); int n = MicrosoftOracle.ExecuteNonQuery(conn, CommandType.Text, sb.ToString()); } } #endregion } MicrosoftOracle.Close(conn); return result > 0 ? "1" : "0"; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }