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));
}
}
