Example #1
0
File: admin.cs Project: lamjar/shop
        public static List <admininfo> getAdminListPage(pageinfo item)
        {
            List <admininfo> adminlist = new List <admininfo>();

            try
            {
                DataTable dt = pagehelper.getpagedt(item);
                if (dt != null)
                {
                    foreach (DataRow reader in dt.Rows)
                    {
                        admininfo data = new admininfo();
                        data.adminid    = TypeParse.DbObjToInt(reader["adminid"], 0);
                        data.adminname  = TypeParse.DbObjToString(reader["adminname"], "");
                        data.adddate    = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now);
                        data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now);
                        adminlist.Add(data);
                    }
                }

                return(adminlist);
            }
            catch (Exception E)
            {
                throw new Exception(E.Message);
            }
            finally
            { }
        }
Example #2
0
File: admin.cs Project: lamjar/shop
        /// <summary>
        /// 读取系统管理员信息
        /// </summary>
        /// <param name="adminid"></param>
        /// <returns></returns>
        public static admininfo getAdminInfo(int adminid)
        {
            SqlParameter[] parms = new SqlParameter[1];
            parms[0]       = new SqlParameter("@adminid", SqlDbType.Int);
            parms[0].Value = adminid;

            admininfo data = new admininfo();
            string    sql  = "SELECT adminid,adminname,roleid,adddate,updatedate FROM SysAdmin WHERE  adminid=@adminid";

            try
            {
                SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms);
                if (reader.Read())
                {
                    data.adminid    = TypeParse.DbObjToInt(reader["adminid"], 0);
                    data.adminname  = TypeParse.DbObjToString(reader["adminname"], "");
                    data.adddate    = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now);
                    data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now);
                    reader.Close();
                    reader.Dispose();
                }
                return(data);
            }
            catch (Exception E)
            {
                throw new Exception(E.Message);
            }
            finally
            { }
        }
Example #3
0
File: admin.cs Project: lamjar/shop
        /// <summary>
        /// 添加新管理员
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public static bool AddNewAdmin(admininfo data)
        {
            SqlParameter[] parms = new SqlParameter[5];
            parms[0]       = new SqlParameter("@adminname", SqlDbType.VarChar, 20);
            parms[0].Value = data.adminname;
            parms[1]       = new SqlParameter("@adminpwd", SqlDbType.VarChar, 50);
            parms[1].Value = data.adminpwd;
            parms[2]       = new SqlParameter("@adddate", SqlDbType.DateTime);
            parms[2].Value = data.adddate;
            parms[3]       = new SqlParameter("@updatedate", SqlDbType.DateTime);
            parms[3].Value = data.updatedate;
            parms[4]       = new SqlParameter("@roleid", SqlDbType.Int);
            parms[4].Value = data.roleid;

            string sql = "INSERT INTO SysAdmin (adminname,adminpwd,adddate,updatedate,roleid) " +
                         "values (@adminname,@adminpwd,@adddate,@updatedate,@roleid)";

            int result = 0;

            try
            {
                result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
            }
            catch (Exception E)
            {
                throw new Exception(E.Message);
            }
            finally
            { }
            return(result > 0);
        }
Example #4
0
File: admin.cs Project: lamjar/shop
        /// <summary>
        /// 得到管理员信息列表
        /// </summary>
        /// <param name="pdata"></param>
        /// <returns></returns>
        public static List <admininfo> getAdminList()
        {
            List <admininfo> adminlist = new List <admininfo>();
            string           sql       = "SELECT adminid,adminname,roleid,adddate,updatedate FROM SysAdmin";

            try
            {
                DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql).Tables[0];
                if (dt != null)
                {
                    foreach (DataRow reader in dt.Rows)
                    {
                        admininfo data = new admininfo();
                        data.adminid    = TypeParse.DbObjToInt(reader["adminid"], 0);
                        data.adminname  = TypeParse.DbObjToString(reader["adminname"], "");
                        data.adddate    = TypeParse.DbObjToDateTime(reader["adddate"], DateTime.Now);
                        data.updatedate = TypeParse.DbObjToDateTime(reader["updatedate"], DateTime.Now);
                        adminlist.Add(data);
                    }
                }

                return(adminlist);
            }
            catch (Exception E)
            {
                throw new Exception(E.Message);
            }
            finally
            { }
        }
