示例#1
0
        //----------------------------------------------

        //----------------------------------------------
        private bool IsSameDeptCode(iLocalDB db, string code)
        {
            db.Open();
            string query   = string.Format("SELECT xDept_name FROM xDEPARTMENT WHERE xDept_code='{0}'", code); // {0}에는 code 값이 들어감
            string err_msg = db.Query(query);
            string title   = "";

            if (err_msg != null)
            {
                MessageBox.Show(query + "\n\n" + err_msg, "SQL Error");
                return(false);
            }
            db.ExecuteReader(query);

            while (db.Read())
            {
                title = db.GetData("xDept_name").ToString();
            }
            if (title != cbx_학과입력.SelectedValue.ToString())  //입력 학과랑 학번이랑 틀림
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
示例#2
0
        }//Main

        //--------------------------------------------------
        static bool? tableExists(iLocalDB db, string tableName)
        {

            string result = db.Query(string.Format("select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME='{0}'", tableName));

            if (result != null) return null;

            return db.HasRows;

        }
示例#3
0
        //----------------------------------------------

        //----------------------------------------------
        static bool DB_Query(iLocalDB db, string query)
        {
            string err_msg = db.Query(query);

            if (err_msg != null)
            {
                MessageBox.Show("Error\n" + err_msg + "\n" + query);
                return(false);
            }
            return(true);
        }
示例#4
0
		//------------------------------------------------
		static bool DB_Query(iLocalDB db, string query)
        {
            string err_msg = db.Query(query);

            if (err_msg != null)
            {
                Console.WriteLine("Error\n" + err_msg + "\n" + query);
                return false;
            }
            return true;
        }
示例#5
0
		//-----------------------------------------------
		static bool IsValidDeptCode(iLocalDB db, string code)
		{
			string query = string.Format("SELECT * FROM xDEPARTMENT WHERE xDept_code='{0}'", code);
			string res = db.Query(query);
			if(res != null)
			{
				Console.WriteLine(res);
				return false;
			}
			
			if (db.HasRows) return true;

			return false;
		}
示例#6
0
        //---------------------------------------------------
        static bool IsNewHakbun(iLocalDB db, string hakbun)
        {
            string query = string.Format("SELECT xHakbun FROM xSTUDENTS WHERE xHakbun='{0}'", hakbun);
            string res = db.Query(query);
            if (res != null)
            {
                Console.WriteLine(res);
                return false;
            }

            if (db.HasRows) return Error("같은 학번이 이미 존재합니다." + hakbun);

            return true;
        }
        //-----------------------------------------------
        private bool IsNewHakbun(iLocalDB db, string hakbun)
        {
            string query = string.Format("select xHakbun from xSTUDENTS where xHakbun='{0}'", hakbun);
            string res   = db.Query(query);

            if (res != null)
            {
                return(false);
            }

            if (db.HasRows)
            {
                return(Error("같은 학번이 이미 존재합니다." + hakbun));
            }

            return(true);
        }
        //-----------------------------------------------
        private bool IsValidDeptCode(iLocalDB db, string code)
        {
            string query = string.Format("SELECT * FROM xDEPARTMENT WHERE xDept_code='{0}'", code);
            string res   = db.Query(query);

            if (res != null)
            {
                MessageBox.Show(res);
                return(false);
            }

            if (db.HasRows)
            {
                return(true);
            }

            return(false);
        }
示例#9
0
        //----------------------------------------------

        //----------------------------------------------
        private bool IsNewHackbun(iLocalDB db, string 학번)
        {
            string query = string.Format("SELECT xHakbun FROM xSTUDENTS WHERE xHakbun='{0}'", 학번);  // {0}에는 code 값이 들어감
            string res   = db.Query(query);

            if (res == "")
            {
                MessageBox.Show(res);
                return(false);
            }
            else if (db.HasRows)
            {
                return(Error("같은 학번이 이미 존재합니다" + 학번));
            }
            else
            {
                return(true);
            }
        }