protected override object GetDataFromDataRow(DataTable dt, int i)
{
LIST_QDInfo result = new LIST_QDInfo();
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.DESCRIPTN = (dt.Rows[i]["DESCRIPTN"] == DBNull.Value ? "" : (String)dt.Rows[i]["DESCRIPTN"]);
result.OWNER = (dt.Rows[i]["OWNER"] == DBNull.Value ? "" : (String)dt.Rows[i]["OWNER"]);
result.SHARED = (dt.Rows[i]["SHARED"] == DBNull.Value ? true : (Boolean)dt.Rows[i]["SHARED"]);
result.LAYOUT = (dt.Rows[i]["LAYOUT"] == DBNull.Value ? "" : (String)dt.Rows[i]["LAYOUT"]);
result.ANAL_Q0 = (dt.Rows[i]["ANAL_Q0"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q0"]);
result.ANAL_Q9 = (dt.Rows[i]["ANAL_Q9"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q9"]);
result.ANAL_Q8 = (dt.Rows[i]["ANAL_Q8"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q8"]);
result.ANAL_Q7 = (dt.Rows[i]["ANAL_Q7"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q7"]);
result.ANAL_Q6 = (dt.Rows[i]["ANAL_Q6"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q6"]);
result.ANAL_Q5 = (dt.Rows[i]["ANAL_Q5"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q5"]);
result.ANAL_Q4 = (dt.Rows[i]["ANAL_Q4"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q4"]);
result.ANAL_Q3 = (dt.Rows[i]["ANAL_Q3"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q3"]);
result.ANAL_Q2 = (dt.Rows[i]["ANAL_Q2"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q2"]);
result.ANAL_Q1 = (dt.Rows[i]["ANAL_Q1"] == DBNull.Value ? "" : (String)dt.Rows[i]["ANAL_Q1"]);
result.SQL_TEXT = (dt.Rows[i]["SQL_TEXT"] == DBNull.Value ? "" : (String)dt.Rows[i]["SQL_TEXT"]);
result.HEADER_TEXT = (dt.Rows[i]["HEADER_TEXT"] == DBNull.Value ? "" : (String)dt.Rows[i]["HEADER_TEXT"]);
result.FOOTER_TEXT = (dt.Rows[i]["FOOTER_TEXT"] == DBNull.Value ? "" : (String)dt.Rows[i]["FOOTER_TEXT"]);
return(result);
}
private static void LoadQD(LIST_QDInfo info)
{
_sqlBuilder.Filters.Clear();
_sqlBuilder.SelectedNodes.Clear();
//radTabStrip1.Se
_sqlBuilder = SQLBuilder.LoadSQLBuilderFromDataBase(info.QD_ID, info.DTB, info.ANAL_Q0.Trim());
}
public DataTable GetAll_LIST_QD(String DTB, ref string sErr)
{
LIST_QDInfo objEntr = new LIST_QDInfo(); 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(list);
}
public DataTableCollection Get_Page(LIST_QDInfo 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_QDInfo lIST_QDInfo, ref string sErr)
{
if (IsExist_LIST_QD(lIST_QDInfo.DTB, lIST_QDInfo.QD_ID))
{
sErr = Update_LIST_QD(lIST_QDInfo);
}
else
{
Add_LIST_QD(lIST_QDInfo, ref sErr);
}
}
private void btSave_Click(object sender, EventArgs e)
{
if (dgvQDView.CurrentRow != null && dgvQDView.CurrentRow.RowIndex >= 0)
{
String qd_id = dgvQDView.CurrentRow.Cells["QD_ID"].Value.ToString();
String dtb = dgvQDView.CurrentRow.Cells["DTB"].Value.ToString();
LIST_QDControl ctr = new LIST_QDControl();
qdinfo = ctr.Get_LIST_QD(dtb, qd_id, ref sErr);
DialogResult = DialogResult.OK;
Close();
}
}
/// <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_QD(LIST_QDInfo 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(ret);
}
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);
}
}
public string Update_LIST_QD(LIST_QDInfo 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 != "")
{
ErrorLog.SetLog(sErr);
}
return(sErr);
}
public DataTable GetAll_LIST_QD_USER(string database, string user, ref string sErr)
{
LIST_QDInfo objEntr = new LIST_QDInfo();
DataTable list = new DataTable();
try
{
connect();
InitSPCommand(_strSPGetAllByUserName);
AddParameter("DTB", database);
AddParameter("USER_ID", user);
list = executeSelectSP(command);
}
catch (Exception ex)
{
sErr = ex.Message;
}
disconnect();
return(list);
}
public LIST_QDInfo Get_LIST_QD(
String DTB,
String QD_ID
, ref string sErr)
{
LIST_QDInfo objEntr = new LIST_QDInfo();
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 = (LIST_QDInfo)GetDataFromDataRow(list, 0);
}
//if (dr != null) list = CBO.FillCollection(dr, ref list);
if (sErr != "")
{
ErrorLog.SetLog(sErr);
}
return(objEntr);
}
/* public string Delete_LIST_QD(String arrID)
* {
* string kq = "";
* string[] arrStrID = arrID.Split(',');
* foreach (string strID in arrStrID)
* {
* if (strID != "")
* {
* int ID = Convert.ToInt32(strID);
* kq += _LIST_QDDAO.Delete_LIST_QD(ID);
* }
* }
* return kq;
* } */
public DataTableCollection Get_Page(LIST_QDInfo obj, string orderBy, int pageIndex, int pageSize, ref String sErr)
{
return(_LIST_QDDAO.Get_Page(obj, orderBy, pageIndex, pageSize, ref sErr));
}
public string Update_LIST_QD(LIST_QDInfo obj)
{
return(_LIST_QDDAO.Update_LIST_QD(obj));
}
public Int32 Add_LIST_QD(LIST_QDInfo obj, ref string sErr)
{
return(_LIST_QDDAO.Add_LIST_QD(obj, ref sErr));
}
private string CreateWhereClause(LIST_QDInfo obj)
{
String result = "";
return(result);
}
