public DataTable GetALL_LIST_QDD_By_QD_ID(
String DTB,
String QD_ID
, ref string sErr)
{
LIST_QDDInfo objEntr = new LIST_QDDInfo();
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 != "")
{
ErrorLog.SetLog(sErr);
}
return(list);
}
public DataTableCollection Get_Page(LIST_QDDInfo 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(dtList);
}
public void InsertUpdate_LIST_QD(LIST_QDDInfo qddInfo, ref string sErr)
{
if (IsExist_LIST_QDD(qddInfo.DTB, qddInfo.QD_ID, qddInfo.QDD_ID))
{
Update_LIST_QDD(qddInfo);
}
else
{
Add_LIST_QDD(qddInfo, ref sErr);
}
}
public void TransferIn(DataRow row, ref string sErr)
{
DTO.LIST_QDInfo qdInfo = new LIST_QDInfo(row);
InsertUpdate_LIST_QD(qdInfo, ref sErr);
DTO.LIST_QDDInfo qddInfo = new LIST_QDDInfo();
qddInfo.GetTransferIn(row);
DTO.LIST_QDD_FILTERInfo qddFInfo = new LIST_QDD_FILTERInfo(row);
BUS.LIST_QDDControl qddCtr = new LIST_QDDControl();
qddCtr.InsertUpdate_LIST_QD(qddInfo, ref sErr);
BUS.LIST_QDD_FILTERControl filterCtr = new LIST_QDD_FILTERControl();
if (qddFInfo.OPERATOR != "" && qddFInfo.OPERATOR != "-")
{
filterCtr.InsertUpdate(qddFInfo);
}
}
/// <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_LIST_QDD(LIST_QDDInfo 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(ret);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
LIST_QDDInfo result = new LIST_QDDInfo();
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 LIST_QDDInfo Get_LIST_QDD(
String DTB,
String QD_ID,
Int32 QDD_ID
, ref string sErr)
{
LIST_QDDInfo objEntr = new LIST_QDDInfo();
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 = (LIST_QDDInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(objEntr);
}
public string Update_LIST_QDD(LIST_QDDInfo 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(sErr);
}
/* public string Delete_LIST_QDD(String arrID)
* {
* string kq = "";
* string[] arrStrID = arrID.Split(',');
* foreach (string strID in arrStrID)
* {
* if (strID != "")
* {
* int ID = Convert.ToInt32(strID);
* kq += _LIST_QDDDAO.Delete_LIST_QDD(ID);
* }
* }
* return kq;
* } */
public DataTableCollection Get_Page(LIST_QDDInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
return(_LIST_QDDDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr));
}
public string Update_LIST_QDD(LIST_QDDInfo obj)
{
return(_LIST_QDDDAO.Update_LIST_QDD(obj));
}
public Int32 Add_LIST_QDD(LIST_QDDInfo obj, ref string sErr)
{
return(_LIST_QDDDAO.Add_LIST_QDD(obj, ref sErr));
}
private string CreateWhereClause(LIST_QDDInfo obj)
{
String result = "";
return(result);
}
