Esempio n. 1
0
    /// <summary>
    /// 保存管理员信息
    /// </summary>
    protected void UserSave()
    {
        mU.UserName = this.UserName.Text;
        mU.UserPwd  = Encryp.DESEncrypt(this.UserPwd.Text);
        mField mF = new mField();
        bField bF = new bField();

        mF.TableName = mm.TableName;
        DataSet ds = bF.FieldList(mF);
        string  Field = "", Val = "";

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            Field += ds.Tables[0].Rows[i]["Field"].ToString() + ",";
            Val   += HXD.ModelField.Common.FieldType.FormatField(ds.Tables[0].Rows[i]["Type"].ToString(), ds.Tables[0].Rows[i]["Field"].ToString()) + "{$split$}";
        }
        if (mU.Id == 0)
        {
            Field += "Id";
            Val   += bU.UserInsert(mU).ToString();
            bm.ModelInsert(mm.TableName, Field, Val);
        }
        else
        {
            Field += "1";
            Val   += "1";
            bU.UserUpdate(mU);
            bm.ModelUpdate(mm.Id, mm.TableName, Field.Trim(','), Val.Trim(','));
        }
        StringDeal.Alter("保存完成!", "User_Manage.aspx?GroupId=" + mU.GroupId + "");
    }
Esempio n. 2
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        string MenuId   = Request.QueryString["MenuId"].ToString();
        string username = this.username.Text.Trim();
        string userpwd  = Encryp.DESEncrypt(this.userpwd.Text.Trim());

        string tell  = this.Texttell.Text.Trim();
        string xname = this.Textname.Text.Trim();

        string  sqls = "select * from tb_User where UserName='******'";
        DataSet ds   = HXD.DBUtility.SQLHelper.ExecuteDataset(sqls);

        if (ds.Tables[0].Rows.Count == 0)
        {
            string sql = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + username + "','" + userpwd + "',6,'" + MenuId + "',1)";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
            //Session["AdminManage"] = username;

            System.Threading.Thread.Sleep(1000);
            string sql2 = "select id from tb_User where UserName='******' and datediff(mi,RegTime,getdate())<=1";
            string icd  = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();
            //Session["userid"] = icd;
            string sql3 = "insert into tb_U_User (Id,Tel,name)values('" + icd + "','" + tell + "','" + xname + "')";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql3);
            StringDeal.Alter("添加成功!");
        }
        else
        {
            Response.Write("用户名已存在");
        }
    }
Esempio n. 3
0
        public UserResponse Auth(AuthRequest authRequest)
        {
            UserResponse userResponse = new UserResponse();

            string passwordEncrypt = Encryp.GetSHA256(authRequest.Password);

            var user = _appDbContext.Users.
                       Where(u => u.Email == authRequest.Email && u.Password == passwordEncrypt)
                       .Include(r => r.Rol)
                       .FirstOrDefault();

            int validezToken = (_appSettings != null ? _appSettings.HorasValidezToken : 1);

            if (user == null)
            {
                return(null);
            }
            userResponse.Email      = user.Email;
            userResponse.Token      = GetToken(user, validezToken);
            userResponse.UserName   = user.UserName;
            userResponse.ExpireDate = DateTime.Now.AddHours(validezToken);
            userResponse.IsAdmin    = (user.Rol.Name == "Admin" ? true : false);

            return(userResponse);
        }
