/// <summary>
        /// 用户验证【1-成功;0-失败(账号密码不存在或者不匹配)】
        /// </summary>
        /// <param name="UserName"></param>
        /// <param name="PassWrod"></param>
        /// <returns></returns>
        public int Authentication(string Account, string Pwd)
        {
            SqlConnection conn = DBLink.GetConnection();
            SqlCommand    cmd  = new SqlCommand();

            cmd.Connection  = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "AdminAuthentication";
            cmd.Parameters.Add(new SqlParameter("@AdminAccount", Account));
            cmd.Parameters.Add(new SqlParameter("@AdminPwd", Pwd));
            try
            {
                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataTable      dt  = new DataTable();
                sda.Fill(dt);
                if (dt != null)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception)
            {
                return(0);
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }
        }
Exemple #2
0
        /// <summary>
        /// 用户验证【1-成功;0-失败(账号密码不存在或者不匹配)】
        /// </summary>
        /// <param name="UserName"></param>
        /// <param name="PassWrod"></param>
        /// <returns></returns>
        public int Authentication(string EmployerAccount, string EmployerPwd)
        {
            int           count = 0;
            SqlConnection conn  = DBLink.GetConnection();
            SqlCommand    cmd   = new SqlCommand();

            cmd.Connection  = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "EmployerAuthentication";
            cmd.Parameters.Add(new SqlParameter("@EmployerAccount", EmployerAccount));
            cmd.Parameters.Add(new SqlParameter("@EmployerPwd", EmployerPwd));
            try
            {
                conn.Open();
                count = int.Parse(cmd.ExecuteScalar().ToString());
                if (count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception)
            {
                return(0);
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }
        }
Exemple #3
0
        public JsonResult CheckEmailUnique(string email)
        {
            var           result = false;
            int           count  = 0;
            SqlConnection cnn    = DBLink.GetConnection();
            //string sqlstr = "Select Count(*) FROM Employer where Email='" + email + "' and IsDelete!=1";
            string sqlstr = "Select Count(*) FROM Employer where Email='" + email + "'";

            //检查Cookies["Employer"]是否存在(如果用户已经登陆可能是修改信息)
            if (Request.Cookies["Employer"] != null)
            {
                //用户已经登陆
                //验证用户名密码是否正确
                HttpCookie _cookie   = Request.Cookies["Employer"];
                string     _account  = _cookie["EmployerAccount"];
                string     _password = _cookie["EmployerPwd"];//cookie里存的先自己加密,再url加密的密码
                string     _isDelete = _cookie["IsDelete"];
                //Authentication是自己写的函数,验证账号密码是否正确
                if (Employer.Authentication(_account, Server.UrlDecode(_password)))
                {
                    string url        = HttpContext.Request.UrlReferrer.ToString();
                    int    pos        = url.LastIndexOf("/") + 1;
                    string actionName = url.Substring(pos, url.Length - pos);
                    //防止登陆用户再注册一个相同邮箱账号
                    if (actionName.ToLower() == "edit")
                    {
                        Employer employer = GetEmployerDetailsByAccount(_account);
                        //防止修改信息时误判断邮箱已经存在
                        sqlstr += " and Email!='" + employer.Email + "'";
                    }
                }
            }
            SqlCommand cmm = new SqlCommand(sqlstr, cnn);

            cnn.Open();
            count = int.Parse(cmm.ExecuteScalar().ToString());
            cmm.Dispose();
            cnn.Close();
            result = (count == 0);
            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Exemple #4
0
        public JsonResult CheckLoginAccount(string employeraccount)
        {
            var result = false;

            if (employeraccount.Trim() == "jobsky")
            {
                result = false;
            }
            else
            {
                int           count = 0;
                SqlConnection cnn   = DBLink.GetConnection();
                //string sqlstr = "Select Count(*) FROM Employer where EmployerAccount='" + employeraccount + "' and IsDelete!=1";
                string     sqlstr = "Select Count(*) FROM Employer where EmployerAccount='" + employeraccount + "'";
                SqlCommand cmm    = new SqlCommand(sqlstr, cnn);
                cnn.Open();
                count = int.Parse(cmm.ExecuteScalar().ToString());
                cmm.Dispose();
                cnn.Close();
                result = (count == 0);
            }
            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Exemple #5
0
        public Employer GetEmployerDetailsByAccount(string Account = "")
        {
            string account = "";

            if (Account == "")
            {
                account = EmployerAccount;
            }
            else
            {
                account = Account;
            }
            Employer      employer = new Employer();
            SqlConnection conn     = DBLink.GetConnection();
            SqlCommand    cmd      = new SqlCommand();

            cmd.Connection  = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetEmployerDetailsByAccount";
            cmd.Parameters.Add(new SqlParameter("@EmployerAccount", account));
            try
            {
                conn.Open();
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataTable      dt  = new DataTable();
                sda.Fill(dt);
                //共27个字段,Emploeyr表所有内容
                //ID
                employer.EmployerID = Int32.Parse(dt.Rows[0]["EmployerID"].ToString());
                //账号信息部分
                employer.EmployerAccount = dt.Rows[0]["EmployerAccount"].ToString();
                employer.EmployerPwd     = dt.Rows[0]["EmployerPwd"].ToString();
                //联系人信息部分
                employer.ContactPersonName = dt.Rows[0]["ContactPersonName"].ToString();
                employer.ContactPersonSex  = Int16.Parse(dt.Rows[0]["ContactPersonSex"].ToString());
                employer.FixedTelephone    = dt.Rows[0]["FixedTelephone"].ToString();
                employer.MobilePhone       = dt.Rows[0]["MobilePhone"].ToString();
                employer.Email             = dt.Rows[0]["Email"].ToString();
                //单位基本信息部分
                employer.CompanyName         = dt.Rows[0]["CompanyName"].ToString();
                employer.ParentCompanyName   = dt.Rows[0]["ParentCompanyName"].ToString();
                employer.CompanyIntroduction = dt.Rows[0]["CompanyIntroduction"].ToString();
                employer.CompanyPhone        = dt.Rows[0]["CompanyPhone"].ToString();
                employer.OrganizationCode    = dt.Rows[0]["OrganizationCode"].ToString();

                employer.ValidPeriod       = DateTime.Parse(dt.Rows[0]["ValidPeriod"].ToString());
                employer.CompanyNature     = dt.Rows[0]["CompanyNature"].ToString();
                employer.CompanyBusiness   = dt.Rows[0]["CompanyBusiness"].ToString();
                employer.CompanySize       = dt.Rows[0]["CompanySize"].ToString();
                employer.RegisteredCapital = decimal.Parse(dt.Rows[0]["RegisteredCapital"].ToString());

                employer.IsTop500            = Int32.Parse(dt.Rows[0]["IsTop500"].ToString());
                employer.CompanyAreaProvince = dt.Rows[0]["CompanyAreaProvince"].ToString();
                employer.CompanyAreaCity     = dt.Rows[0]["CompanyAreaCity"].ToString();
                employer.CompanyAddress      = dt.Rows[0]["CompanyAddress"].ToString();
                employer.CityClass           = dt.Rows[0]["CityClass"].ToString();

                employer.Remark = dt.Rows[0]["Remark"].ToString();
                //证件照片
                employer.CredentialsDir = dt.Rows[0]["CredentialsDir"].ToString();
                //其他字段
                employer.RegisterTime = DateTime.Parse(dt.Rows[0]["RegisterTime"].ToString());
                employer.IsDelete     = Int32.Parse(dt.Rows[0]["IsDelete"].ToString());

                return(employer);
            }
            catch (Exception)
            {
                return(new Employer());
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }
        }