public string Delete(
String DTB,
String QD_ID,
Int32 QDD_ID
)
{
connect();
InitSPCommand(_strSPDeleteName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB);
AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), QD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), QDD_ID);
string sErr = "";
try
{
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public string Update(CoreQDD_FILTERInfo objEntr)
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), objEntr.DTB);
AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), objEntr.QD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), objEntr.QDD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.OPERATOR.ToString(), objEntr.OPERATOR);
AddParameter(CoreQDD_FILTERInfo.Field.IS_NOT.ToString(), objEntr.IS_NOT);
string sErr = "";
try
{
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public DataTable GetAll(string conn,
ref string sErr)
{
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetAllName);
AddParameter("CONN_ID", conn);
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public int GetCountRecord(
String DTB,
ref string sErr)
{
int ret = -1;
connect();
InitSPCommand(_strSPInsertName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB);
try
{
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(ret);
}
public DataTableCollection Get_Page(CoreQD_SCHEMAInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
string whereClause = CreateWhereClause(obj);
DataTableCollection dtList = null; try
{
connect();
InitSPCommand(_strSPGetPages);
AddParameter("WhereClause", whereClause);
AddParameter("OrderBy", orderBy);
AddParameter("PageIndex", pageIndex);
AddParameter("PageSize", pageSize);
dtList = executeCollectSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(dtList);
}
public string Update(CoreQD_SCHEMAInfo objEntr)
{
string sErr = "";
try
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), objEntr.CONN_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), objEntr.SCHEMA_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.LOOK_UP.ToString(), objEntr.LOOK_UP);
AddParameter(CoreQD_SCHEMAInfo.Field.DESCRIPTN.ToString(), objEntr.DESCRIPTN);
AddParameter(CoreQD_SCHEMAInfo.Field.FIELD_TEXT.ToString(), objEntr.FIELD_TEXT);
AddParameter(CoreQD_SCHEMAInfo.Field.FROM_TEXT.ToString(), objEntr.FROM_TEXT);
AddParameter(CoreQD_SCHEMAInfo.Field.DAG.ToString(), objEntr.DAG);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_STATUS.ToString(), objEntr.SCHEMA_STATUS);
AddParameter(CoreQD_SCHEMAInfo.Field.UPDATED.ToString(), objEntr.UPDATED);
AddParameter(CoreQD_SCHEMAInfo.Field.ENTER_BY.ToString(), objEntr.ENTER_BY);
AddParameter(CoreQD_SCHEMAInfo.Field.DEFAULT_CONN.ToString(), objEntr.DEFAULT_CONN);
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public string Delete(
String CONN_ID,
String SCHEMA_ID
)
{
string sErr = "";
try
{
connect();
InitSPCommand(_strSPDeleteName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), CONN_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), SCHEMA_ID);
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public Boolean IsExist(
String DTB,
String QD_ID,
Int32 QDD_ID
)
{
connect();
InitSPCommand(_strSPIsExist);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB);
AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), QD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), QDD_ID);
string sErr = "";
DataTable list = new DataTable();
try
{
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
if (list.Rows.Count == 1)
{
return(true);
}
return(false);
}
public DataTable GetTransferOut(string dtb, object from, object to, ref string sErr)
{
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetTransferOutName);
AddParameter("DB", dtb);
AddParameter("FROM", from);
AddParameter("TO", to);
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public Boolean IsExist_CoreQD(
String DTB,
String QD_ID
)
{
string sErr = "";
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPIsExist);
AddParameter("DTB", DTB);
AddParameter("QD_ID", QD_ID);
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
if (list.Rows.Count == 1)
{
return(true);
}
return(false);
}
public DataTable GetJoins(string dtb, ref string sErr)
{
DataTable list = new DataTable();
try
{
InitConnect();
InitSPCommand(_strSPGetJoinsName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), dtb);
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public string Delete_CoreQD(
String DTB,
String QD_ID
)
{
connect();
InitSPCommand(_strSPDeleteName);
AddParameter("DTB", DTB);
AddParameter("QD_ID", QD_ID);
string sErr = "";
try
{
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public string GetDefaultDB(string db, string table, ref string sErr)
{
object objEntr = null;
try
{
connect();
InitSPCommand(_strSPGetDefaultDBName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), db);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), table);
objEntr = executeSPScalar();
}
catch (Exception ex)
{
sErr = ex.Message;
}
finally
{
disconnect();
}
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
if (objEntr != null)
{
return(objEntr.ToString());
}
else
{
return("");
}
}
public DataTable GetAll(
String DTB,
ref string sErr)
{
connect();
InitSPCommand(_strSPGetAllName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB);
DataTable list = new DataTable();
try
{
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public Boolean IsExist(
String CONN_ID,
String SCHEMA_ID
)
{
string sErr = "";
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPIsExist);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), CONN_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), SCHEMA_ID);
list = executeSelectSP();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
if (list.Rows.Count == 1)
{
return(true);
}
return(false);
}
public DataTable GetAll_CoreQD(String DTB, ref string sErr)
{
CoreQDInfo objEntr = new CoreQDInfo(); DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetAllName);
AddParameter("DTB", DTB);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add_CoreQD(CoreQDInfo objEntr, ref string sErr)
{
int ret = -1; try
{
connect();
InitSPCommand(_strSPInsertName);
AddParameter("DTB", objEntr.DTB);
AddParameter("QD_ID", objEntr.QD_ID);
AddParameter("DESCRIPTN", objEntr.DESCRIPTN);
AddParameter("OWNER", objEntr.OWNER);
AddParameter("SHARED", objEntr.SHARED);
AddParameter("LAYOUT", objEntr.LAYOUT);
AddParameter("ANAL_Q0", objEntr.ANAL_Q0);
AddParameter("ANAL_Q9", objEntr.ANAL_Q9);
AddParameter("ANAL_Q8", objEntr.ANAL_Q8);
AddParameter("ANAL_Q7", objEntr.ANAL_Q7);
AddParameter("ANAL_Q6", objEntr.ANAL_Q6);
AddParameter("ANAL_Q5", objEntr.ANAL_Q5);
AddParameter("ANAL_Q4", objEntr.ANAL_Q4);
AddParameter("ANAL_Q3", objEntr.ANAL_Q3);
AddParameter("ANAL_Q2", objEntr.ANAL_Q2);
AddParameter("ANAL_Q1", objEntr.ANAL_Q1);
AddParameter("SQL_TEXT", objEntr.SQL_TEXT);
AddParameter("HEADER_TEXT", objEntr.HEADER_TEXT);
AddParameter("FOOTER_TEXT", objEntr.FOOTER_TEXT);
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(ret);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add_CoreQDD(CoreQDDInfo objEntr, ref string sErr)
{
int ret = -1;
try
{
connect();
InitSPCommand(_strSPInsertName);
AddParameter("DTB", objEntr.DTB);
AddParameter("QD_ID", objEntr.QD_ID);
AddParameter("QDD_ID", objEntr.QDD_ID);
AddParameter("CODE", objEntr.CODE);
AddParameter("DESCRIPTN", objEntr.DESCRIPTN);
AddParameter("F_TYPE", objEntr.F_TYPE);
AddParameter("SORTING", objEntr.SORTING);
AddParameter("AGREGATE", objEntr.AGREGATE);
AddParameter("EXPRESSION", objEntr.EXPRESSION);
AddParameter("FILTER_FROM", objEntr.FILTER_FROM);
AddParameter("FILTER_TO", objEntr.FILTER_TO);
AddParameter("IS_FILTER", objEntr.IS_FILTER);
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(ret);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add(CoreQD_SCHEMAInfo objEntr, ref string sErr)
{
int ret = -1; try
{
connect();
InitSPCommand(_strSPInsertName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), objEntr.CONN_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), objEntr.SCHEMA_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.LOOK_UP.ToString(), objEntr.LOOK_UP);
AddParameter(CoreQD_SCHEMAInfo.Field.DESCRIPTN.ToString(), objEntr.DESCRIPTN);
AddParameter(CoreQD_SCHEMAInfo.Field.FIELD_TEXT.ToString(), objEntr.FIELD_TEXT);
AddParameter(CoreQD_SCHEMAInfo.Field.FROM_TEXT.ToString(), objEntr.FROM_TEXT);
AddParameter(CoreQD_SCHEMAInfo.Field.DAG.ToString(), objEntr.DAG);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_STATUS.ToString(), objEntr.SCHEMA_STATUS);
AddParameter(CoreQD_SCHEMAInfo.Field.UPDATED.ToString(), objEntr.UPDATED);
AddParameter(CoreQD_SCHEMAInfo.Field.ENTER_BY.ToString(), objEntr.ENTER_BY);
AddParameter(CoreQD_SCHEMAInfo.Field.DEFAULT_CONN.ToString(), objEntr.DEFAULT_CONN);
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(ret);
}
public string Update_CoreQD(CoreQDInfo objEntr)
{
string sErr = "";
try
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter("DTB", objEntr.DTB);
AddParameter("QD_ID", objEntr.QD_ID);
AddParameter("DESCRIPTN", objEntr.DESCRIPTN);
AddParameter("OWNER", objEntr.OWNER);
AddParameter("SHARED", objEntr.SHARED);
AddParameter("LAYOUT", objEntr.LAYOUT);
AddParameter("ANAL_Q0", objEntr.ANAL_Q0);
AddParameter("ANAL_Q9", objEntr.ANAL_Q9);
AddParameter("ANAL_Q8", objEntr.ANAL_Q8);
AddParameter("ANAL_Q7", objEntr.ANAL_Q7);
AddParameter("ANAL_Q6", objEntr.ANAL_Q6);
AddParameter("ANAL_Q5", objEntr.ANAL_Q5);
AddParameter("ANAL_Q4", objEntr.ANAL_Q4);
AddParameter("ANAL_Q3", objEntr.ANAL_Q3);
AddParameter("ANAL_Q2", objEntr.ANAL_Q2);
AddParameter("ANAL_Q1", objEntr.ANAL_Q1);
AddParameter("SQL_TEXT", objEntr.SQL_TEXT);
AddParameter("HEADER_TEXT", objEntr.HEADER_TEXT);
AddParameter("FOOTER_TEXT", objEntr.FOOTER_TEXT);
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
public CoreQDInfo Get_CoreQD(
String DTB,
String QD_ID
, ref string sErr)
{
CoreQDInfo objEntr = new CoreQDInfo();
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetName);
AddParameter("DTB", DTB);
AddParameter("QD_ID", QD_ID);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
finally
{
disconnect();
}
if (list.Rows.Count > 0)
{
objEntr = (CoreQDInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(objEntr);
}
public DataTable GetAll_CoreQDD(ref string sErr)
{
string query = "exec " + _strSPGetAllName;
DataTable list = new DataTable();
try
{
connect();
list = executeSelectQuery(query);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public CoreQDD_FILTERInfo Get(
String DTB,
String QD_ID,
Int32 QDD_ID,
ref string sErr)
{
CoreQDD_FILTERInfo objEntr = new CoreQDD_FILTERInfo();
connect();
InitSPCommand(_strSPGetName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), DTB);
AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), QD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), QDD_ID);
DataTable list = new DataTable();
try
{
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (list.Rows.Count > 0)
{
objEntr = (CoreQDD_FILTERInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(objEntr);
}
/// <summary>
/// Return 1: Table is exist Identity Field
/// Return 0: Table is not exist Identity Field
/// Return -1: Erro
/// </summary>
/// <param name="tableName"></param>
public Int32 Add(CoreQDD_FILTERInfo objEntr, ref string sErr)
{
int ret = -1;
connect();
InitSPCommand(_strSPInsertName);
AddParameter(CoreQDD_FILTERInfo.Field.DTB.ToString(), objEntr.DTB);
AddParameter(CoreQDD_FILTERInfo.Field.QD_ID.ToString(), objEntr.QD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.QDD_ID.ToString(), objEntr.QDD_ID);
AddParameter(CoreQDD_FILTERInfo.Field.OPERATOR.ToString(), objEntr.OPERATOR);
AddParameter(CoreQDD_FILTERInfo.Field.IS_NOT.ToString(), objEntr.IS_NOT);
try
{
//command.ExecuteNonQuery();
object tmp = executeSPScalar();
if (tmp != null && tmp != DBNull.Value)
{
ret = Convert.ToInt32(tmp);
}
else
{
ret = 0;
}
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(ret);
}
public CoreQD_SCHEMAInfo Get(
String CONN_ID,
String SCHEMA_ID,
ref string sErr)
{
CoreQD_SCHEMAInfo objEntr = new CoreQD_SCHEMAInfo(); DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetName);
AddParameter(CoreQD_SCHEMAInfo.Field.CONN_ID.ToString(), CONN_ID);
AddParameter(CoreQD_SCHEMAInfo.Field.SCHEMA_ID.ToString(), SCHEMA_ID);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
finally
{
disconnect();
}
if (list.Rows.Count > 0)
{
objEntr = new CoreQD_SCHEMAInfo(list.Rows[0]);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(objEntr);
}
public string Update_CoreQDD(CoreQDDInfo objEntr)
{
string sErr = "";
try
{
connect();
InitSPCommand(_strSPUpdateName);
AddParameter("DTB", objEntr.DTB);
AddParameter("QD_ID", objEntr.QD_ID);
AddParameter("QDD_ID", objEntr.QDD_ID);
AddParameter("CODE", objEntr.CODE);
AddParameter("DESCRIPTN", objEntr.DESCRIPTN);
AddParameter("F_TYPE", objEntr.F_TYPE);
AddParameter("SORTING", objEntr.SORTING);
AddParameter("AGREGATE", objEntr.AGREGATE);
AddParameter("EXPRESSION", objEntr.EXPRESSION);
AddParameter("FILTER_FROM", objEntr.FILTER_FROM);
AddParameter("FILTER_TO", objEntr.FILTER_TO);
AddParameter("IS_FILTER", objEntr.IS_FILTER);
excuteSPNonQuery();
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(sErr);
}