Esempio n. 4
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        //string MenuId= Request.QueryString["MenuId"].ToString();
        string MenuId   = LoginCheck.getadminid();
        string username = this.txtAdminName.Value.Trim();
        string userpwd  = Encryp.DESEncrypt(this.TextBox2.Text.Trim());

        string  email   = this.TextBox4.Text.Trim();
        string  tell    = this.TextBox5.Text.Trim();
        string  dw_name = this.TextBox6.Text.Trim();
        string  sqls    = "select * from tb_User where UserName='******'";
        DataSet ds      = HXD.DBUtility.SQLHelper.ExecuteDataset(sqls);

        if (ds.Tables[0].Rows.Count == 0)
        {
            string sql = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + username + "','" + userpwd + "',6,'" + MenuId + "',0)";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
            System.Threading.Thread.Sleep(1000);
            string sql2 = "select id from tb_User where UserName='******' ";
            string icd  = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();
            string sql3 = "insert into tb_U_User (Id,Tel,msn,name,sc_id)values('" + icd + "','" + tell + "','" + email + "','" + dw_name + "','" + MenuId + "')";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql3);
            Response.Redirect("user/");
        }
        else
        {
            StringDeal.Alter("用户名已存在");
        }
    }
Esempio n. 5
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string MenuId   = LoginCheck.getadminid();
        string username = this.TextBox1.Text.Trim();
        string userpwd  = Encryp.DESEncrypt(this.TextBox2.Text.Trim());

        string tell   = this.TextBox4.Text.Trim();
        string xuehao = this.TextBox5.Text.Trim();
        string xname  = this.TextBox6.Text.Trim();

        string  sqls = "select * from tb_User where UserName='******'";
        DataSet ds   = HXD.DBUtility.SQLHelper.ExecuteDataset(sqls);

        if (ds.Tables[0].Rows.Count == 0)
        {
            string sql = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + username + "','" + userpwd + "',1,'" + MenuId + "',0)";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
            Session["AdminManage"] = username;

            System.Threading.Thread.Sleep(1000);
            string sql2 = "select id from tb_User where UserName='******' and datediff(mi,RegTime,getdate())<=1";
            string icd  = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();
            Session["userid"] = icd;
            string sql3 = "insert into tb_U_User (Id,Tel,msn,name)values('" + icd + "','" + tell + "','" + xuehao + "','" + xname + "')";
            HXD.DBUtility.SQLHelper.ExecuteScalar(sql3);
            Response.Redirect("user/twolist.aspx");
        }
        else
        {
            Response.Write("用户名已存在");
        }
    }
Esempio n. 6
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string psw = Encryp.DESEncrypt("123456");
        int    id  = int.Parse(Request.QueryString["id"].ToString());
        string sql = "update tb_user set UserPwd='" + psw + "' where Id=" + id;

        HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
        StringDeal.Alter("密码初始化成功 - 默认密码:123456");
    }
Esempio n. 7
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        string userid  = Session["userid"].ToString();
        string xx_name = this.TextBox1.Text;
        string xx_note = Encryp.DESEncrypt(this.TextBox2.Text.Trim());
        string sql_u   = "update tb_user set userpwd ='" + xx_note + "' where id=" + userid;

        HXD.DBUtility.SQLHelper.ExecuteScalar(sql_u);
        StringDeal.Alter("密码更新成功!");
    }
Esempio n. 8
0
        public async Task <IActionResult> RetPwd(string oldPassword, string newPassword)
        {
            var userIdStr = User.Claims.SingleOrDefault(s => s.Type == "UserId").Value;

            int.TryParse(userIdStr, out int userId);

            var result = await _Service.ResetPwd(userId, Encryp.MD5Encrypt(oldPassword), Encryp.MD5Encrypt(newPassword));

            return(Json(new ResponseModel(result, 0, 0)));
        }
Esempio n. 9
0
        public void Create(User newUser)
        {
            if (newUser == null)
            {
                throw new ArgumentNullException(nameof(newUser));
            }

            newUser.Password = Encryp.GetSHA256(newUser.Password);

            _appDbContext.Users.Add(newUser);
        }
Esempio n. 10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        mAdmin mA = new mAdmin();
        bAdmin bA = new bAdmin();

        mA.UserName = Session["AdminManage"].ToString();
        mA.UserPwd  = Encryp.DESEncrypt(Request["OldPwd"]);
        if (!bA.IsOldPwd(mA))
        {
            Response.Write("旧密码输入有误!");
        }
    }
