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