API55128/Lottomat.SOA.API/Controllers/V1/LotteryGlossaryController.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 LotteryGlossaryController : BaseApiController
    {
        private static readonly CommonBLL commonBll = new CommonBLL();

        /// <summary>
        ///     根据Id获取彩票术语
        /// </summary>
        /// <param name="arg"></param>
        /// <returns></returns>
        [HttpPost]
        public HttpResponseMessage GetLotteryGlossaryById(GetLotteryGlossaryArgEntity arg)
        {
            var resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
            {
                Status = (int) JsonObjectStatus.Error,
                Message = "服务器未知错误。",
                Data = null
            };

            Logger(typeof(LotteryGlossaryController), arg.TryToJson(), "根据Id获取彩票术语-GetLotteryGlossaryById", () =>
            {
                if (!string.IsNullOrEmpty(arg.t))
                    if (arg.t.CheckTimeStamp())
                    {
                        var sql = $"SELECT [PK],[TypeId],[TypeName],[Title],[AddTime],[Author],[Content] FROM [B_LotteryGlossary] WHERE IsDelete = 0 AND [PK] = {arg.PK}";

                        var data = commonBll.ExcuteSqlDataTable(sql);

                        if (data.IsExistRows())
                        {
                            var res = data.DataTableToObject<LotteryGlossaryListViewEntity>();

                            resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
                            {
                                Status = (int) JsonObjectStatus.Success,
                                Data = res,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                        else
                        {
                            resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
                            {
                                Status = (int) JsonObjectStatus.Success,
                                Data = null,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                    }
                    else
                    {
                        resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
                        {
                            Status = (int) JsonObjectStatus.Fail,
                            Data = null,
                            Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
                            BackUrl = null
                        };
                    }
                else
                    resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
                    {
                        Status = (int) JsonObjectStatus.Fail,
                        Data = null,
                        Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
                        BackUrl = null
                    };
            }, e =>
            {
                resultMsg = new BaseJson<LotteryGlossaryListViewEntity>
                {
                    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 GetLotteryGlossaryList(GetLotteryGlossaryListArgEntity arg)
        {
            var resultMsg = new BaseJson4Page<LotteryGlossaryListViewEntity>
            {
                Status = (int) JsonObjectStatus.Error,
                Message = "服务器未知错误。",
                Data = null
            };

            Logger(typeof(LotteryGlossaryController), arg.TryToJson(), "获取彩票术语列表-GetLotteryGlossaryList", () =>
            {
                if (!string.IsNullOrEmpty(arg.t))
                    if (arg.t.CheckTimeStamp())
                    {
                        int value = 0;
                        int total = 0;
                        bool isGlossarytype = Enum.TryParse<LotteryGlossaryType>(arg.GlossaryType, true, out LotteryGlossaryType type);
                        
                        var sql = "";
                        if (!isGlossarytype)
                        {
                            sql = $"SELECT [PK],[Title],[TypeId],[TypeName],[AddTime] FROM [dbo].[B_LotteryGlossary] WHERE IsDelete = 0";
                            
                        }
                        else {
                            value = (int)Enum.Parse(typeof(LotteryGlossaryType), type.ToString());
                            sql =$"SELECT [PK],[Title],[TypeId],[TypeName],[AddTime] FROM [dbo].[B_LotteryGlossary] WHERE IsDelete = 0 AND TypeId={value}";

                        }

                        DataTablePagerCache<DataTable> tablePager = null;
                        string key = $"GetLotteryGlossaryList/{value}/{arg.PageIndex}/{arg.PageSize}";
                        if (webCache.IsExist(key))
                        {
                            tablePager = webCache.GetObject<DataTablePagerCache<DataTable>>(key) as DataTablePagerCache<DataTable>;
                        }
                        else
                        {
                            DataTable table = commonBll.FindPageDataTable(sql, "AddTime", false, arg.PageSize, arg.PageIndex,
                                out 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<LotteryGlossaryListViewEntity>();
                            foreach (var item in res)
                            {
                                item.TypeCode = type.ToString(); 
                            }
                            var pageData = new PageData<LotteryGlossaryListViewEntity>
                            {
                                TotalRow = total,
                                TotalPage = (int)Math.Floor(total * 1.0 / arg.PageSize) + 1,
                                PageIndex = arg.PageIndex,
                                Rows = res
                            };

                            resultMsg = new BaseJson4Page<LotteryGlossaryListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = pageData,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }
                        else
                        {
                            resultMsg = new BaseJson4Page<LotteryGlossaryListViewEntity>
                            {
                                Status = (int)JsonObjectStatus.Success,
                                Data = null,
                                Message = JsonObjectStatus.Success.GetEnumText(),
                                BackUrl = null
                            };
                        }

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

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


    }
}