Esempio n. 11
0
        public bool GuardarCajero(cajero cajer)
        {
            bool guardo = false;

            using (siimnEntities bd = new siimnEntities())
            {
                string pwencrypt = Encryp.EncryptStringAES(cajer.clave, "85321495kbM1m9");
                cajer.clave = pwencrypt;
                bd.cajero.Add(cajer);
                bd.SaveChanges();
                guardo = true;
            }
            return(guardo);
        }
Esempio n. 12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     LoginCheck.AdminManage();
     if (IsPostBack)
     {
         mAdmin mA = new mAdmin();
         bAdmin bA = new bAdmin();
         mA.UserName = Session["AdminManage"].ToString();
         mA.UserPwd  = Encryp.DESEncrypt(this.UserPwd.Text);
         if (bA.AdminPwdEdit(mA))
         {
             StringDeal.Alter("修改完成!");
         }
     }
 }
Esempio n. 13
0
 /// <summary>
 /// 读取单条管理员信息
 /// </summary>
 protected void UserReader()
 {
     if (mU.Id > 0)
     {
         IList <mUser> list = bU.UserReader(mU);
         this.UserName.Text = list[0].UserName;
         this.UserName.Attributes.Add("class", "input1");
         this.UserName.Attributes.Add("readonly", "readonly");
         this.UserPwd.Attributes.Add("value", Encryp.DESDecrypt(list[0].UserPwd));
         this.UserPwd1.Attributes.Add("value", Encryp.DESDecrypt(list[0].UserPwd));
     }
     else
     {
         this.UserName.Attributes.Add("class", "input1 required validate-length-range-4-20 validate-ajax-Inc/Validate_UserName.aspx");
     }
 }
Esempio n. 14
0
        public async Task <IActionResult> DoLogin(string account, string password, int type)
        {
            var user = _Service.GetUser(account, Encryp.MD5Encrypt(password));

            if (user == null || user.RoleId != type)
            {
                return(Json(new ResponseModel(false, 0, 0)));
            }

            var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme);

            identity.AddClaim(new Claim(ClaimTypes.Name, account));
            identity.AddClaim(new Claim("UserId", user.Id.ToString()));
            identity.AddClaim(new Claim(ClaimTypes.Role, user.RoleId.ToString()));
            await HttpContext.SignInAsync(new ClaimsPrincipal(identity));

            return(Json(new ResponseModel(true, 0, 0)));
        }
Esempio n. 15
0
 /// <summary>
 /// 保存管理员信息
 /// </summary>
 protected void AdminSave()
 {
     mA.GroupId          = StringDeal.ToInt(this.GroupId.Text);
     mA.UserName         = this.UserName.Text;
     mA.UserPwd          = Encryp.DESEncrypt(this.UserPwd.Text);
     mA.TrueName         = this.TrueName.Text;
     mA.Tel              = this.Tel.Text;
     mA.Email            = this.Email.Text;
     mA.IsModifyPassword = StringDeal.ToBool(this.IsModifyPassword.Text);
     mA.IsMultiLogin     = StringDeal.ToBool(this.IsMultiLogin.Text);
     if (mA.Id == 0)
     {
         bA.AdminInsert(mA);
     }
     else
     {
         bA.AdminUpdate(mA);
     }
     StringDeal.Alter("保存完成!", "Admin_Manage.aspx");
 }
Esempio n. 16
0
        public void Register(User newUser)
        {
            string customerUser = (_appSettings != null ? _appSettings.UserApp : "User");

            if (newUser == null)
            {
                throw new ArgumentNullException(nameof(newUser));
            }

            if (!newUser.RolId.HasValue)
            {
                newUser.RolId = _appDbContext.Roles.FirstOrDefault(r => r.Name == customerUser).Id;
            }

            if (UserExists(newUser))
            {
                throw new Exception("Ya existe un usuario registrado con este correo.");
            }

            newUser.Password = Encryp.GetSHA256(newUser.Password);
            _appDbContext.Users.Add(newUser);
        }
