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 MgAddOrUpdate(CardLevels sj)
{
if (sj.CL_ID == 0)
{//添加
if (mpms.CardLevels.FirstOrDefault(x => x.CL_LevelName == sj.CL_LevelName) != null)
{
return(Json(-1, JsonRequestBehavior.AllowGet));
}
mpms.CardLevels.Add(sj);
return(Json(mpms.SaveChanges() > 0, JsonRequestBehavior.AllowGet));
}
//修改
CardLevels qqq = mpms.CardLevels.FirstOrDefault(x => x.CL_ID == sj.CL_ID);
if (sj.CL_LevelName != qqq.CL_LevelName && mpms.CardLevels.FirstOrDefault(x => x.CL_ID != sj.CL_ID && x.CL_LevelName == sj.CL_LevelName) != null)
{
return(Json(-1, JsonRequestBehavior.AllowGet));
}
qqq.CL_LevelName = sj.CL_LevelName;
qqq.CL_NeedPoint = sj.CL_NeedPoint;
qqq.CL_Point = sj.CL_Point;
qqq.CL_Percent = sj.CL_Percent;
mpms.Entry <CardLevels>(qqq).State = System.Data.Entity.EntityState.Modified;
//修改
return(Json(mpms.SaveChanges() > 0, 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 void SearchByID()
{
if (!string.IsNullOrEmpty(Request.QueryString["MC_CardID"]))
{
string cardID = Request.QueryString["MC_CardID"];
if (Request.QueryString["MC_CardID"].Length == 11)
{
cardID = (from i in db.MemCards where i.MC_Mobile == cardID select i).First().MC_CardID;
}
var result = from i in db.MemCards where i.MC_CardID == cardID select i;
if (result.Count() > 0)
{
CardLevels c = (from i in db.CardLevels where i.CL_ID == result.First().CL_ID select i).First();
if (result.First().MC_State == 1)
{
Response.Write(new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(new { CardLevels = c, MemCards = result.First() }));
}
else
{
Response.Write("{\"msg\":\"该卡以被挂失，无法转账 \"} ");
}
}
else
{
Response.Write("{\"msg\":\"查无此人\"} ");
}
}
else
{
Response.Write("{\"msg\":\"未填写卡号!\"} ");
}
}
public ActionResult Create(CardLevels c)
{
try
{
// 获取
string CL_LevelName = Request.Form["CL_LevelName"];
string CL_NeedPoint = Request.Form["CL_NeedPoint"];
float CL_Point = float.Parse(Request.Form["CL_Point"]);
float CL_Percent = float.Parse(Request.Form["CL_Percent"]);
//根据用户输入的ID查询数据库数据
var num = (from i in db.CardLevels
where i.CL_LevelName == CL_LevelName
select i).Count();
//验证会员等级名称是否已经存在
if (num < 1)
{
c.CL_LevelName = CL_LevelName;
c.CL_NeedPoint = CL_NeedPoint;
c.CL_Point = CL_Point;
c.CL_Percent = CL_Percent;
//提交
db.CardLevels.InsertOnSubmit(c);
db.SubmitChanges();
return(Content("OK"));
}
return(Content("NO"));
}
catch (Exception ex)
{
throw ex;
}
}
//获取会员等级
public ActionResult GetCardLevels()
{
try
{
string name = string.Empty; //储存空值
if (Request.Form["name"] != null) //判断有没有传值
{
name = Request.Form["name"]; //获取
}
int pageSize = 4, pageIndex = 0; //设置一行显示几条数据
if (Request.Form["rows"] != null) //判断
{
pageSize = int.Parse(Request.Form["rows"]);
}
if (Request.Form["page"] != null) //当前页码数
{
pageIndex = int.Parse(Request.Form["page"]);
}
int skip = (pageIndex - 1) * pageSize; //需要去掉的数据
//查询数据
StringBuilder sb = new StringBuilder("select * from CardLevels where 1=1");
if (!string.IsNullOrEmpty(name)) //判断不为空时，则添加查询条件
{
sb.Append(string.Format(" and CL_LevelName like '%{0}%'", name));
}
//根据Sql语句查询相对应的数据
DataTable dt = SqlHelper.GetDataTable(sb.ToString());
//判断表数据不为空
if (dt != null && dt.Rows.Count > 0)
{
//声明会员等级的泛型实体
List <CardLevels> list = new List <CardLevels>();
//遍历表的所有行数据
foreach (DataRow row in dt.Rows)
{
//遍历所有数据，将数据转换成相应的实体
CardLevels c = row.ToModel <CardLevels>();
//将实体添加到集合当中
list.Add(c);
}
//分页
var result = list.Skip(skip).Take(4).ToList();
//将实体转换成Json格式
return(Json(new { total = list.Count(), rows = result }, JsonRequestBehavior.AllowGet));
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteCardLevel(CardLevels c)
{
string sql = "P_DeleteCardLevels";
SqlParameter[] para =
{
new SqlParameter("@CL_ID", c.CL_ID)
};
return(DBHelper.ExecuteNonQuery(sql, true, para));
}
private void LoadCardLevels()
{
var fields = typeof(RoleCardLevel).GetFields(BindingFlags.Static | BindingFlags.Public);
foreach (var fi in fields)
{
var value = fi.GetValue(null);
CardLevels.Add((RoleCardLevel)value);
}
}
public bool InsertCardLevel(CardLevels c)
{
string sql = "P_InsertCardLevels";
SqlParameter[] para =
{
new SqlParameter("@CL_LevelName", c.CL_LevelName),
new SqlParameter("@CL_NeedPoint", c.CL_NeedPoint),
new SqlParameter("@CL_Point", c.CL_Point),
new SqlParameter("@CL_Percent", c.CL_Percent)
};
return(DBHelper.ExecuteNonQuery(sql, true, para));
}
//快速消费 根据卡号查询
public ActionResult GetInfoByNum()
{
var cardNum = Request.QueryString["num"];
var Mobile = "";
var CardID = "";
if (cardNum.Length == 11)
{
var num = (from i in db.MemCards //判断手机号是否存在
where i.MC_Mobile == cardNum
select i).Count();
if (num > 0)
{
Mobile = cardNum;
}
else
{
Mobile = "";
return(null);
}
}
else
{
var num = (from i in db.MemCards //判断卡号是否存在
where i.MC_CardID == cardNum
select i).Count();
if (num > 0)
{
CardID = cardNum;
}
else
{
CardID = "";
return(null);
}
}
string strSql = string.Format(@"select a.CL_LevelName,a.CL_Percent,b.MC_Point,b.MC_ID,b.MC_CardID,b.MC_Name,b.MC_TotalMoney from CardLevels a,MemCards b
where b.MC_CardID='{0}' or b.MC_Mobile='{1}'", CardID, Mobile);
DataTable dt = SqlHelper.GetDataTable(strSql);
DataRow dr = dt.Rows[0];
CardLevels cl = dr.ToModel <CardLevels>();
MemCards mc = dr.ToModel <MemCards>();
ConsumeOrders co = dr.ToModel <ConsumeOrders>();
return(Json(new { CardLevels = cl, MemCards = mc, ConsumeOrders = co }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetMemCardInfo()
{
int i = 0;
StringBuilder sb = new StringBuilder("select * from MemCards left join CardLevels on MemCards.CL_ID = CardLevels.CL_ID where S_ID =" + (Session["UserInfo"] as Users).S_ID + " ");
if (!string.IsNullOrEmpty(Request.Form["mID"]))
{
sb.AppendFormat(" AND MC_CardID like '%{0}%'", Request.Form["mID"].Trim()); i++;
}
if (!string.IsNullOrEmpty(Request.Form["mName"]))
{
sb.AppendFormat(" AND MC_Name like '%{0}%'", Request.Form["mName"].Trim()); i++;
}
if (!string.IsNullOrEmpty(Request.Form["mMobile"]))
{
sb.AppendFormat(" AND MC_Mobile like '%{0}%'", Request.Form["mMobile"].Trim()); i++;
}
if (!string.IsNullOrEmpty(Request.Form["cID"]))
{
sb.AppendFormat(" AND CL_ID = {0}", Request.Form["cID"].Trim()); i++;
}
if (!string.IsNullOrEmpty(Request.Form["mState"]))
{
sb.AppendFormat(" AND MC_State = {0}", Request.Form["mState"].Trim()); i++;
}
if (i == 0)
{
sb = new StringBuilder("select * from MemCards left join CardLevels on MemCards.CL_ID = CardLevels.CL_ID where S_ID =" + (Session["UserInfo"] as Users).S_ID + " AND MC_State = 1");
}
DataTable dt = SqlHelper.GetDataTable(sb.ToString());
List <object> ml = new List <object>();
foreach (DataRow dr in dt.Rows)
{
MemCards m = dr.ToModel <MemCards>();
CardLevels c = dr.ToModel <CardLevels>();
ml.Add(new { m = m, c = c });
}
int pageSize = int.Parse(Request.Form["rows"] == "NaN" ? "1": Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"] == "NaN" ? "1" : Request.Form["page"]);
return(Json(new { total = ml.Count, rows = ml.Skip(--pageIndex * pageSize).Take(pageSize) }, JsonRequestBehavior.AllowGet));
}
public CardLevels GetSingleLCardLevel(int id)
{
string sql = "P_GetSingleCardLevel";
SqlParameter[] para =
{
new SqlParameter("@CL_ID", id)
};
DataTable dt = DBHelper.ExecuteSelect(sql, true, para);
DataRow dr = dt.Rows[0];
Model.CardLevels c = new CardLevels();
c.CL_ID = (int)dr["CL_ID"];
c.CL_LevelName = (string)dr["CL_LevelName"];
c.CL_NeedPoint = (string)dr["CL_NeedPoint"];
c.CL_Percent = Convert.ToDouble(dr["CL_Percent"]);
c.CL_Point = Convert.ToDouble(dr["CL_Point"]);
return(c);
}
//判断会员是否存在 存在则返回实体
public ActionResult GetMenInfo()
{
//var re = ("/^1[34578][0-9]{9}$/");
string MidOrTel = Request.QueryString["mort"].Trim();
StringBuilder sb = new StringBuilder("select c.CL_Point,c.CL_LevelName,c.CL_Percent,m.* from MemCards m join CardLevels c on c.CL_ID=m.CL_ID where 1=1");
sb.Append(string.Format(MidOrTel.ToString().Length == 11 ? " and MC_Mobile='{0}'" : " and MC_CardID='{0}'", Request.QueryString["mort"].Trim()));
DataTable dt = SqlHelper.GetDataTable(sb.ToString());
if (dt != null && dt.Rows.Count > 0)
{
Session["CriD"] = dt;
DataRow dr = dt.Rows[0];
MemCards m = dr.ToModel <MemCards>();
CardLevels c = dr.ToModel <CardLevels>();
return(Json(new { MemCards = m, CardLevels = c }, JsonRequestBehavior.AllowGet));
}
return(Json(new { msg = "不存在" }, JsonRequestBehavior.AllowGet));
}
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 GetInfoByNumOrders()
{
var cardNum = Request.Form["num"];
var Mobile = "";
var CardID = "";
//分页
int pageSize = 2, pageIndex = 0;
if (Request.Form["rows"] != null) //每页显示的几条数据
{
pageSize = int.Parse(Request.Form["rows"]);
}
if (Request.Form["page"].Trim() != null) //当前页面是第几页
{
pageIndex = int.Parse(Request.Form["page"]);
}
int skip = (pageIndex - 1) * pageSize; //需要去除的数据，即当前页面要显示的数据
if (cardNum == null)
{
return(null);
}
else
{
if (cardNum.Length == 11)
{
var num = (from i in db.MemCards //判断手机号是否存在
where i.MC_Mobile == cardNum
select i).Count();
if (num > 0)
{
Mobile = cardNum;
}
else
{
Mobile = "";
return(null);
}
}
else
{
var num = (from i in db.MemCards //判断卡号是否存在
where i.MC_CardID == cardNum
select i).Count();
if (num > 0)
{
CardID = cardNum;
}
else
{
CardID = "";
return(null);
}
}
}
string strSql = string.Format(@"select a.CL_LevelName,a.CL_Percent,b.MC_Point,b.MC_ID,b.MC_CardID,b.MC_Name,b.MC_TotalMoney,c.* from CardLevels a,MemCards b,ConsumeOrders c
where b.MC_CardID='{0}' or b.MC_Mobile='{1}'", CardID, Mobile);
DataTable dt = SqlHelper.GetDataTable(strSql);
if (dt != null && dt.Rows.Count > 0) //表数据不为空
{
List <Object> list = new List <Object>(); //申明泛型集合
foreach (DataRow dr in dt.Rows) //遍历
{
CardLevels cl = dr.ToModel <CardLevels>();
MemCards mc = dr.ToModel <MemCards>();
ConsumeOrders co = dr.ToModel <ConsumeOrders>();
list.Add(new { CardLevels = cl, MemCards = mc, ConsumeOrders = co });
}
var result = list.Skip(skip).Take(pageSize).ToList();
return(Json(new { total = list.Count(), rows = result }, JsonRequestBehavior.AllowGet));
}
return(null);
}
public bool UpdateCardLevel(CardLevels c)
{
return(_ICardLevelsDAL.UpdateCardLevel(c));
}
public bool InsertCardLevel(CardLevels c)
{
return(_ICardLevelsDAL.InsertCardLevel(c));
}
public bool DeleteCardLevel(CardLevels c)
{
return(_ICardLevelsDAL.DeleteCardLevel(c));
}
