/// ------------------------------------------------------- /// <summary> /// 사용자 회원가입 /// </summary> /// <returns> 0:성공, <> 0 실패, 중복 ID 존재: -1</returns> /// ------------------------------------------------------- public int RegisterUser(TAcctMst objTAcctMst) { pl_objAesEncrypt = new AESEncrypt(); try { pl_objSqlCommand = new SqlCommand("dbo.UP_ACCT_INFO_NT_INS", pl_objSqlCon); pl_objSqlCommand.CommandType = CommandType.StoredProcedure; pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserID", objTAcctMst.UserID); pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserName", objTAcctMst.UserName); pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserPwd", pl_objAesEncrypt.Encrypt(objTAcctMst.UserPwd)); pl_objSqlCommand.Parameters.AddWithValue("@pi_dtBirthDay", objTAcctMst.BirthDay); pl_objSqlCommand.Parameters.AddWithValue("@pi_intGenderCode", objTAcctMst.GenderCode); pl_objSqlCommand.Parameters.AddWithValue("@pi_strEmailAddr", objTAcctMst.EmailAddr); pl_objSqlParam = new SqlParameter(); pl_objSqlParam.ParameterName = "@po_intRetVal"; pl_objSqlParam.SqlDbType = SqlDbType.Int; pl_objSqlParam.Direction = ParameterDirection.Output; pl_objSqlCommand.Parameters.Add(pl_objSqlParam); pl_objSqlCon.Open(); pl_objSqlCommand.ExecuteNonQuery(); pl_intRetValue = Convert.ToInt32(pl_objSqlParam.Value); return(pl_intRetValue); } catch (Exception pl_objEx) { Console.WriteLine(pl_objEx); return(1); } finally { pl_objSqlCon.Close(); } }
private int pl_intRetValue = 0; // 성공 여부 결과값 성공:0,실패:-1 /// ------------------------------------------------------- /// <summary> /// 사용자 로그인 /// </summary> /// <param>성공 pl_intRetValue:0, 아이디 미존재 pl_intRetValue:-1, 아이디 미존재 pl_intRetValue:-2</param> /// ------------------------------------------------------- public int LoginUser(string strUserID, string strUserPwd) { pl_objAesEncrypt = new AESEncrypt(); string strEncript = pl_objAesEncrypt.Encrypt(strUserPwd); try { pl_objSqlCommand = new SqlCommand("dbo.UP_ACCT_INFO_NT_GET", pl_objSqlCon); pl_objSqlCommand.CommandType = CommandType.StoredProcedure; pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserID", strUserID); pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserPwd", strEncript); pl_objSqlParam = new SqlParameter(); pl_objSqlParam.ParameterName = "@po_intRetVal"; pl_objSqlParam.SqlDbType = SqlDbType.Int; pl_objSqlParam.Direction = ParameterDirection.Output; pl_objSqlCommand.Parameters.Add(pl_objSqlParam); pl_objSqlCon.Open(); pl_objSqlCommand.ExecuteNonQuery(); pl_intRetValue = Convert.ToInt32(pl_objSqlParam.Value); return(pl_intRetValue); } catch (Exception pl_objEx) { Console.WriteLine(pl_objEx); return(1); } finally { pl_objSqlCon.Close(); } }