API55128/Lottomat.SOA.API/Controllers/V1/LotterySkillController.cs

using System;
using System.Data;
using System.Net.Http;
using System.Web.Http;
using Lottomat.Application.Busines.CommonManage;
using Lottomat.Application.Code;
using Lottomat.Application.Entity.CommonEntity;
using Lottomat.Application.Entity.LotteryNumberManage.Parameter;
using Lottomat.Application.Entity.LotteryNumberManage.ViewModel;
using Lottomat.SOA.API.Caching;
using Lottomat.SOA.API.Controllers.Base;
using Lottomat.Util.Extension;

namespace Lottomat.SOA.API.Controllers.V1
{
    /// <summary>
    ///     彩种技巧
    /// </summary>
    public class LotterySkillController : BaseApiController
    {
        private static readonly CommonBLL commonBll = new CommonBLL();

        /// <summary>
        ///     根据Id获取彩种技巧详情
        /// </summary>
        /// <param name="arg"></param>
        /// <returns></returns>
        [HttpPost]
        public HttpResponseMessage GetLotterySkillById(GetLotterySkillArgEntity arg)
        {
            var resultMsg = new BaseJson<LotterySkillListViewEntity>
            {
                Status = (int)JsonObjectStatus.Error,
                Message = "服务器未知错误。",
                Data = null
            };

            Logger(typeof(LotterySkillController), arg.TryToJson(), "根据Id获取彩种技巧详情-GetLotterySkillById", () =>
            {
                if (!string.IsNullOrEmpty(arg.t))
                    if (arg.t.CheckTimeStamp())
                    {
                        DataTable data = null;
                        string key = $"GetLotterySkillById/{arg.LotteryCode}/{arg.Id}";
                        if (webCache.IsExist(key))
                        {
                            data = webCache.GetObject<DataTable>(key) as DataTable;
                        }
                        else
                        {
                            var sql = $"SELECT [Content],[Title],[Author],[AddTime] FROM [dbo].[B_LotterySkill] WHERE IsDelete = 0 AND [TypeId] = {(int)arg.LotteryCode} AND [PK] = {arg.Id}";
                            data = commonBll.ExcuteSqlDataTable(sql);
                            webCache.AddObject(key, data, (int)CacheTime.Data);
                        }
                        if (data.IsExistRows())
                        {
                            var res = data.DataTableToObject<LotterySkillListViewEntity>();

                            resultMsg = new BaseJson<LotterySkillListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = res,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                        else
                        {
                            resultMsg = new BaseJson<LotterySkillListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = null,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                    }
                    else
                    {
                        resultMsg = new BaseJson<LotterySkillListViewEntity>
                        {
                            Status = (int)JsonObjectStatus.Fail,
                            Data = null,
                            Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
                            BackUrl = null
                        };
                    }
                else
                    resultMsg = new BaseJson<LotterySkillListViewEntity>
                    {
                        Status = (int)JsonObjectStatus.Fail,
                        Data = null,
                        Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
                        BackUrl = null
                    };
            }, e =>
            {
                resultMsg = new BaseJson<LotterySkillListViewEntity>
                {
                    Status = (int)JsonObjectStatus.Exception,
                    Data = null,
                    Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
                    BackUrl = null
                };
            });

            return resultMsg.TryToJson().ToHttpResponseMessage();
        }

        /// <summary>
        ///     获取彩种技巧列表
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public HttpResponseMessage GetLotterySkillList(GetLotterySkillListArgEntity arg)
        {
            var resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
            {
                Status = (int)JsonObjectStatus.Error,
                Message = "服务器未知错误。",
                Data = null
            };

            Logger(typeof(LotterySkillController), arg.TryToJson(), "获取彩种技巧列表-GetLotterySkillList", () =>
            {
                if (!string.IsNullOrEmpty(arg.t))
                    if (arg.t.CheckTimeStamp())
                    {
                        DataTablePagerCache<DataTable> tablePager = null;
                        string key = $"GetLotterySkillList/{arg.LotteryCode}/{arg.PageIndex}/{arg.PageSize}";
                        if (webCache.IsExist(key))
                        {
                            tablePager = webCache.GetObject<DataTablePagerCache<DataTable>>(key) as DataTablePagerCache<DataTable>;
                        }
                        else
                        {
                            var sql = $"SELECT [PK],[TypeName],[TypeId],[Title],[AddTime] FROM [dbo].[B_LotterySkill] WHERE IsDelete = 0 AND TypeId = {(int)arg.LotteryCode}";
                            DataTable table = commonBll.FindPageDataTable(sql, "AddTime", false, arg.PageSize, arg.PageIndex,
                            out var total);
                            tablePager = new DataTablePagerCache<DataTable>() { Total = total, Table = table };
                            webCache.AddObject(key, tablePager, (int)CacheTime.Data);
                        }

                        DataTable data = null;
                        int recordTotal = 0;
                        if (tablePager != null && tablePager.Table != null)
                        {
                            recordTotal = tablePager.Total;
                            data = tablePager.Table;
                        }
                        else
                        {
                            data = new DataTable();
                        }
                        if (data.IsExistRows())
                        {
                            var res = data.DataTableToList<LotterySkillListViewEntity>();
                            foreach (var item in res)
                            {
                                item.TypeCode = arg.LotteryCode.ToString();
                            }
                            var pageData = new PageData<LotterySkillListViewEntity>
                            {
                                TotalRow = recordTotal,
                                TotalPage = (int)Math.Floor(recordTotal * 1.0 / arg.PageSize) + 1,
                                PageIndex = arg.PageIndex,
                                Rows = res
                            };

                            resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = pageData,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                        else
                        {
                            resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = null,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                    }
                    else
                    {
                        resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
                        {
                            Status = (int)JsonObjectStatus.Fail,
                            Data = null,
                            Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
                            BackUrl = null
                        };
                    }
                else
                    resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
                    {
                        Status = (int)JsonObjectStatus.Fail,
                        Data = null,
                        Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
                        BackUrl = null
                    };
            }, e =>
            {
                resultMsg = new BaseJson4Page<LotterySkillListViewEntity>
                {
                    Status = (int)JsonObjectStatus.Exception,
                    Data = null,
                    Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
                    BackUrl = null
                };
            });

            return resultMsg.TryToJson().ToHttpResponseMessage();
        }
    }
}