public IList <PrizeResultViewInfo> GetPrizeLogLists(int gameId, int pageIndex, int pageSize)
{
List <PrizeResultViewInfo> list = new List <PrizeResultViewInfo>();
string selectFields = "LogId, PlayTime, UserId, UserName,Prize, PrizeGrade, PrizeType, GivePoint, GiveCouponId, GiveShopBookId,PrizeId ";
string filter = string.Format(" GameId={0} and PrizeId!=0 ", gameId);
DataTable data = DataHelper.PagingByTopnotin(pageIndex, pageSize, "LogId", SortAction.Desc, false, "vw_Hishop_PrizesRecord", "LogId", filter, selectFields).Data as DataTable;
if (data != null)
{
foreach (DataRow row in data.Rows)
{
PrizeResultViewInfo item = new PrizeResultViewInfo {
LogId = int.Parse(row["LogId"].ToString()),
PlayTime = DateTime.Parse(row["PlayTime"].ToString()),
UserId = int.Parse(row["UserId"].ToString()),
UserName = row["UserName"].ToString(),
PrizeType = (PrizeType)int.Parse(row["PrizeType"].ToString()),
PrizeGrade = (PrizeGrade)int.Parse(row["PrizeGrade"].ToString()),
GivePoint = int.Parse(row["GivePoint"].ToString()),
GiveCouponId = row["GiveCouponId"].ToString(),
GiveShopBookId = row["GiveShopBookId"].ToString(),
PrizeName = row["Prize"].ToString()
};
list.Add(item);
}
}
return(list);
}
private void GetUserPrizeLists(HttpContext context)
{
StringBuilder builder = new StringBuilder("{");
string str = context.Request["gameid"];
if (string.IsNullOrEmpty(str))
{
builder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(builder.ToString());
}
else
{
int pageIndex = 1;
int pageSize = 7;
try
{
pageIndex = int.Parse(context.Request["pageIndex"]);
}
catch (Exception)
{
builder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(builder.ToString());
return;
}
try
{
pageSize = int.Parse(context.Request["pageSize"]);
}
catch (Exception)
{
builder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(builder.ToString());
return;
}
IList <PrizeResultViewInfo> list = GameHelper.GetPrizeLogLists(GameHelper.GetModelByGameId(str).GameId, pageIndex, pageSize);
builder.Append("\"lists\":[");
int count = list.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PrizeResultViewInfo item = list[i];
builder.Append("{\"PrizeGrade\":\"" + item.PrizeGrade.ToString() + "\",\"UserName\":\"" + this.GetUserName(item.UserName) + "\",\"PrizeName\":\"" + GameHelper.GetPrizeName(item.PrizeType, GameHelper.GetPrizeFullName(item)) + "\",\"Prize\":\"" + item.PrizeName + "\",\"DateTime\":\"" + item.PlayTime.ToString("yyyy-MM-dd") + "\"}");
if (i != (count - 1))
{
builder.Append(",");
}
}
}
builder.Append("]}");
context.Response.Write(builder);
}
}
public static string GetPrizeFullName(PrizeResultViewInfo item)
{
string couponName;
switch (item.PrizeType)
{
case PrizeType.赠送积分:
{
couponName = string.Format("{0} 积分", item.GivePoint);
break;
}
case PrizeType.赠送优惠券:
{
CouponInfo coupon = CouponHelper.GetCoupon(int.Parse(item.GiveCouponId));
if (coupon == null)
{
couponName = string.Concat("优惠券", item.GiveCouponId, "[已删除]");
break;
}
else
{
couponName = coupon.CouponName;
break;
}
}
case PrizeType.赠送商品:
{
ProductInfo productBaseInfo = ProductHelper.GetProductBaseInfo(int.Parse(item.GiveShopBookId));
if (productBaseInfo == null)
{
couponName = "赠送商品[已删除]";
break;
}
else
{
couponName = productBaseInfo.ProductName;
break;
}
}
default:
{
couponName = "";
break;
}
}
return(couponName);
}
public static string GetPrizeName(PrizeResultViewInfo item)
{
switch (item.PrizeType)
{
case PrizeType.赠送积分:
return(string.Format("{0} 积分", item.GivePoint));
case PrizeType.赠送优惠劵:
return(Globals.SubStr(CouponHelper.GetCoupon(int.Parse(item.GiveCouponId)).CouponName, 12, ".."));
case PrizeType.赠送商品:
return(Globals.SubStr(ProductHelper.GetProductBaseInfo(int.Parse(item.GiveShopBookId)).ProductName, 12, ".."));
}
return("");
}
public static string GetPrizeFullName(PrizeResultViewInfo item)
{
string result;
switch (item.PrizeType)
{
case PrizeType.赠送积分:
result = string.Format("{0} 积分", item.GivePoint);
break;
case PrizeType.赠送优惠券:
{
CouponInfo coupon = CouponHelper.GetCoupon(int.Parse(item.GiveCouponId));
if (coupon != null)
{
result = coupon.CouponName;
}
else
{
result = "优惠券" + item.GiveCouponId + "[已删除]";
}
break;
}
case PrizeType.赠送商品:
{
ProductInfo productBaseInfo = ProductHelper.GetProductBaseInfo(int.Parse(item.GiveShopBookId));
if (productBaseInfo != null)
{
result = productBaseInfo.ProductName;
}
else
{
result = "赠送商品[已删除]";
}
break;
}
default:
result = "";
break;
}
return(result);
}
private void GetPrizeLists(HttpContext context)
{
context.Response.ContentType = "application/json";
StringBuilder builder = new StringBuilder("{");
string str = context.Request["gameid"];
if (string.IsNullOrEmpty(str))
{
builder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(builder.ToString());
}
else
{
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
GameInfo modelByGameId = GameHelper.GetModelByGameId(str);
if (modelByGameId == null)
{
builder.Append("\"status\":\"0\",\"Desciption\":\"游戏不存在!\"}");
context.Response.Write(builder.ToString());
}
else
{
GameData data = new GameData {
status = 1,
Description = modelByGameId.Description,
BeginDate = modelByGameId.BeginTime,
EndDate = modelByGameId.EndTime,
LimitEveryDay = modelByGameId.LimitEveryDay,
MaximumDailyLimit = modelByGameId.MaximumDailyLimit,
MemberCheck = modelByGameId.MemberCheck,
HasPhone = string.IsNullOrEmpty(currentMember.CellPhone) ? 0 : 1
};
IList <GamePrizeInfo> gamePrizeListsByGameId = GameHelper.GetGamePrizeListsByGameId(modelByGameId.GameId);
List <PrizeData> list2 = new List <PrizeData>();
string fullName = "";
GamePrizeInfo info3 = new GamePrizeInfo();
GamePrizeInfo info4 = new GamePrizeInfo();
GamePrizeInfo info5 = new GamePrizeInfo();
GamePrizeInfo info6 = new GamePrizeInfo();
switch (gamePrizeListsByGameId.Count <GamePrizeInfo>())
{
case 1:
{
info3 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.一等奖);
PrizeResultViewInfo item = new PrizeResultViewInfo {
PrizeType = info3.PrizeType,
GivePoint = info3.GivePoint,
GiveCouponId = info3.GiveCouponId,
GiveShopBookId = info3.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(item);
PrizeData data2 = new PrizeData {
prizeId = info3.PrizeId,
prize = info3.Prize,
prizeType = info3.PrizeGrade.ToString(),
prizeCount = info3.PrizeRate,
prizeName = GameHelper.GetPrizeName(info3.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data2);
break;
}
case 2:
{
info3 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.一等奖);
PrizeResultViewInfo info8 = new PrizeResultViewInfo {
PrizeType = info3.PrizeType,
GivePoint = info3.GivePoint,
GiveCouponId = info3.GiveCouponId,
GiveShopBookId = info3.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info8);
PrizeData data3 = new PrizeData {
prizeId = info3.PrizeId,
prize = info3.Prize,
prizeType = info3.PrizeGrade.ToString(),
prizeCount = info3.PrizeRate,
prizeName = GameHelper.GetPrizeName(info3.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data3);
info4 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.二等奖);
PrizeResultViewInfo info9 = new PrizeResultViewInfo {
PrizeType = info4.PrizeType,
GivePoint = info4.GivePoint,
GiveCouponId = info4.GiveCouponId,
GiveShopBookId = info4.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info9);
PrizeData data4 = new PrizeData {
prizeId = info4.PrizeId,
prize = info4.Prize,
prizeType = info4.PrizeGrade.ToString(),
prizeCount = info4.PrizeRate,
prizeName = GameHelper.GetPrizeName(info4.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data4);
break;
}
case 3:
{
info3 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.一等奖);
PrizeResultViewInfo info10 = new PrizeResultViewInfo {
PrizeType = info3.PrizeType,
GivePoint = info3.GivePoint,
GiveCouponId = info3.GiveCouponId,
GiveShopBookId = info3.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info10);
PrizeData data5 = new PrizeData {
prizeId = info3.PrizeId,
prize = info3.Prize,
prizeType = info3.PrizeGrade.ToString(),
prizeCount = info3.PrizeRate,
prizeName = GameHelper.GetPrizeName(info3.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data5);
info4 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.二等奖);
PrizeResultViewInfo info11 = new PrizeResultViewInfo {
PrizeType = info4.PrizeType,
GivePoint = info4.GivePoint,
GiveCouponId = info4.GiveCouponId,
GiveShopBookId = info4.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info11);
PrizeData data6 = new PrizeData {
prizeId = info4.PrizeId,
prize = info4.Prize,
prizeType = info4.PrizeGrade.ToString(),
prizeCount = info4.PrizeRate,
prizeName = GameHelper.GetPrizeName(info4.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data6);
info5 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.等奖);
PrizeResultViewInfo info12 = new PrizeResultViewInfo {
PrizeType = info5.PrizeType,
GivePoint = info5.GivePoint,
GiveCouponId = info5.GiveCouponId,
GiveShopBookId = info5.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info12);
PrizeData data7 = new PrizeData {
prizeId = info5.PrizeId,
prize = info5.Prize,
prizeType = info5.PrizeGrade.ToString(),
prizeCount = info5.PrizeRate,
prizeName = GameHelper.GetPrizeName(info5.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data7);
break;
}
case 4:
{
info3 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.一等奖);
PrizeResultViewInfo info13 = new PrizeResultViewInfo {
PrizeType = info3.PrizeType,
GivePoint = info3.GivePoint,
GiveCouponId = info3.GiveCouponId,
GiveShopBookId = info3.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info13);
PrizeData data8 = new PrizeData {
prizeId = info3.PrizeId,
prize = info3.Prize,
prizeType = info3.PrizeGrade.ToString(),
prizeCount = info3.PrizeRate,
prizeName = GameHelper.GetPrizeName(info3.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data8);
info4 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.二等奖);
PrizeResultViewInfo info14 = new PrizeResultViewInfo {
PrizeType = info4.PrizeType,
GivePoint = info4.GivePoint,
GiveCouponId = info4.GiveCouponId,
GiveShopBookId = info4.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info14);
PrizeData data9 = new PrizeData {
prizeId = info4.PrizeId,
prize = info4.Prize,
prizeType = info4.PrizeGrade.ToString(),
prizeCount = info4.PrizeRate,
prizeName = GameHelper.GetPrizeName(info4.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data9);
info5 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.等奖);
PrizeResultViewInfo info15 = new PrizeResultViewInfo {
PrizeType = info5.PrizeType,
GivePoint = info5.GivePoint,
GiveCouponId = info5.GiveCouponId,
GiveShopBookId = info5.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info15);
PrizeData data10 = new PrizeData {
prizeId = info5.PrizeId,
prize = info5.Prize,
prizeType = info5.PrizeGrade.ToString(),
prizeCount = info5.PrizeRate,
prizeName = GameHelper.GetPrizeName(info5.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data10);
info6 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.四等奖);
PrizeResultViewInfo info16 = new PrizeResultViewInfo {
PrizeType = info6.PrizeType,
GivePoint = info6.GivePoint,
GiveCouponId = info6.GiveCouponId,
GiveShopBookId = info6.GiveShopBookId
};
fullName = GameHelper.GetPrizeFullName(info16);
PrizeData data11 = new PrizeData {
prizeId = info6.PrizeId,
prize = info6.Prize,
prizeType = info6.PrizeGrade.ToString(),
prizeCount = info6.PrizeRate,
prizeName = GameHelper.GetPrizeName(info6.PrizeType, fullName),
PrizeFullName = fullName
};
list2.Add(data11);
break;
}
}
data.prizeLists = list2;
IsoDateTimeConverter converter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
context.Response.Write(JsonConvert.SerializeObject(data, Formatting.Indented, new JsonConverter[] { converter }));
}
}
}
private void GetUserPrizeLists(System.Web.HttpContext context)
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder("{");
string text = context.Request["gameid"];
if (string.IsNullOrEmpty(text))
{
stringBuilder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(stringBuilder.ToString());
return;
}
int pageIndex = 1;
int pageSize = 7;
try
{
pageIndex = int.Parse(context.Request["pageIndex"]);
}
catch (System.Exception)
{
stringBuilder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(stringBuilder.ToString());
return;
}
try
{
pageSize = int.Parse(context.Request["pageSize"]);
}
catch (System.Exception)
{
stringBuilder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(stringBuilder.ToString());
return;
}
System.Collections.Generic.IList <PrizeResultViewInfo> prizeLogLists = GameHelper.GetPrizeLogLists(GameHelper.GetModelByGameId(text).GameId, pageIndex, pageSize);
stringBuilder.Append("\"lists\":[");
int count = prizeLogLists.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PrizeResultViewInfo prizeResultViewInfo = prizeLogLists[i];
stringBuilder.Append(string.Concat(new string[]
{
"{\"PrizeGrade\":\"",
prizeResultViewInfo.PrizeGrade.ToString(),
"\",\"UserName\":\"",
this.GetUserName(prizeResultViewInfo.UserName),
"\",\"PrizeName\":\"",
GameHelper.GetPrizeName(prizeResultViewInfo.PrizeType, GameHelper.GetPrizeFullName(prizeResultViewInfo)),
"\",\"Prize\":\"",
prizeResultViewInfo.PrizeName,
"\",\"DateTime\":\"",
prizeResultViewInfo.PlayTime.ToString("yyyy-MM-dd"),
"\"}"
}));
if (i != count - 1)
{
stringBuilder.Append(",");
}
}
}
stringBuilder.Append("]}");
context.Response.Write(stringBuilder);
}
private void GetPrizeLists(HttpContext context)
{
context.Response.ContentType = "application/json";
StringBuilder builder = new StringBuilder("{");
string str = context.Request["gameid"];
if (string.IsNullOrEmpty(str))
{
builder.Append("\"status\":\"0\",\"Desciption\":\"参数错误!\"}");
context.Response.Write(builder.ToString());
}
else
{
GameInfo modelByGameId = GameHelper.GetModelByGameId(str);
if (modelByGameId == null)
{
builder.Append("\"status\":\"0\",\"Desciption\":\"游戏不存在!\"}");
context.Response.Write(builder.ToString());
}
else
{
GameData data = new GameData {
status = 1,
Description = modelByGameId.Description,
BeginDate = modelByGameId.BeginTime,
EndDate = modelByGameId.EndTime
};
IList <GamePrizeInfo> gamePrizeListsByGameId = GameHelper.GetGamePrizeListsByGameId(modelByGameId.GameId);
List <PrizeData> list2 = new List <PrizeData>();
GamePrizeInfo info2 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.一等奖);
PrizeData item = new PrizeData {
prizeType = info2.PrizeGrade.ToString()
};
PrizeResultViewInfo info6 = new PrizeResultViewInfo {
PrizeType = info2.PrizeType,
GivePoint = info2.GivePoint,
GiveCouponId = info2.GiveCouponId,
GiveShopBookId = info2.GiveShopBookId
};
item.prizeName = GameHelper.GetPrizeName(info6);
list2.Add(item);
GamePrizeInfo info3 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.二等奖);
PrizeData data4 = new PrizeData {
prizeType = info3.PrizeGrade.ToString()
};
PrizeResultViewInfo info7 = new PrizeResultViewInfo {
PrizeType = info3.PrizeType,
GivePoint = info3.GivePoint,
GiveCouponId = info3.GiveCouponId,
GiveShopBookId = info3.GiveShopBookId
};
data4.prizeName = GameHelper.GetPrizeName(info7);
list2.Add(data4);
GamePrizeInfo info4 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.等奖);
PrizeData data5 = new PrizeData {
prizeType = info4.PrizeGrade.ToString()
};
PrizeResultViewInfo info8 = new PrizeResultViewInfo {
PrizeType = info4.PrizeType,
GivePoint = info4.GivePoint,
GiveCouponId = info4.GiveCouponId,
GiveShopBookId = info4.GiveShopBookId
};
data5.prizeName = GameHelper.GetPrizeName(info8);
list2.Add(data5);
GamePrizeInfo info5 = gamePrizeListsByGameId.FirstOrDefault <GamePrizeInfo>(p => p.PrizeGrade == PrizeGrade.普通奖);
PrizeData data6 = new PrizeData {
prizeType = info5.PrizeGrade.ToString()
};
PrizeResultViewInfo info9 = new PrizeResultViewInfo {
PrizeType = info5.PrizeType,
GivePoint = info5.GivePoint,
GiveCouponId = info5.GiveCouponId,
GiveShopBookId = info5.GiveShopBookId
};
data6.prizeName = GameHelper.GetPrizeName(info9);
list2.Add(data6);
PrizeData data7 = new PrizeData {
prizeType = PrizeGrade.未中奖.ToString(),
prizeName = modelByGameId.NotPrzeDescription
};
list2.Add(data7);
data.prizeLists = list2;
IsoDateTimeConverter converter = new IsoDateTimeConverter();
converter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
context.Response.Write(JsonConvert.SerializeObject(data, Formatting.Indented, new JsonConverter[] { converter }));
}
}
}
