예제 #1
0
 public DBReport(DBReport obj)
 {
     PropertyInfo[] p = obj.GetType().GetProperties();                               // get entity properties
     for (int i = 0; i < (p.Length); i++)
     {
         if (!p[i].PropertyType.Name.Contains("list") && !p[i].Name.Contains("arg"))
             p[i].SetValue(this, p[i].GetValue(obj, null), null);                    // set entity's property values to obj properties
     }
 }
예제 #2
0
        // fetches list of reports given a report type
        // if rpt_type = "ALL" then fetches all reports
        public static object FetchReportList(string rpt_type)
        {
            ArrayList list = new ArrayList();
            DBReport item = new DBReport();
            string qryString;
            PropertyInfo[] p = item.GetType().GetProperties();

            if (rpt_type == "ALL")
                qryString = "SELECT * FROM REPORTLIST WHERE RPT IS NOT NULL ORDER BY RPT_ID";
            else
                qryString = "SELECT * FROM REPORTLIST WHERE RPT_TYPE LIKE @rpt_type ORDER BY RPT_ID";

            // create database connection
            User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
            IDBManager dbmgr = new DBManager(user.plantDBStr);
            dbmgr.ConnectionString = user.plantDBStr;

            try
            {
                dbmgr.Open();
                dbmgr.CreateParameters(1);
                dbmgr.AddParameters(0, "@rpt_type", rpt_type);
                dbmgr.ExecuteReader(System.Data.CommandType.Text, qryString);

                while (dbmgr.DataReader.Read())
                {
                    item = new DBReport();
                    item = (DBReport)TotalManager.FetchObject(item, p, dbmgr);
                    list.Add(item);
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                dbmgr.Dispose();
            }

            return list;
        }
예제 #3
0
        // fetches report infomration for a given report id
        public static DBReport FetchReport(int id)
        {
            DBReport report = new DBReport();
            string qryString;

            qryString = "SELECT * FROM REPORTLIST WHERE RPT_ID = @rpt_id";

            // create database connection
            User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
            IDBManager dbmgr = new DBManager(user.plantDBStr);
            dbmgr.ConnectionString = user.plantDBStr;

            try
            {
                dbmgr.Open();
                dbmgr.CreateParameters(1);
                dbmgr.AddParameters(0, "@rpt_id", id);
                dbmgr.ExecuteReader(System.Data.CommandType.Text, qryString);

                if (dbmgr.DataReader.Read())
                {
                    // get properties of object and fetch object
                    PropertyInfo[] p = report.GetType().GetProperties();
                    report = (DBReport)TotalManager.FetchObject(report, p, dbmgr);
                }

            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                dbmgr.Dispose();
            }

            return report;
        }