Esempio n. 17
0
 /// <summary>
 /// 读取单条管理员信息
 /// </summary>
 protected void AdminReader()
 {
     if (mA.Id > 0)
     {
         IList <mAdmin> list = bA.AdminReader(mA);
         this.GroupId.SelectedValue = list[0].GroupId.ToString();
         this.UserName.Text         = list[0].UserName;
         this.UserName.Attributes.Add("class", "input1");
         this.UserName.Attributes.Add("readonly", "readonly");
         this.UserPwd.Attributes.Add("value", Encryp.DESDecrypt(list[0].UserPwd));
         this.UserPwd1.Attributes.Add("value", Encryp.DESDecrypt(list[0].UserPwd));
         this.TrueName.Text = list[0].TrueName;
         this.Tel.Text      = list[0].Tel;
         this.Email.Text    = list[0].Email;
         this.IsModifyPassword.SelectedValue = list[0].IsModifyPassword.ToString();
         this.IsMultiLogin.SelectedValue     = list[0].IsMultiLogin.ToString();
     }
     else
     {
         this.UserName.Attributes.Add("class", "input1 required validate-length-range-4-20 validate-ajax-Inc/Validate_UserName.aspx");
     }
 }
Esempio n. 18
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string username = Session["AdminManage"].ToString();
        string MenuId   = Session["userid"].ToString();

        string  jiupwd  = Encryp.DESEncrypt(this.jiupwd.Text);
        string  xinpwd1 = this.xinpwd1.Text;
        string  xinpwd2 = this.xinpwd2.Text;
        string  sql2    = "select * from tb_User where UserPwd='" + jiupwd + "' and id='" + MenuId + "'";
        DataSet ds      = HXD.DBUtility.SQLHelper.ExecuteDataset(sql2);

        if (ds.Tables[0].Rows.Count > 0)
        {
            if (xinpwd1 != "")
            {
                if (xinpwd1 == xinpwd2)
                {
                    string sql = "update tb_User set UserPwd='" + Encryp.DESEncrypt(xinpwd1) + "' where id='" + MenuId + "'";
                    HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
                    StringDeal.Alter("修改成功!", "twolist.aspx");
                }
                else
                {
                    StringDeal.Alter("2次新密码不一致!");
                }
            }
            else
            {
                StringDeal.Alter("新密码不能为空!");
            }
        }
        else
        {
            StringDeal.Alter("原新密码错误!请重新输入");
        }
    }
Esempio n. 19
0
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string xsurl = "";

        // if((Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "")
        if (Request.QueryString["ReturnUrl"] != null)
        {
            xsurl = Request.QueryString["ReturnUrl"].ToString();
            xsurl = xsurl.Replace("[@]", "&");
        }
        else
        {
            xsurl = "user/twolist.aspx";
        }
        string url = "";

        string uname = this.username.Value;

        uname = uname.Replace("'", "");
        uname = HXD.Common.StringDeal.RemoveUnsafeHtml(uname);

        string  userpsw = Encryp.DESEncrypt(this.pwd.Value);
        string  classid = LoginCheck.getadminid();
        string  sql     = "select * from tb_User where UserName='******' and UserPwd='" + userpsw + "' and classid='" + classid + "'";
        DataSet ds      = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);

        if (ds.Tables[0].Rows.Count > 0)
        {
            bool stra = bool.Parse(ds.Tables[0].Rows[0]["islock"].ToString());

            if (stra == true)
            {
                Session["AdminManage"] = ds.Tables[0].Rows[0]["UserName"].ToString();
                Session["userid"]      = ds.Tables[0].Rows[0]["id"].ToString();
                int groupid = int.Parse(ds.Tables[0].Rows[0]["GroupId"].ToString());

                switch (groupid)
                {
                case 7:    //局长
                    url = "Edu/ulist.aspx";
                    break;

                case 6:    //校长
                    url = "edumaste/olist.aspx";
                    break;

                case 5:    //老师
                    url = "user/tlist.aspx";
                    break;

                case 1:    //学生
                    url = xsurl;
                    break;

                default:
                    break;
                }
                Response.Redirect(url);
            }
            else
            {
                Response.Redirect("user/");
            }
        }
        else
        {
            Response.Write("用户名或密码错误");
        }
    }
