예제 #1
0
        public static void SaveKhamBenhToDTB(KhamBenh kb)
        {
            //try
            //{
            string     q   = "insert into khambenh(msbn,msbacsy,ngaykham,ghichu) values ('" + kb.msbn + "','" + kb.msbacsy + "','" + kb.ngaykham + "','" + kb.ghichu + "')";
            SqlCommand cmd = new SqlCommand(q, ConnectDB.instance());

            cmd.ExecuteNonQuery();
            cmd.Dispose();

            //}
            //catch(Exception e)
            //{
            //    e.ToString();
            //    //Console.WriteLine("Khong the kham 2 lan trong 1 ngay trong cung 1 bac si");
            //}
        }
예제 #2
0
        private static bool checkID(KhamBenh kb)
        {
            string q = "select * from khambenh where msbn = " + "'" + kb.msbn + "'"
                       + " and msbacsy = " + "'" + kb.msbacsy + "'";
            SqlCommand cmd = new SqlCommand(q, ConnectDB.instance());

            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                if (dr.Read())
                {
                    return(true);
                }
            }
            dr.Close();
            return(false);
        }