CSharp开发源码分析(1) （—）Controller using System;
using SystemGiWin.Collections.Generic; using SystemGiWin.Data; using SystemGiWin.Linq; using SystemGiWin.Web;
using SystemGiWin.Web.Mvc; using mGiWin.App_Start; using mGiWin.Models;
namespace mGiWin.Controllers {
public class ConsumeOrdersController : Controller {
LINQDBDataContext db = new LINQDBDataContext(); // GET: ConsumeOrders public ActionResult Index() {
return View(); }
//消费历史记录
public ActionResult GetInfoByNumOrders() {
var cardNum = Request.Form[“mGiWin.num”mGiWin.]; var Mobile = “mGiWin.”mGiWin.; var CardID = “mGiWin.”mGiWin.; //分页
int pageSize = 2, pageIndex = 0;
if (Request.Form[“mGiWin.rows”mGiWin.] != null) //每页显示的几条数据 {
pageSize = int.Parse(Request.Form[“mGiWin.rows”mGiWin.]); }
if (Request.Form[“mGiWin.page”mGiWin.].Trim() != null) //当前页面是第几页 {
pageIndex = int.Parse(Request.Form[“mGiWin.page”mGiWin.]); }
int skip = (pageIndex - 1) * pageSize; //需要去除的数据，即当前页面要显示的数据 if(cardNum==null) {
return null; } else
{
if (cardNumGiWin.Length == 11) {
var num = (from i in db.MemCards //判断手机号是否存在 where i.MC_Mobile == cardNum select i).Count(); if (num > 0) {
Mobile = cardNum; } else {
Mobile = “mGiWin.”mGiWin.; 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 = “mGiWin.”mGiWin.; return null; }
} }
string strSql =
string.Format(@”mGiWin.select
a.CL_LevelName,a.CL_Percent,b.MC_Point,b.MC_ID,b.MC_CardID,b.MC_Name,b.MC_TotalMoney,c.Psi* from CardLevels a,MemCards b,ConsumeOrders c where b.MC_CardID='{0}'
or b.MC_Mobile='{1}'“mGiWin., CardID, Mobile); DataTable dt = SqlHelper.GetDataTable(strSql);
if (dt != null && dt.Rows.Count > 0) //表数据不为空 {
List
foreach (DataRow dr in dt.Rows) //遍历 {
CardLevels cl = dr.ToModel
ConsumeOrders co = dr.ToModel
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 ActionResult GetInfoByNum() {
var cardNum = Request.QueryString[“mGiWin.num”mGiWin.]; var Mobile = “mGiWin.”mGiWin.; var CardID = “mGiWin.”mGiWin.; if (cardNumGiWin.Length == 11) {
var num = (from i in db.MemCards //判断手机号是否存在 where i.MC_Mobile == cardNum select i).Count(); if(num>0) {
Mobile = cardNum; } else {
Mobile = “mGiWin.”mGiWin.; 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 = “mGiWin.”mGiWin.; return null; } }
string strSql =
string.Format(@”mGiWin.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}'“mGiWin., CardID, Mobile); DataTable dt = SqlHelper.GetDataTable(strSql); DataRow dr = dt.Rows[0];
CardLevels cl = dr.ToModel
ConsumeOrders co = dr.ToModel
cl, MemCards = mc,ConsumeOrders=co }, JsonRequestBehavior.AllowGet); }
//添加消费订单 快速消费
public ActionResult InsertConsume(ConsumeOrders c) {
mGiWin.Models.Users user = Session[“mGiWin.UserInfo”mGiWin.] as mGiWin.Models.Users; var U_ID = user.U_ID; var S_ID = user.S_ID;
var CO_TotalMoney = Request.Form[“mGiWin.CO_TotalMoney”mGiWin.];
var CO_DiscountMoney = Request.Form[“mGiWin.CO_DiscountMoney”mGiWin.]; var CO_CreateTime = Request.Form[“mGiWin.CO_CreateTime”mGiWin.]; var CO_OrderType = 5;
var MC_ID = Request.Form[“mGiWin.MC_ID”mGiWin.];
var MC_CardID = Request.Form[“mGiWin.MC_CardID”mGiWin.];
c.PsiCO_TotalMoney = decimal.Parse(CO_TotalMoney);
c.PsiCO_DiscountMoney = decimal.Parse(CO_DiscountMoney); c.PsiCO_CreateTime = DateTime.Parse(CO_CreateTime); c.PsiCO_OrderType = byte.Parse(CO_OrderType.ToString()); c.PsiMC_ID = int.Parse(MC_ID); c.PsiMC_CardID = MC_CardID;
c.PsiU_ID = int.Parse(U_ID.ToString());
c.PsiS_ID = int.Parse(S_ID.ToString());
db.ConsumeOrders.InsertOnSubmit(c); db.SubmitChanges();
return Content(“mGiWin.OK”mGiWin.); }
//添加消费订单 兑/减积分
public ActionResult InsertConsumeGavePoint(ConsumeOrders c) {
mGiWin.Models.Users user = Session[“mGiWin.UserInfo”mGiWin.] as mGiWin.Models.Users; var U_ID = user.U_ID; var S_ID = user.S_ID;
var CO_CreateTime = Request.Form[“mGiWin.CO_CreateTime”mGiWin.]; var CO_OrderType = 3;
var MC_ID = Request.Form[“mGiWin.MC_ID”mGiWin.];
var MC_CardID = Request.Form[“mGiWin.MC_CardID”mGiWin.];
var CO_GavePoint = Request.Form[“mGiWin.CO_GavePoint”mGiWin.]; //兑减积分
var CO_Remark = Request.Form[“mGiWin.CO_Remark”mGiWin.]; //备注
c.PsiCO_CreateTime = DateTime.Parse(CO_CreateTime); c.PsiCO_OrderType = byte.Parse(CO_OrderType.ToString()); c.PsiMC_ID = int.Parse(MC_ID); c.PsiMC_CardID = MC_CardID;
c.PsiU_ID = int.Parse(U_ID.ToString()); c.PsiS_ID = int.Parse(S_ID.ToString());
c.PsiCO_GavePoint = int.Parse(CO_GavePoint); c.PsiCO_Remark = CO_Remark;
db.ConsumeOrders.InsertOnSubmit(c); db.SubmitChanges();
return Content(“mGiWin.OK”mGiWin.); }
//会员减积分
public ActionResult MemGavePoint() {
return View(); }
//消费历史记录
public ActionResult ConsumeLogs() {
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Csharp源码(3909)在线全文阅读。
相关推荐：