Beispiel #1
0
        public static List <Cases> ListOnline(string Q)
        {
            try
            {
                p.Clear();

                MySqlDataReader Reader = MySQL.Reading(Q);
                while (Reader.Read())
                {
                    Cases ps = new Cases(Reader["id"].ToString(), Reader["date"].ToString(), Reader["no"].ToString(), Reader["provideNo"].ToString(), Reader["coverageID"].ToString(), Reader["customerID"].ToString(), Reader["practitionerID"].ToString(), Reader["practitionerType"].ToString(), Reader["roleType"].ToString(), Reader["type"].ToString(), Reader["place"].ToString(), Reader["information"].ToString(), Reader["created"].ToString(), Reader["reqStart"].ToString(), Reader["reqEnd"].ToString(), Reader["authStart"].ToString(), Reader["authEnd"].ToString(), Reader["sync"].ToString(), Reader["companyID"].ToString());
                    p.Add(ps);
                }
                DBConnect.CloseMySqlConn();
            }
            catch { }
            return(p);
        }
Beispiel #2
0
        public static List <Cases> List(string Q)
        {
            //try
            //{
            p.Clear();

            MySqlDataReader Reader = MySQL.Reading(Q);

            while (Reader.Read())
            {
                Cases ps = new Cases(Reader["id"].ToString(), Reader["date"].ToString(), Reader["no"].ToString(), Reader["provideNo"].ToString(), Reader["coverageID"].ToString(), Reader["customerID"].ToString(), Reader["practitionerID"].ToString(), Reader["practitionerType"].ToString(), Reader["roleType"].ToString(), Reader["type"].ToString(), Reader["place"].ToString(), Reader["information"].ToString(), Reader["created"].ToString(), Reader["reqStart"].ToString(), Reader["reqEnd"].ToString(), Reader["authStart"].ToString(), Reader["authEnd"].ToString(), Reader["sync"].ToString(), Reader["companyID"].ToString());
                p.Add(ps);
            }
            DBConnect.CloseMySqlConn();
            //}
            //catch (Exception e)
            //{

            //    System.Diagnostics.Debug.WriteLine("" + e);
            //}
            return(p);
        }