Esempio n. 20
0
        public IActionResult Register(string username, string password, string address, string phone)
        {
            var result = _Service.Register(username.Trim(), Encryp.MD5Encrypt(password), address, phone);

            return(Json(new ResponseModel(result, 0, 0)));
        }
Esempio n. 21
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (IsPostBack)
     {
         mAdmin m = new mAdmin();
         m.UserName    = this.tUserName.Text;
         m.UserPwd     = Encryp.DESEncrypt(this.tUserPwd.Text);
         m.LastLoginIp = Request.UserHostAddress.ToString();
         string Code = this.tCode.Text;
         if (hidden1.Value == "1")
         {
             Code = Session["SGQ_WebValidate"].ToString().ToLower();
         }
         if (Session["SGQ_WebValidate"] == null)
         {
             Msg = "验证码过期,请重试!";
         }
         else if (Session["SGQ_WebValidate"].ToString().ToLower() != Code.ToLower())
         {
             Msg = "验证码输入错误,请重试!";
         }
         else
         {
             bAdmin         b     = new bAdmin();
             IList <mAdmin> list  = b.AdminLogin(m);
             string         state = list[0].Temp;
             if (state == "0")
             {
                 Msg = "密码输入有误!";
             }
             else if (state == "1")
             {
                 Msg = "密码输入有误!";
             }
             else if (state == "2")
             {
                 Msg = "帐号被锁定!";
             }
             else
             {
                 mOnlineAdmin mOA = new mOnlineAdmin();
                 bOnlineAdmin bOA = new bOnlineAdmin();
                 mOA.UserName  = m.UserName;
                 mOA.SessionId = Session.SessionID;
                 if (Caches.GetCache("Admin_" + m.UserName) == null || b.GetAdminMultiLogin(m) || bOA.GetUpdateTimeSpan(mOA) > 10)
                 {
                     Caches.SetCache("Admin_" + m.UserName, "manage");
                     Session["AdminManage"] = m.UserName;
                     bOA.OnlineAdminInsert(mOA);
                     Response.Redirect("Default.aspx", true);
                 }
                 else
                 {
                     StringDeal.Alter("此管理帐号处于登陆状态,不允许多人同时登陆!");
                 }
             }
         }
     }
     else
     {
         this.tUserName.Text = "admin";
         this.tUserPwd.Attributes.Add("value", "admin");
         if (Systemlogin("IsManageCode").ToString().Trim() == "True")
         {
             yinc          = "";
             hidden1.Value = "0";
         }
         else
         {
             hidden1.Value = "1";
             yinc          = " style=\"display:none;\"";
         }
     }
 }
