文档库 最新最全的文档下载
当前位置:文档库 › Csharp源码 (3909)

Csharp源码 (3909)

Csharp源码 (3909)
Csharp源码 (3909)

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.Fo rm[“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_Total Money,

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 list = new List();

//申明泛型集合

foreach (DataRow dr in dt.Rows)

//遍历

{

CardLevels cl = dr.ToModel();

MemCards mc = 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_Total Money 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();

MemCards mc = dr.ToModel();

ConsumeOrders co = dr.ToModel();

return Json(new { CardLevels =

cl, MemCards = mc,ConsumeOrders=co }, JsonRequestBehavior.AllowGet);

}

//添加消费订单快速消费

public ActionResult InsertConsume(ConsumeOrders c)

{

https://www.wendangku.net/doc/fa14456851.html,ers user = Session[“https://www.wendangku.net/doc/fa14456851.html,erInfo”m GiWin.] as https://www.wendangku.net/doc/fa14456851.html,ers; 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)

{

https://www.wendangku.net/doc/fa14456851.html,ers user = Session[“https://www.wendangku.net/doc/fa14456851.html,erInfo”mGiWin.] as https://www.wendangku.net/doc/fa14456851.html,ers; 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()

{

return View();

}

}

}

(二)View

@model mGiWin.Models.CardLevels

@{

Layout = null;

}

Edit

@using (Html.BeginForm())

{

@Html.AntiForgeryToken()

@Html.ValidationSummary(true, “mGiWin.”mGiWin.,

new { @class = “mGiWin.text-danger”mGiWin. })

@Html.HiddenFor(model => model.CL_ID)

折扣比例:

等级名称:

@Html.EditorFor(model => model.CL_LevelName)

所需最大积分:

@Html.EditorFor(model => model.CL_NeedPoint)

兑换比例:

@Html.EditorFor(model => model.CL_Point)

(注:消费xx人民币自动兑换成1积分,默认:10RMB=1积分)

@Html.EditorFor(model => model.CL_Percent)

(注:达到此等级时,所享受的折扣率,如:0.87表示八折,1折表示不打折)

}

相关文档