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
//申明泛型集合
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;
}
$(function () {
//修改
$(“mGiWin.#btnUpdate”mGiWin.).click(function () {
//获取
var CL_ID = $(“mGiWin.#CL_ID”mGiWin.).val();
var CL_LevelName = $(“mGiWin.#CL_LevelName”mGiWin.).val();
var CL_NeedPoint = $(“mGiWin.#CL_NeedPoint”mGiWin.).val();
var CL_Point = $(“mGiWin.#CL_Point”mGiWin.).val();
var CL_Percent = $(“mGiWin.#CL_Percent”mGiWin.).val();
//验证
if (CL_LevelName == “mGiWin.”mGiWin.) {
alert(“mGiWin.会员等级名称不能为空”mGiWin.);
return;
}
if (CL_NeedPoint == “mGiWin.”mGiWin.) {
alert(“mGiWin.所需最大积分不能为空”mGiWin.);
return;
}
if (CL_Point == “mGiWin.”mGiWin.) {
alert(“mGiWin.兑换比例不能为空”mGiWin.);
return;
}
var re =/^[1-9]\d*$/;
if (!re.test(CL_Point)) {
alert(“mGiWin.兑换比例必须为大于0的正整数!”mGiWin.); return;
}
if (CL_Percent == “mGiWin.”mGiWin.) {
alert(“mGiWin.折扣比例不能为空”mGiWin.);
return;
}
var p = /^0\.\d{0,2}$/;
if (!p.test(CL_Percent)) {
alert(“mGiWin.折扣比例数据错误”mGiWin.);
return;
}
//修改
$.ajax({
url: “mGiWin./CardLevels/Edit”mGiWin.,
data:
{
CL_ID: CL_ID,
CL_LevelName: CL_LevelName,
CL_NeedPoint: CL_NeedPoint,
CL_Point: CL_Point,
CL_Percent: CL_Percent
},
type: “mGiWin.post”mGiWin.,
dataType: “mGiWin.html”mGiWin.,
success: function (d) {
if (d == “mGiWin.OK”mGiWin.) {
alert(“mGiWin.修改成功”mGiWin.);
window.parent.$('#dlg').dialog('close'); //关闭模态窗体
window.parent.$('#CardLevels').datagrid('reload'); //刷新父页面}
else
{
alert(“mGiWin.会员等级已存在,请重新输入!”mGiWin.);
}
},
error: function (err) {
alert(“mGiWin.错误,请重试!!”mGiWin.);
}
});
});
@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折表示不打折) | |
}