Esempio n. 22
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        //try
        //{
        if (fuload.FileName == "")
        {
            //lbmsg.Text = "请选择文件";
            //return null;

            StringDeal.Alter("请选择文件", "file.aspx");
        }
        else
        {
            DataTable dt = xsldata();

            //dataGridView2.DataSource = ds.Tables[0];
            int errorcount  = 0; //记录错误信息条数
            int insertcount = 0; //记录插入成功条数

            int updatecount = 0; //记录更新信息条数

            //string strcon = "server=localhost;database=database1;uid=sa;pwd=sa";
            //SqlConnection conn = new SqlConnection(strcon);//链接数据库
            //conn.Open();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //dt.Rows[i]["Name"].ToString(); "Name"即为Excel中Name列的表头
                string excl_xuehao      = dt.Rows[i][0].ToString();  //学号
                string excl_name        = dt.Rows[i][1].ToString();  //姓名
                string excl_sex         = dt.Rows[i][2].ToString();  //性别
                string excl_Birthday    = dt.Rows[i][3].ToString();  //生日
                string excl_nationality = dt.Rows[i][4].ToString();  //民族
                string excl_address     = dt.Rows[i][5].ToString();  //家庭住址
                string excl_ksname      = dt.Rows[i][6].ToString();  //科室名称
                string excl_nianji      = dt.Rows[i][7].ToString();  //年级
                string excl_banji       = dt.Rows[i][8].ToString();  //班级
                string excl_tel         = dt.Rows[i][9].ToString();  //电话号码
                string excl_tel2        = dt.Rows[i][10].ToString(); //其他联系方式
                string excl_jieji       = dt.Rows[i][11].ToString(); //届级
                string UserPwd          = Encryp.DESEncrypt("123456");

                //string userid = Session["userid"].ToString();
                //string sqlcl = "select classid from tb_user where id=" + userid;
                //string MenuId = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlcl).ToString();
                string MenuId = LoginCheck.getadminid();//学校ID

                if (excl_xuehao != "" && excl_name != "" && excl_nianji != "" && excl_banji != "")
                {
                    string sql   = "select count(id) from tb_user where username='******'";
                    int    count = Convert.ToInt32(HXD.DBUtility.SQLHelper.ExecuteScalar(sql));
                    if (count > 0)
                    {
                        updatecount++;
                    }
                    else
                    {
                        string sqlin1 = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + excl_xuehao + "','" + UserPwd + "',1,'" + MenuId + "',1)";
                        HXD.DBUtility.SQLHelper.ExecuteScalar(sqlin1);

                        System.Threading.Thread.Sleep(100);
                        string sqlin2 = "select id from tb_User where UserName='******' and datediff(mi,RegTime,getdate())<=1";
                        string icd    = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlin2).ToString();
                        Session["userid"] = icd;
                        string sqlin3 = "insert into tb_U_User (Id,msn,name,sex,shengri,nationality,Address,ks_name,nianji,banji,tel,Mobile,jieji,sc_id)values('" + icd + "','" + excl_xuehao + "','" + excl_name + "','" + excl_sex + "','" + excl_Birthday + "','" + excl_nationality + "','" + excl_address + "','" + excl_ksname + "','" + excl_nianji + "','" + excl_banji + "','" + excl_tel + "','" + excl_tel2 + "','" + excl_jieji + "','" + MenuId + "')";
                        HXD.DBUtility.SQLHelper.ExecuteScalar(sqlin3);


                        //string sqlinsert = "insert into users(Name,Sex,Age,Address) values('" + Name + "','" + Sex + "'," + Age + ",'" + Address + "')";
                        //HXD.DBUtility.SQLHelper.ExecuteNonQuery(sqlinsert);
                        insertcount++;
                    }
                }
                else
                {
                    errorcount++;
                }
            }
            string msgg = insertcount + "条数据导入成功!" + updatecount + "条数据重复!" + errorcount + "条数据部分信息为空没有导入!";
            StringDeal.Alter(msgg, "font_list2.aspx");
            //catch (Exception ex)
            //{
        }//}
    }
