/// <summary>
/// 创建会员信息
/// </summary>
public ActionResult Create()
{
//会员等级
CardLevelsBLL level = new CardLevelsBLL();
var lvs = level.SelectWhere(m => true);
ViewBag.CL_ID = new SelectList(lvs, "CL_ID", "CL_LevelName");
//状态
var state = new CategoryItemsBLL().SelectWhere(m => m.C_Category == "MC_State");
ViewBag.MC_State = new SelectList(state, "CI_ID", "CI_Name");
//性别
List<SelectListItem> genderList = new List<SelectListItem>();
genderList.Add(new SelectListItem { Text = "未知", Value = "2" });
genderList.Add(new SelectListItem { Text = "男", Value = "1" });
genderList.Add(new SelectListItem { Text = "女", Value = "0" });
ViewBag.MC_Sex = genderList;
List<SelectListItem> monthList = new List<SelectListItem>();
monthList.Add(new SelectListItem { Text = "请选择", Value = "" });
for (int i = 1; i <= 12; i++)
{
monthList.Add(new SelectListItem { Text = "" + i + "", Value = "" + i + "" });
}
ViewBag.MC_Birthday_Month = monthList;
ViewBag.MC_CardID = int.Parse(new MemCardsBLL().SelectWhere(m => true).Select(m => m.MC_CardID).Max()) + 1;
return View();
}
public ActionResult Edit(CardLevels level)
{
try
{
CardLevelsBLL db = new CardLevelsBLL();
db.Edit(level, "CL_LevelName", "CL_NeedPoint", "CL_Point", "CL_Percent");
db.SaveChanges();
return Json(new { result = "ok" });
}
catch
{
return Json(new { result = "error" });
}
}
public ActionResult Create(CardLevels level)
{
try
{
CardLevelsBLL db = new CardLevelsBLL();
db.Add(level);
db.SaveChanges();
return Json(new { result = "ok" });
}
catch
{
return Json(new { result = "error" });
}
}
public ActionResult Delete(int id)
{
try
{
CardLevelsBLL db = new CardLevelsBLL();
CardLevels level = db.Find(id);
db.Remove(level);
db.SaveChanges();
return Json(new { result = "ok" });
}
catch
{
return Json(new { result = "error" });
}
}
//
// GET: /Member/
public ActionResult Index()
{
//会员等级
CardLevelsBLL level = new CardLevelsBLL();
var lvs = level.SelectWhere(m => true);
ViewBag.CL_ID = new SelectList(lvs, "CL_ID", "CL_LevelName");
//状态
var state = new CategoryItemsBLL().SelectWhere(m => m.C_Category == "MC_State");
ViewBag.MC_State = new SelectList(state, "CI_ID", "CI_Name");
return View();
}
/// <summary>
/// 修改会员信息
/// </summary>
public ActionResult Edit(int id)
{
MemCards mc = new MemCardsBLL().Find(id);
//会员等级
var lvs = new CardLevelsBLL().SelectWhere(m => true);
ViewBag.CL_ID = new SelectList(lvs, "CL_ID", "CL_LevelName", mc.CL_ID);
//状态
var state = new CategoryItemsBLL().SelectWhere(m => m.C_Category == "MC_State");
ViewBag.MC_State = new SelectList(state, "CI_ID", "CI_Name", mc.MC_State);
//性别
List<SelectListItem> genderList = new List<SelectListItem>();
genderList.Add(new SelectListItem { Text = "未知", Value = "2" });
genderList.Add(new SelectListItem { Text = "男", Value = "1" });
genderList.Add(new SelectListItem { Text = "女", Value = "0" });
ViewBag.MC_Sex = new SelectList(genderList, "Value", "Text", mc.MC_Sex);
List<SelectListItem> monthList = new List<SelectListItem>();
monthList.Add(new SelectListItem { Text = "请选择", Value = "" });
for (int i = 1; i <= 12; i++)
{
monthList.Add(new SelectListItem { Text = "" + i + "", Value = "" + i + "" });
}
ViewBag.MC_Birthday_Month = new SelectList(monthList, "Value", "Text", mc.MC_Birthday_Month);
ViewBag.MC_CardID = mc.MC_CardID;
ViewBag.MC_IsPast = mc.MC_IsPast == true ? "checked='checked'" : "";
ViewBag.MC_IsPointAuto = mc.MC_IsPointAuto == true ? "checked='checked'" : "";
ViewBag.MC_CardID = mc.MC_CardID;
ViewBag.PWD = mc.MC_Password;
return View(mc);
}
public ActionResult Index(int id)
{
int pageIndex = 0, pageSize = 0;
if (!string.IsNullOrEmpty(Request.Form["rows"]))
{
pageSize = Convert.ToInt32(Request.Form["rows"]);
}
if (!string.IsNullOrEmpty(Request.Form["page"]))
{
pageIndex = Convert.ToInt32(Request.Form["page"]);
}
string CL_LevelName = Request.Form["CL_LevelName"];
int totalRow; var pagelist = new CardLevelsBLL().GetLevels(pageIndex, pageSize, CL_LevelName, out totalRow);
return Json(new { total = totalRow, rows = pagelist }, JsonRequestBehavior.AllowGet);
}
