public ActionResult AddShop(string ShopName, string Category, string TellName, string Phone, string Address, string Remark) { using (UPMSEntities db = new UPMSEntities()) { Shops shop = new Shops(); shop.S_Category = Convert.ToInt32(Category); shop.S_Name = ShopName; shop.S_ContactName = TellName; shop.S_ContactTel = Phone; shop.S_Address = Address; shop.S_Remark = Remark; shop.S_CreateTime = DateTime.Now; db.Shops.Add(shop); int len = db.SaveChanges(); paramModel <int> result = new paramModel <int>(); if (len > 0) { result.status = 1; result.msg = "添加成功!"; } else { result.status = 0; result.msg = "添加失败!"; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Login(Users user) { string ErrorMsg = string.Empty; if (ModelState.IsValid) { using (UPMSEntities db = new UPMSEntities()) { var UserTbl = from u in db.Users where u.U_LoginName == user.U_LoginName && u.U_Password == user.U_Password select u; Users userResult = UserTbl.FirstOrDefault(); if (userResult.S_ID.HasValue) { ErrorMsg = string.Empty; Session["user"] = userResult; return(RedirectToAction("index", "Admin")); } else { ErrorMsg = "账号或密码错误!"; } } } else { ErrorMsg = "请输入账号和密码!"; } return(RedirectToAction("index", new { msg = ErrorMsg })); }
public ActionResult AddAdmin(int SID, string LoginName) { using (UPMSEntities db = new UPMSEntities()) { Users user = new Users(); { user.S_ID = SID; user.U_LoginName = LoginName; user.U_Password = "******"; } db.Users.Add(user); int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "分配成功!"; } else { param.status = 0; param.msg = "分配失败!"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetShopList(string ShopName, string ContactName, string Address, int page, int rows) { using (UPMSEntities db = new UPMSEntities()) { var linqResult = from S in db.Shops join C in db.CategoryItems on S.S_Category equals C.CI_ID where C.C_Category == "S_Category" && (string.IsNullOrEmpty(ShopName) || S.S_Name.Contains(ShopName)) && (string.IsNullOrEmpty(ContactName) || S.S_Name.Contains(ContactName)) && (string.IsNullOrEmpty(Address) || S.S_Name.Contains(Address)) select new { S_ID = S.S_ID, S_Name = S.S_Name, CI_Name = C.CI_Name, CI_ID = C.CI_ID, S_ContactName = S.S_ContactName, S_ContactTel = S.S_ContactTel, S_Address = S.S_Address, S_Remark = S.S_Remark, S_IsHasSetAdmin = S.S_IsHasSetAdmin == true ? "已分配" : "未分配", S_CreateTime = S.S_CreateTime }; var data = new object { }; if (linqResult.Count() > 0) { data = new { total = linqResult.Count(), rows = linqResult.OrderByDescending(x => x.S_ID).Skip((page - 1) * rows).Take(rows).ToList() }; } return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddUser(string LoginName, string Password, string RealName, string Sex, string Phone, string RoleName, bool CanDelete) { using (UPMSEntities db = new UPMSEntities()) { var cateLinq = from C in db.CategoryItems where C.CI_Name == RoleName select new { RoleID = C.CI_ID }; Users user = new Users(); { user.U_LoginName = LoginName; user.U_Password = Password; user.U_RealName = RealName; user.U_Sex = Sex; user.U_Telephone = Phone; user.U_Role = cateLinq.FirstOrDefault().RoleID; user.U_CanDelete = CanDelete; } db.Users.Add(user); int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "添加成功"; } else { param.status = 0; param.msg = "添加失败"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateShop(string ShopName, string Category, string TellName, string Phone, string Address, string Remark, string ID) { using (UPMSEntities db = new UPMSEntities()) { Shops shop = new Shops(); { shop.S_ID = Convert.ToInt32(ID); shop.S_Name = ShopName; shop.S_Category = Convert.ToInt32(Category); shop.S_ContactName = TellName; shop.S_ContactTel = Phone; shop.S_Address = Address; shop.S_Remark = Remark; } db.Entry <Shops>(shop).State = EntityState.Modified; int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "修改成功!"; } else { param.status = 0; param.msg = "修改失败!"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult NonDeleteUser(int ID) { using (UPMSEntities db = new UPMSEntities()) { Users user = new Users(); { user.U_ID = ID; user.U_isDelete = true; } db.Entry <Users>(user).State = EntityState.Modified; db.Entry <Users>(user).Property(u => u.U_CanDelete).IsModified = false; db.Entry <Users>(user).Property(u => u.S_ID).IsModified = false; db.Entry <Users>(user).Property(u => u.U_LoginName).IsModified = false; db.Entry <Users>(user).Property(u => u.U_Password).IsModified = false; db.Entry <Users>(user).Property(u => u.U_Role).IsModified = false; db.Entry <Users>(user).Property(u => u.U_Sex).IsModified = false; db.Entry <Users>(user).Property(u => u.U_Telephone).IsModified = false; int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "删除成功"; } else { param.status = 0; param.msg = "删除失败"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetUserList(string LoginName, string RealName, string Phone, int page, int rows) { using (UPMSEntities db = new UPMSEntities()) { var linqResult = from U in db.Users join C in db.CategoryItems on U.U_Role equals C.CI_ID where C.C_Category == "U_Role" && (string.IsNullOrEmpty(LoginName) || U.U_LoginName.Contains(LoginName)) && (string.IsNullOrEmpty(RealName) || U.U_RealName.Contains(RealName)) && (string.IsNullOrEmpty(Phone) || U.U_Telephone.Contains(Phone)) && U.U_Role != 1 && U.U_isDelete == false select new { ID = U.U_ID, LoginName = U.U_LoginName, RealName = U.U_RealName, Sex = U.U_Sex, Phone = U.U_Telephone, RoleName = C.CI_Name, CanDelete = U.U_CanDelete }; var data = new object { }; if (linqResult.Count() > 0) { data = data = new { total = linqResult.Count(), rows = linqResult.OrderByDescending(x => x.ID).Skip((page - 1) * rows).Take(rows).ToList() }; } return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateLevel(string ID, string LevelName, string NeedPoint, string Point, string Percent) { using (UPMSEntities db = new UPMSEntities()) { CardLevels cd = new CardLevels(); { cd.CL_ID = Convert.ToInt32(ID); cd.CL_LevelName = LevelName; cd.CL_NeedPoint = NeedPoint; cd.CL_Point = Convert.ToDouble(Point); cd.CL_Percent = Convert.ToDouble(Percent); } db.Entry <CardLevels>(cd).State = EntityState.Modified; int len = db.SaveChanges(); paramModel <int> result = new paramModel <int>(); if (len > 0) { result.status = 1; result.msg = "修改成功!"; } else { result.status = 0; result.msg = "修改失败!"; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddLevel(string ID, string LevelName, string NeedPoint, string Point, string Percent) { using (UPMSEntities db = new UPMSEntities()) { CardLevels cd = new CardLevels(); { cd.CL_LevelName = LevelName; cd.CL_NeedPoint = NeedPoint; cd.CL_Point = Convert.ToDouble(Point); cd.CL_Percent = Convert.ToDouble(Percent); db.CardLevels.Add(cd); } int len = db.SaveChanges(); paramModel <int> result = new paramModel <int>(); if (len > 0) { result.status = 1; result.msg = "添加成功!"; } else { result.status = 0; result.msg = "添加失败!"; } return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { using (UPMSEntities db = new UPMSEntities()) { var linqResult = from C in db.CategoryItems where C.C_Category == "U_Role" && C.CI_ID != 1 select new { RoleName = C.CI_Name }; List <string> RoleList = new List <string>(); foreach (var row in linqResult) { RoleList.Add(row.RoleName); } ViewBag.RoleList = RoleList; } return(View()); }
public ActionResult GetLevelList(string LevelName, int page, int rows) { using (UPMSEntities db = new UPMSEntities()) { var linqResult = from C in db.CardLevels where string.IsNullOrEmpty(LevelName) || C.CL_LevelName.Contains(LevelName) select new { ID = C.CL_ID, LevelName = C.CL_LevelName, NeedPoint = C.CL_NeedPoint, Point = C.CL_Point, Percent = C.CL_Percent }; var data = new object { }; if (linqResult.Count() > 0) { data = new { total = linqResult.Count(), rows = linqResult.OrderByDescending(c => c.ID).Skip((page - 1) * rows).Take(rows).ToList() }; } return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteShop(string ID) { using (UPMSEntities db = new UPMSEntities()) { Shops shop = new Shops(); { shop.S_ID = Convert.ToInt32(ID); } db.Shops.Attach(shop); db.Shops.Remove(shop); int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "删除成功!"; } else { param.status = 0; param.msg = "删除失败!"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { using (UPMSEntities db = new UPMSEntities()) { var LinqResult = from T in db.CategoryItems where T.C_Category == "S_Category" select T; if (LinqResult.Count() > 0) { List <CategoryItems> listc = new List <CategoryItems>(); foreach (var item in LinqResult) { CategoryItems c = new CategoryItems(); c.CI_ID = item.CI_ID; c.CI_Name = item.CI_Name; listc.Add(c); } ViewBag.type = listc; } } return(View()); }
public ActionResult DeleteLevel(string ID) { using (UPMSEntities db = new UPMSEntities()) { CardLevels cd = new CardLevels(); { cd.CL_ID = Convert.ToInt32(ID); } db.CardLevels.Attach(cd); db.CardLevels.Remove(cd); int result = db.SaveChanges(); paramModel <object> param = new paramModel <object>(); if (result > 0) { param.status = 1; param.msg = "删除成功!"; } else { param.status = 0; param.msg = "删除失败!"; } return(Json(param, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetGiftList(int page, int rows) { using (UPMSEntities db = new UPMSEntities()) { var linqResult = from G in db.ExchangGifts select new { ID = G.EG_ID, GiftCode = G.EG_GiftCode, GiftName = G.EG_GiftName, Point = G.EG_Point, Number = G.EG_Number, ExchangNum = G.EG_ExchangNum, Remark = G.EG_Remark }; var data = new object { }; if (linqResult.Count() > 0) { data = data = new { total = linqResult.Count(), rows = linqResult.OrderByDescending(x => x.ID).Skip((page - 1) * rows).Take(rows).ToList() }; } return(Json(data, JsonRequestBehavior.AllowGet)); } }