Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
0
        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);
        }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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);
        }
Ejemplo n.º 7
0
        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);
        }
Ejemplo n.º 8
0
        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);
        }
Ejemplo n.º 9
0
        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);
        }
Ejemplo n.º 10
0
        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);
        }
Ejemplo n.º 11
0
        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);
        }
Ejemplo n.º 12
0
        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);
        }
Ejemplo n.º 13
0
        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("");
            }
        }
Ejemplo n.º 14
0
        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);
        }
Ejemplo n.º 15
0
        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);
        }
Ejemplo n.º 16
0
        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);
        }
Ejemplo n.º 17
0
        /// <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);
        }
Ejemplo n.º 18
0
        /// <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);
        }
Ejemplo n.º 19
0
        /// <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);
        }
Ejemplo n.º 20
0
        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);
        }
Ejemplo n.º 21
0
        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);
        }
Ejemplo n.º 22
0
        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);
        }
Ejemplo n.º 23
0
        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);
        }
Ejemplo n.º 24
0
        /// <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);
        }
Ejemplo n.º 25
0
        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);
        }
Ejemplo n.º 26
0
        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);
        }