/// <summary>
/// 查询模块分页列表
/// </summary>
/// <param name="filterString">filterString</param>
/// <param name="pageIndex">pageIndex</param>
/// <param name="pageSize">pageSize</param>
/// <param name="pageCount">pageCount</param>
/// <returns>List<FLOW_MODELDEFINE_T></returns>
public List <FLOW_MODELDEFINE_T> GetModelDefineList(string filterString, int pageIndex, int pageSize, ref int pageCount)
{
try
{
if (pageSize < 1)
{
pageSize = 15;
}
int number = pageIndex <= 1 ? 1 : ((pageIndex - 1) * pageSize) + 1;
OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString);
string countSql = @"SELECT count(1) from FLOW_MODELDEFINE_T where (1=1)";
if (!string.IsNullOrWhiteSpace(filterString))
{
countSql += filterString + " ";
}
string sql = "SELECT * FROM (SELECT A.*, ROWNUM Page FROM (select * from FLOW_MODELDEFINE_T order by CREATEDATE DESC ) A WHERE (1=1) AND ROWNUM<= " + pageIndex * pageSize + " ";
if (!string.IsNullOrWhiteSpace(filterString))
{
sql += filterString + " ";
}
sql += ") WHERE Page >= " + number + " ";
DataTable dt = MicrosoftOracle.ExecuteTable(conn, sql);// dao.GetDataTable(sql);
pageCount = Convert.ToInt32(MicrosoftOracle.ExecuteScalar(conn, countSql));
pageCount = (pageCount / pageSize) + ((pageCount % pageSize) > 0 ? 1 : 0);
MicrosoftOracle.Close(conn);
return(ToList <FLOW_MODELDEFINE_T>(dt));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// 判断模块是否存在
/// </summary>
/// <param name="modelCode">modelCode</param>
/// <param name="descrtption">descrtption</param>
/// <param name="modelDefineID">modelDefineID</param>
/// <returns>bool</returns>
public bool GetExistModelDefine(string modelCode, string descrtption, string modelDefineID)
{
try
{
OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString);
string sqlstr = "SELECT count(*) FROM FLOW_MODELDEFINE_T where (MODELCODE = '" + modelCode + "' or DESCRIPTION = '" + descrtption + "')";
if (!string.IsNullOrWhiteSpace(modelDefineID))
{
sqlstr += " AND MODELDEFINEID!='" + modelDefineID + "'";
}
int result = Convert.ToInt32(MicrosoftOracle.ExecuteScalar(conn, sqlstr));
MicrosoftOracle.Close(conn);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// 删除模块代码
/// </summary>
/// <param name="deleteList">deleteList</param>
/// <returns>string</returns>
public string DeleteModelDefine(List <string> deleteList)
{
OracleTransaction transaction = null;
try
{
OracleConnection conn = MicrosoftOracle.CreateOracleConnection(ConnectionString);
OracleConnection conndef = MicrosoftOracle.CreateOracleConnection(ConnectionString);
OracleCommand command = conndef.CreateCommand();
transaction = conndef.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
command.Transaction = transaction;
foreach (string item in deleteList)
{
string sqlstr = "SELECT count(*) FROM FLOW_MODELFLOWRELATION_T where MODELCODE = '" + item + "'";
if (Convert.ToInt32(MicrosoftOracle.ExecuteScalar(conn, sqlstr)) < 1)
{
string sql = "delete from FLOW_MODELDEFINE_T where MODELCODE = '" + item + "'";
int result = MicrosoftOracle.ExecuteNonQuery(conndef, command, sql);
}
else
{
transaction.Rollback();
return("10");
}
}
transaction.Commit();
MicrosoftOracle.Close(conn);
return("1");
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message, ex);
}
}
