//会员减积分
public void ChangePoint()
{
try
{
var result = from i in db.MemCards where i.MC_CardID == Request.Form["mort"].Trim() select i;
if (Request.Form["mort"].Trim().Length == 11)
{
result = from i in db.MemCards where i.MC_Mobile == Request.Form["mort"] select i;
}
MemCards m = result.First();
m.MC_Point -= int.Parse(Request.Form["changePoint"]); //减积分
//添加记录
ConsumeOrders co = new ConsumeOrders();
Users Udt = Session["UserInfo"] as Users;
string Strde = DateTime.Now.ToString("yyyyMMddHHmmss");
co.S_ID = Udt.S_ID;
co.U_ID = Udt.U_ID;
co.CO_OrderCode = Strde;
co.CO_OrderType = 3;
co.MC_ID = m.MC_ID; //int.Parse(Cdt.Rows[0]["MC_ID"].ToString());
co.MC_CardID = m.MC_CardID; //Cdt.Rows[0]["MC_CardID"].ToString();
co.CO_TotalMoney = 0; // decimal.Parse(Request.Form["nMoney"]);
co.CO_DiscountMoney = 0;
co.CO_GavePoint = int.Parse(Request.Form["changePoint"]);
co.CO_CreateTime = DateTime.Now;
co.CO_Remark = Request.Form["Remark"].Trim();
db.ConsumeOrders.InsertOnSubmit(co);
db.SubmitChanges();
Response.Write("ok");
}
catch (Exception ex)
{
Response.Write("错误消息：" + ex);
}
}
//添加消费订单 快速消费
public ActionResult InsertConsume(ConsumeOrders c)
{
MPMS.Models.Users user = Session["UserInfo"] as MPMS.Models.Users;
var U_ID = user.U_ID;
var S_ID = user.S_ID;
var CO_TotalMoney = Request.Form["CO_TotalMoney"];
var CO_DiscountMoney = Request.Form["CO_DiscountMoney"];
var CO_CreateTime = Request.Form["CO_CreateTime"];
var CO_OrderType = 5;
var MC_ID = Request.Form["MC_ID"];
var MC_CardID = Request.Form["MC_CardID"];
c.CO_TotalMoney = decimal.Parse(CO_TotalMoney);
c.CO_DiscountMoney = decimal.Parse(CO_DiscountMoney);
c.CO_CreateTime = DateTime.Parse(CO_CreateTime);
c.CO_OrderType = byte.Parse(CO_OrderType.ToString());
c.MC_ID = int.Parse(MC_ID);
c.MC_CardID = MC_CardID;
c.U_ID = int.Parse(U_ID.ToString());
c.S_ID = int.Parse(S_ID.ToString());
db.ConsumeOrders.InsertOnSubmit(c);
db.SubmitChanges();
return(Content("OK"));
}
//快速消费
public void Fastmoney()
{
try
{
ConsumeOrders co = new ConsumeOrders();
DataTable Cdt = Session["CriD"] as DataTable;
Users Udt = Session["UserInfo"] as Users;
DateTime de = DateTime.Now;
string Strde = de.ToString("yyyyMMddHHmmss");
co.S_ID = Udt.S_ID;
co.U_ID = Udt.U_ID;
co.CO_OrderCode = Strde;
co.CO_OrderType = 5;
co.MC_ID = int.Parse(Cdt.Rows[0]["MC_ID"].ToString());
co.MC_CardID = Cdt.Rows[0]["MC_CardID"].ToString();
co.CO_TotalMoney = decimal.Parse(Request.Form["nMoney"]);
co.CO_DiscountMoney = decimal.Parse(Request.Form["factMoney"]);
co.CO_GavePoint = int.Parse(Request.Form["autoPoint"]);
co.CO_CreateTime = de;
co.CO_Remark = Request.Form["Remark"];
db.ConsumeOrders.InsertOnSubmit(co);
MemCards m = (from i in db.MemCards where i.MC_CardID == Cdt.Rows[0]["MC_CardID"].ToString() select i).First();
m.MC_Point = int.Parse(Cdt.Rows[0]["MC_Point"].ToString()) + int.Parse(Request.Form["autoPoint"]);
m.MC_TotalMoney = (float.Parse(Cdt.Rows[0]["MC_TotalMoney"].ToString())) + (float.Parse(Request.Form["factMoney"]));
m.MC_TotalCount = (int.Parse(Cdt.Rows[0]["MC_TotalCount"].ToString())) + 1;
db.SubmitChanges();
Response.Write("ok");
}
catch (Exception ex)
{
Response.Write(ex);
}
}
//添加消费订单 兑/减积分
public ActionResult InsertConsumeGavePoint(ConsumeOrders c)
{
MPMS.Models.Users user = Session["UserInfo"] as MPMS.Models.Users;
var U_ID = user.U_ID;
var S_ID = user.S_ID;
var CO_CreateTime = Request.Form["CO_CreateTime"];
var CO_OrderType = 3;
var MC_ID = Request.Form["MC_ID"];
var MC_CardID = Request.Form["MC_CardID"];
var CO_GavePoint = Request.Form["CO_GavePoint"]; //兑减积分
var CO_Remark = Request.Form["CO_Remark"]; //备注
c.CO_CreateTime = DateTime.Parse(CO_CreateTime);
c.CO_OrderType = byte.Parse(CO_OrderType.ToString());
c.MC_ID = int.Parse(MC_ID);
c.MC_CardID = MC_CardID;
c.U_ID = int.Parse(U_ID.ToString());
c.S_ID = int.Parse(S_ID.ToString());
c.CO_GavePoint = int.Parse(CO_GavePoint);
c.CO_Remark = CO_Remark;
db.ConsumeOrders.InsertOnSubmit(c);
db.SubmitChanges();
return(Content("OK"));
}
public void PointToMoney(int id)
{
try
{
int changePoint = int.Parse(Request.Form["ExchangPoint"]);
var m = db.MemCards.Where(me => me.MC_ID == id).First();
m.MC_Point -= changePoint;//改变积分
//添加记录
ConsumeOrders co = new ConsumeOrders();
Users Udt = Session["UserInfo"] as Users;
string Strde = DateTime.Now.ToString("yyyyMMddHHmmss");
co.S_ID = Udt.S_ID;
co.U_ID = Udt.U_ID;
co.CO_OrderCode = Strde;
co.CO_OrderType = 2;
co.MC_ID = m.MC_ID; //int.Parse(Cdt.Rows[0]["MC_ID"].ToString());
co.MC_CardID = m.MC_CardID; //Cdt.Rows[0]["MC_CardID"].ToString();
co.CO_TotalMoney = 0; // decimal.Parse(Request.Form["nMoney"]);
co.CO_DiscountMoney = 0;
co.CO_GavePoint = changePoint;
co.CO_CreateTime = DateTime.Now;
co.CO_Recash = int.Parse(Request.Form["ExchangMoney"]);
db.ConsumeOrders.InsertOnSubmit(co);
db.SubmitChanges();
Response.Write("返现成功！");
}
catch (Exception ex)
{
Response.Write("错误消息:" + ex.Message);
}
}
//快速消费
public ActionResult DoJffx(int MC_ID, string MC_CardID, float CO_Recash, int CO_GavePoint)
{
//修改消费的会员信息
MemCards mc = mpms.MemCards.FirstOrDefault(x => x.MC_ID == MC_ID);
mc.MC_Point -= CO_GavePoint;
mpms.Entry <MemCards>(mc).State = System.Data.Entity.EntityState.Modified;
//在转账记录表插入一条记录
ConsumeOrders co = new ConsumeOrders
{
S_ID = (Session["Users"] as Users).S_ID,
U_ID = (Session["Users"] as Users).U_ID,
CO_OrderCode = DateTime.Now.ToString("yyyyMMddHHmmss"),
CO_OrderType = 2,
MC_ID = MC_ID,
MC_CardID = MC_CardID,
EG_ID = 0,
CO_TotalMoney = 0,
CO_DiscountMoney = 0,
CO_GavePoint = CO_GavePoint,
CO_Recash = CO_Recash,
CO_Remark = "积分返现",
CO_CreateTime = Convert.ToDateTime(Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd HH:mm:ss"))
};
mpms.ConsumeOrders.Add(co);
return(Json(mpms.SaveChanges() > 1, JsonRequestBehavior.AllowGet));
}
//快速消费 根据卡号查询
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 bool PointCash(ConsumeOrders co, MemCards m)
{
string sql = "P_PointCash";
SqlParameter[] para =
{
new SqlParameter("@S_ID", co.S_ID),
new SqlParameter("@U_ID", co.U_ID),
new SqlParameter("@CO_OrderCode", co.CO_OrderCode),
new SqlParameter("@CO_OrderType", co.CO_OrderType),
new SqlParameter("@MC_ID", co.MC_ID),
new SqlParameter("@MC_CardID", co.MC_CardID),
new SqlParameter("@CO_Recash", co.CO_Recash),
new SqlParameter("@CO_GavePoint", co.CO_GavePoint),
new SqlParameter("@CO_CreateTime", co.CO_CreateTime),
new SqlParameter("@MC_Point", m.MC_Point)
};
return(DBHelper.ExecuteNonQuery(sql, true, para));
}
public bool FastConsume(ConsumeOrders co, MemCards m)
{
string sql = "P_FastConsume";
SqlParameter[] para =
{
new SqlParameter("@S_ID", co.S_ID),
new SqlParameter("@U_ID", co.U_ID),
new SqlParameter("@CO_OrderCode", co.CO_OrderCode),
new SqlParameter("@CO_OrderType", co.CO_OrderType),
new SqlParameter("@MC_ID", co.MC_ID),
new SqlParameter("@MC_CardID", co.MC_CardID),
new SqlParameter("@CO_TotalMoney", co.CO_TotalMoney),
new SqlParameter("@CO_DiscountMoney", co.CO_DiscountMoney),
new SqlParameter("@CO_GavePoint", co.CO_GavePoint),
new SqlParameter("@CO_CreateTime", co.CO_CreateTime),
new SqlParameter("@MC_Point", m.MC_Point),
new SqlParameter("@MC_TotalCount", m.MC_TotalCount)
};
return(DBHelper.ExecuteNonQuery(sql, true, para));
}
public JsonResult GetStatisticInfo(int id)
{
StringBuilder sb = new StringBuilder(string.Format("select * from ConsumeOrders, MemCards where ConsumeOrders.MC_ID = MemCards.MC_ID AND ConsumeOrders.S_ID = {0}", (Session["UserInfo"] as Users).S_ID));
if (!string.IsNullOrEmpty(Request.Form["CO_OrderType"]))
{
sb.Append("AND CO_OrderType = " + Request.Form["CO_OrderType"].Trim());
}
else
{
sb.Append(id == -1 ? "" : "AND CO_OrderType = " + id + "");
}
if (!string.IsNullOrEmpty(Request.Form["CO_OrderCode"]))
{
sb.AppendFormat(" AND CO_OrderCode like '%{0}%'", Request.Form["CO_OrderCode"].Trim());
}
if (!string.IsNullOrEmpty(Request.Form["MC_CardID"]))
{
string id1 = Request.Form["MC_CardID"].Trim();
if (id1.ToString().Trim().Length == 11)//手机号
{
id1 = (from i1 in db.MemCards where i1.MC_Mobile == id1.Trim() select i1).First().MC_CardID.ToString().Trim();
}
sb.AppendFormat(" AND MemCards.MC_CardID like '%{0}%'", id1);
}
if (!string.IsNullOrEmpty(Request.Form["cID"]))
{
sb.AppendFormat(" AND CL_ID = {0}", Request.Form["cID"].Trim());
}
if (!string.IsNullOrEmpty(Request.Form["CO_DiscountMoney"]) && !string.IsNullOrEmpty(Request.Form["ysf"]))
{
sb.AppendFormat(" AND CO_DiscountMoney {1} '{0}'", Request.Form["CO_DiscountMoney"].Trim(), Request.Form["ysf"].Trim());
}
else if (!string.IsNullOrEmpty(Request.Form["CO_GavePoint"]) && !string.IsNullOrEmpty(Request.Form["ysf"]))
{
sb.AppendFormat(" AND CO_GavePoint {1} '{0}'", Request.Form["CO_GavePoint"].Trim(), Request.Form["ysf"].Trim());
}
else if (!string.IsNullOrEmpty(Request.Form["CO_Recash"]) && !string.IsNullOrEmpty(Request.Form["ysf"]))
{
sb.AppendFormat(" AND CO_Recash {1} '{0}'", Request.Form["CO_Recash"].Trim(), Request.Form["ysf"].Trim());
}
if (!string.IsNullOrEmpty(Request.Form["BTime"]) && !string.IsNullOrEmpty(Request.Form["ETime"]))
{
sb.AppendFormat(" AND CO_CreateTime >= '{0}' AND CO_CreateTime <= '{1}'", Request.Form["BTime"].Trim(), Request.Form["ETime"].Trim());
}
else if (!string.IsNullOrEmpty(Request.Form["BTime"]))
{
sb.AppendFormat(" AND CO_CreateTime >= '{0}'", Request.Form["BTime"].Trim());
}
else if (!string.IsNullOrEmpty(Request.Form["ETime"]))
{
sb.AppendFormat(" AND CO_CreateTime <= '{0}'", Request.Form["ETime"].Trim());
}
DataTable dt = SqlHelper.GetDataTable(sb.ToString());
List <object> ml = new List <object>();
foreach (DataRow dr in dt.Rows)
{
ConsumeOrders c = dr.ToModel <ConsumeOrders>();
MemCards m = dr.ToModel <MemCards>();
ml.Add(new { m = m, c = c, CI_Name = (from i in db.CategoryItems where i.C_Category == "CO_OrderType" && i.CI_ID == c.CO_OrderType select i).First().CI_Name });
}
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).ToList() }, 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 JianPoint(ConsumeOrders co, MemCards m)
{
return(_IMemCardsDAL.JianPoint(co, m));
}
public bool FastConsume(ConsumeOrders co, MemCards m)
{
return(_IMemCardsDAL.FastConsume(co, m));
}
public bool PointCash(ConsumeOrders co, MemCards m)
{
return(_IConsumeOrdersDAL.PointCash(co, m));
}