Esempio n. 23
0
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.Entity <User>().HasKey(x => x.Id);
            modelBuilder.Entity <User>().Property(x => x.Name).HasMaxLength(200);
            modelBuilder.Entity <User>().Property(x => x.Password).HasMaxLength(200);
            modelBuilder.Entity <User>().Property(x => x.Phone).HasMaxLength(200);
            modelBuilder.Entity <User>().Property(x => x.Address).HasMaxLength(500);
            modelBuilder.Entity <User>().Property(x => x.Avatar).HasMaxLength(500);
            modelBuilder.Entity <User>().Property(x => x.NickName).HasMaxLength(500);
            modelBuilder.Entity <User>().HasData(
                new User()
            {
                Id         = 1,
                RoleId     = 2,
                Name       = "吴皇震",
                NickName   = "HZW",
                Password   = Encryp.MD5Encrypt("123"),
                Phone      = "13568955684",
                Address    = "慈溪市科院3#443",
                CreateTime = DateTime.Now
            },
                new User()
            {
                Id         = 2,
                RoleId     = 2,
                Name       = "方浩亦",
                Password   = Encryp.MD5Encrypt("123"),
                NickName   = "FHY",
                Phone      = "13668955684",
                Address    = "慈溪市科院3#443",
                CreateTime = DateTime.Now
            },
                new User()
            {
                Id         = 3,
                RoleId     = 2,
                Name       = "张淼",
                NickName   = "SSSSSS",
                Password   = Encryp.MD5Encrypt("123"),
                Phone      = "13668234244",
                Address    = "慈溪市科院3#443",
                CreateTime = DateTime.Now
            },
                new User()
            {
                Id         = 4,
                RoleId     = 1,
                Name       = "Admin",
                NickName   = "HZW",
                Password   = Encryp.MD5Encrypt("123"),
                Phone      = "13568955684",
                Address    = "慈溪市科院3#443",
                CreateTime = DateTime.Now
            });

            modelBuilder.Entity <FoodMenu>().HasKey(x => x.Id);
            modelBuilder.Entity <FoodMenu>().Property(x => x.Name).HasMaxLength(200);
            modelBuilder.Entity <FoodMenu>().Property(x => x.Description).HasMaxLength(500);
            modelBuilder.Entity <FoodMenu>().Property(x => x.ImgUrl).HasMaxLength(500);

            modelBuilder.Entity <Order>().HasKey(x => x.Id);

            modelBuilder.Entity <Order_Food>().HasKey(x => x.Id);

            modelBuilder.Entity <Category>().HasKey(x => x.Id);
            modelBuilder.Entity <Category>().Property(x => x.Name).HasMaxLength(500);

            modelBuilder.Entity <Category>().HasData(
                new Category()
            {
                Id   = 1,
                Name = "荤菜"
            },
                new Category()
            {
                Id   = 2,
                Name = "素菜"
            });

            modelBuilder.Entity <Order_Food>().HasData(
                new Order_Food()
            {
                Id      = 1,
                OrderId = 1,
                FoodId  = 1,
            },
                new Order_Food()
            {
                Id      = 2,
                OrderId = 1,
                FoodId  = 2,
            },
                new Order_Food()
            {
                Id      = 3,
                OrderId = 2,
                FoodId  = 2
            });

            modelBuilder.Entity <FoodMenu>().HasData(
                new FoodMenu()
            {
                Id          = 1,
                Name        = "油焖大虾",
                Description = "好吃的油焖大虾,2斤一份",
                Price       = 128,
                StockCount  = 100,
                ImgUrl      = "/upload/youmendaxie.jpg",
                CreateTime  = DateTime.Now,
                Type        = "荤菜"
            },
                new FoodMenu()
            {
                Id          = 2,
                Name        = "手撕包菜",
                Description = "手撕包菜",
                Price       = 12,
                StockCount  = 100,
                ImgUrl      = "/upload/1.jpg",
                CreateTime  = DateTime.Now,
                Type        = "荤菜"
            },
                new FoodMenu()
            {
                Id          = 3,
                Name        = "水煮肉片",
                Description = "水煮肉片一份",
                Price       = 38,
                StockCount  = 100,
                ImgUrl      = "/upload/shuizutoupian.jpg",
                CreateTime  = DateTime.Now,
                Type        = "荤菜"
            });

            modelBuilder.Entity <Order>().HasData(
                new Order()
            {
                Id         = 1,
                UserId     = 1,
                Price      = 120,
                CreateTime = DateTime.Now,
                Status     = "已付款"
            },
                new Order()
            {
                Id         = 2,
                UserId     = 3,
                Price      = 120,
                CreateTime = DateTime.Now,
                Status     = "已送货"
            },
                new Order()
            {
                Id         = 3,
                UserId     = 3,
                Price      = 120,
                CreateTime = DateTime.Now,
                Status     = "已完成"
            });
        }