Example #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            admininfo item = new admininfo();

            if (Request.QueryString["adminid"] != null)
            {
                string aid = Request.QueryString["adminid"].ToString();
                item          = admin.getAdminInfo(TypeParse.DbObjToInt(aid, 0));
                adminnameHTML = item.adminname;
            }
        }
Example #6
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Request.Cookies["g_adminid"] != null)
     {
         string    userid  = Request.Cookies["g_adminid"].Value.ToString();
         int       adminid = Int32.Parse(userid);
         admininfo data    = admin.getAdminInfo(adminid);
         accountsHtml = "<span class=\"yellow\">" + data.adminname + "</span>";
     }
     else
     {
         Response.Redirect("/Login/AdminLogin.aspx");
     }
 }
Example #7
0
        public string editadminpwd(string newpwd, string adminid)
        {
            admininfo data = new admininfo();

            data.adminid    = TypeParse.DbObjToInt(adminid, 0);
            data.adminpwd   = TextEncrypt.EncryptPassword(newpwd);
            data.updatedate = DateTime.Now;
            bool result = admin.updatepwd(data);

            if (result)
            {
                return("t");
            }
            else
            {
                return("f");
            }
        }
        public async Task <ActionResult> AdminPage(FormCollection formCollection)
        {
            adminVM adminVM = new adminVM();

            admininfo admininfo = new admininfo();
            admininfo adminL    = new admininfo();

            string adminEmail    = formCollection[1];
            string adminPassword = formCollection[2];

            admininfo.adminEmail    = adminEmail;
            admininfo.adminPassword = adminPassword;

            var json = JsonConvert.SerializeObject(new adminVM {
                adminEmail = adminEmail, adminPassword = adminPassword
            });
            var data = new StringContent(json, Encoding.UTF8, "application/json");

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(Shared.ServerConfig.GetBaseUrl());
                client.DefaultRequestHeaders.Clear();
                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

                HttpResponseMessage result = await client.PostAsync("admin/adminLogin/", data);

                var response = result.Content.ReadAsStringAsync().Result;
                Console.WriteLine(response);
                //adminL = JsonConvert.DeserializeObject<admininfo>(response);
                if (response == "null")
                {
                    //means login credentials were wrong
                    return(View("AdminLogin"));
                }
                else
                {
                    //adminVM.admininfos = adminL;
                    return(View("Index"));
                    //succeed logging in
                }
            }
        }
Example #9
0
        public string addadmin(string pwd, string adminname)
        {
            admininfo data = new admininfo();

            data.adminname  = adminname;
            data.adminpwd   = TextEncrypt.EncryptPassword(pwd);
            data.adddate    = DateTime.Now;
            data.updatedate = DateTime.Now;
            data.roleid     = 0;
            bool result = admin.AddNewAdmin(data);

            if (result)
            {
                return("t");
            }
            else
            {
                return("f");
            }
        }
Example #10
0
File: admin.cs Project: lamjar/shop
        /// <summary>
        /// 修改登录密码
        /// </summary>
        /// <param name="item"></param>
        /// <returns></returns>
        public static bool updatepwd(admininfo item)
        {
            SqlParameter[] parms = new SqlParameter[2];
            parms[0]       = new SqlParameter("@npwd", SqlDbType.VarChar, 50);
            parms[0].Value = item.adminpwd;
            parms[1]       = new SqlParameter("@AdminID", SqlDbType.Int);
            parms[1].Value = item.adminid;

            string sql    = "UPDATE SysAdmin SET adminpwd=@npwd WHERE adminid=@adminid";
            int    result = 0;

            try
            {
                result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
            }
            catch (Exception E)
            {
                throw new Exception(E.Message);
            }
            finally
            { }
            return(result > 0);
        }