public DataTable GetALL_CoreQDD_By_QD_ID(
String DTB,
String QD_ID
, ref string sErr)
{
CoreQDDInfo objEntr = new CoreQDDInfo();
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetAllName_By_QD_ID);
AddParameter("DTB", DTB);
AddParameter("QD_ID", QD_ID);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
finally
{
disconnect();
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
CoreErrorLog.SetLog(sErr);
}
return(list);
}
public DataTableCollection Get_Page(CoreQDDInfo 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 void InsertUpdate_CoreQD(CoreQDDInfo qddInfo, ref string sErr)
{
if (IsExist_CoreQDD(qddInfo.DTB, qddInfo.QD_ID, qddInfo.QDD_ID))
{
Update_CoreQDD(qddInfo);
}
else
{
Add_CoreQDD(qddInfo, ref sErr);
}
}
public void TransferIn(DataRow row, ref string sErr)
{
CoreQDInfo qdInfo = new CoreQDInfo(row);
InsertUpdate_CoreQD(qdInfo, ref sErr);
CoreQDDInfo qddInfo = new CoreQDDInfo();
qddInfo.GetTransferIn(row);
CoreQDDControl qddCtr = new CoreQDDControl();
qddCtr.InsertUpdate_CoreQD(qddInfo, ref sErr);
}
/// <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);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
CoreQDDInfo result = new CoreQDDInfo();
result.DTB = (dt.Rows[i]["DTB"] == DBNull.Value ? "" : (String)dt.Rows[i]["DTB"]);
result.QD_ID = (dt.Rows[i]["QD_ID"] == DBNull.Value ? "" : (String)dt.Rows[i]["QD_ID"]);
result.QDD_ID = (dt.Rows[i]["QDD_ID"] == DBNull.Value ? -1 : (Int32)dt.Rows[i]["QDD_ID"]);
result.CODE = (dt.Rows[i]["CODE"] == DBNull.Value ? "" : (String)dt.Rows[i]["CODE"]);
result.DESCRIPTN = (dt.Rows[i]["DESCRIPTN"] == DBNull.Value ? "" : (String)dt.Rows[i]["DESCRIPTN"]);
result.F_TYPE = (dt.Rows[i]["F_TYPE"] == DBNull.Value ? "" : (String)dt.Rows[i]["F_TYPE"]);
result.SORTING = (dt.Rows[i]["SORTING"] == DBNull.Value ? "" : (String)dt.Rows[i]["SORTING"]);
result.AGREGATE = (dt.Rows[i]["AGREGATE"] == DBNull.Value ? "" : (String)dt.Rows[i]["AGREGATE"]);
result.EXPRESSION = (dt.Rows[i]["EXPRESSION"] == DBNull.Value ? "" : (String)dt.Rows[i]["EXPRESSION"]);
result.FILTER_FROM = (dt.Rows[i]["FILTER_FROM"] == DBNull.Value ? "" : (String)dt.Rows[i]["FILTER_FROM"]);
result.FILTER_TO = (dt.Rows[i]["FILTER_TO"] == DBNull.Value ? "" : (String)dt.Rows[i]["FILTER_TO"]);
result.IS_FILTER = (dt.Rows[i]["IS_FILTER"] == DBNull.Value ? true : (Boolean)dt.Rows[i]["IS_FILTER"]);
return(result);
}
public CoreQDDInfo Get_CoreQDD(
String DTB,
String QD_ID,
Int32 QDD_ID
, ref string sErr)
{
CoreQDDInfo objEntr = new CoreQDDInfo();
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetName);
AddParameter("DTB", DTB);
AddParameter("QD_ID", QD_ID);
AddParameter("QDD_ID", QDD_ID);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
if (list.Rows.Count > 0)
{
objEntr = (CoreQDDInfo)GetDataFromDataRow(list, 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);
}
private string CreateWhereClause(CoreQDDInfo obj)
{
String result = "";
return(result);
}
/* public string Delete_CoreQDD(String arrID)
* {
* string kq = "";
* string[] arrStrID = arrID.Split(',');
* foreach (string strID in arrStrID)
* {
* if (strID != "")
* {
* int ID = Convert.ToInt32(strID);
* kq += _CoreQDDDAO.Delete_CoreQDD(ID);
* }
* }
* return kq;
* } */
public DataTableCollection Get_Page(CoreQDDInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
return(_CoreQDDDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr));
}
public string Update_CoreQDD(CoreQDDInfo obj)
{
return(_CoreQDDDAO.Update_CoreQDD(obj));
}
public Int32 Add_CoreQDD(CoreQDDInfo obj, ref string sErr)
{
return(_CoreQDDDAO.Add_CoreQDD(obj, ref sErr));
}
