학원관리 로그인 처리 및 수업 추가 예제 소스

728x90

학원관리 로그인 처리 및 수업 추가 예제 소스

 

로그인 함수 및 수업추가 함수

 

public static AcademyInfo LoginAccount(string id, string pw)
        {
            AcademyInfo result = null;

            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_Login_Account";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@id", id));
                parameters.Add(new SqlParameter("@pw", pw));

                DataTable dt = sql.ExecuteProcedure(strProc, parameters);
                if (dt == null || dt.Rows.Count <= 0) return result;

                foreach (DataRow row in dt.Rows)
                {
                    result = new AcademyInfo()
                    {
                        idx = Convert.ToInt32(row["idx"]),
                        id = row["id"].ToString(),
                        pw = row["pw"].ToString(),
                        name = row["name"].ToString(),
                        level = Convert.ToInt32(row["level"]),
                        regdate = Convert.ToDateTime(row["regdate"]),
                        signed = Convert.ToBoolean(row["signed"]),
                        pdname = row["pdname"].ToString(),
                        telephone = row["telephone"].ToString(),
                        fax = row["fax"].ToString(),
                        zip = row["zip"].ToString(),
                        address1 = row["address1"].ToString(),
                        address2 = row["address2"].ToString(),
                        homepage = row["homepage"].ToString(),
                        mobile = row["mobile"].ToString(),
                        code = row["Code"].ToString()
                    };
                }
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }

        public static bool InsertUpdateAcademy(int idx, string name, string id, string pw, int level, bool signed, string pdname, string telephone, string fax, string zip, string address1, string address2, string homepage, string mobile)
        {
            bool result = false;
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_Academy_Update";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@idx", idx));
                parameters.Add(new SqlParameter("@name", name));
                parameters.Add(new SqlParameter("@signed", signed));
                parameters.Add(new SqlParameter("@level", level));
                parameters.Add(new SqlParameter("@id", id));
                parameters.Add(new SqlParameter("@pw", pw));
                parameters.Add(new SqlParameter("@pdname", pdname));
                parameters.Add(new SqlParameter("@telephone", telephone));
                parameters.Add(new SqlParameter("@fax", fax));
                parameters.Add(new SqlParameter("@zip", zip));
                parameters.Add(new SqlParameter("@address1", address1));
                parameters.Add(new SqlParameter("@address2", address2));
                parameters.Add(new SqlParameter("@homepage", homepage));
                parameters.Add(new SqlParameter("@mobile", mobile));

                result = (sql.ExecuteNonProcedure(strProc, parameters) > 0);
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }