kjh-m-55128/Business/TK/DataItemBLL.cs

using Common;
using Interface;
using Models;
using Models.Entity.LottomatBaseDB;
using Models.Views;
using Services;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;

namespace Business.TK
{
    public static class DataItemBLL
    {
        private static ZXInterface services;
        static DataItemBLL()
        {
            services = new ZXServic();
        }
        /// <summary>
        /// 获取abc分类下的item
        /// </summary>
        /// <param name="areacode"></param>
        /// <returns></returns>
        public static List<DataItemModel> GetDataItemList(List<string> areacode)
        {
            //AND i.ItemCode in('A','B','C')
            List<string> expressionlist = new List<string>();
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemCode", EnumExpression.In, areacode));
            for (int i = 0; i < listexp.Count; i++)
            { 
                expressionlist.Add(@" AND i." + listexp[i].GetSql());
            }
            string strSql = @"SELECT  i.ItemId ,
                                    i.ItemCode AS EnCode ,
                                    d.ItemDetailId ,
                                    d.ParentId ,
                                    d.ItemCode ,
                                    d.ItemName ,
                                    d.ItemValue ,
                                    d.QuickQuery ,
                                    d.SimpleSpelling ,
                                    d.IsDefault ,
                                    d.SortCode ,
                                    d.EnabledMark,
                                    d.IsRecommend,
                                    d.IsHot,
                                    d.IsShowHomePage 
                            FROM    Base_DataItemDetail d
                                    LEFT JOIN Base_DataItem i ON i.ItemId = d.ItemId
                            WHERE   1 = 1
                                    AND d.EnabledMark = 1
                                    AND d.DeleteMark = 0
                                     {0}
                            ORDER BY d.SortCode ASC";
            string sql = string.Format(strSql, string.Join("", expressionlist));
           return services.ExSqlGetList<DataItemModel>(sql);
        }

        /// <summary>
        /// 根据Base_DataItemDetail.ItemValue 查询实体
        /// </summary>
        /// <param name="ItemValue"></param>
        /// <returns></returns>
        public static DataItemModel GetDataItemList(string ItemValue)
        {
            List<string> expressionlist = new List<string>();
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemValue", "=", ItemValue));
            for (int i = 0; i < listexp.Count; i++)
            {
                expressionlist.Add(@" AND d." + listexp[i].GetSql());
            }
            string strSql = @"SELECT  i.ItemId ,
                                    i.ItemCode AS EnCode ,
                                    d.ItemDetailId ,
                                    d.ParentId ,
                                    d.ItemCode ,
                                    d.ItemName ,
                                    d.ItemValue ,
                                    d.QuickQuery ,
                                    d.SimpleSpelling ,
                                    d.IsDefault ,
                                    d.SortCode ,
                                    d.EnabledMark,
                                    d.IsRecommend,
                                    d.IsHot,
                                    d.IsShowHomePage 
                            FROM    Base_DataItemDetail d
                                    LEFT JOIN Base_DataItem i ON i.ItemId = d.ItemId
                            WHERE   1 = 1
                                    AND d.EnabledMark = 1
                                    AND d.DeleteMark = 0
                                     {0}
                            ORDER BY d.SortCode ASC";
            string sql = string.Format(strSql, string.Join("", expressionlist));
            var list= services.ExSqlGetList<DataItemModel>(sql);
            if (list!=null)
            {
                return list[0];
            }
            else
            {
                return null;
            }
        }

        public  static List<DataItemModel> GetDataItemListbyEnCode(string EnCode)
        {
            var encodeary = EnCode.Split(',').ToList() ;
            List<EExpression> listexp = new List<EExpression>();
           
            List<string> expressionlist = new List<string>();
           
            listexp.Add(new EExpression("ItemCode", EnumExpression.In, encodeary));
            for (int i = 0; i < listexp.Count; i++)
            {
                expressionlist.Add(@" AND i." + listexp[i].GetSql());
            }
            string strSql = @"SELECT  i.ItemId ,
                                    i.ItemCode AS EnCode ,
                                    d.ItemDetailId ,
                                    d.ParentId ,
                                    d.ItemCode ,
                                    d.ItemName ,
                                    d.ItemValue ,
                                    d.QuickQuery ,
                                    d.SimpleSpelling ,
                                    d.IsDefault ,
                                    d.SortCode ,
                                    d.EnabledMark,
                                    d.IsRecommend,
                                    d.IsHot,
                                    d.IsShowHomePage 
                            FROM    Base_DataItemDetail d
                                    LEFT JOIN Base_DataItem i ON i.ItemId = d.ItemId
                            WHERE   1 = 1
                                    AND d.EnabledMark = 1
                                    AND d.DeleteMark = 0
                                     {0}
                            ORDER BY d.SortCode ASC";
            string sql = string.Format(strSql, string.Join("", expressionlist));
            return services.ExSqlGetList<DataItemModel>(sql);
        }

        /// <summary>
        /// 根据ItemCode 查询Base_DataItem表的数据 多条返回第一条
        /// </summary>
        /// <param name="ItemCode"></param>
        /// <returns></returns>
        public static Base_DataItem GetBaseDataItemListbyEnCode(string ItemCode)
        {
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemCode","=",ItemCode));
            var list= services.GetList<Base_DataItem>(null, listexp, false);
            if (list!=null)
            {
                return list[0];
            }
            else
            {
                return null;
            }
            //AND i.ItemCode in('A','B','C')


        }
        /// <summary>
        /// 根据ItemCode 查询Base_DataItem表的数据 多条返回第一条
        /// </summary>
        /// <param name="ItemCode"></param>
        /// <returns></returns>
        public static  List<Base_DataItem> GetBaseDataItemListbyEnCode(List<string> ItemCode)
        {
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemCode",EnumExpression.In, ItemCode));
            var list = services.GetList<Base_DataItem>(null, listexp, false);
            if (list != null)
            {
                return list;
            }
            else
            {
                return null;
            }
            //AND i.ItemCode in('A','B','C')


        }

        public static List<Base_DataItemDetail> GetListbyItemId(string ItemId)
        {
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemId", "=", ItemId));
            var list = services.GetList<Base_DataItemDetail>(null, listexp, false);
            return list;
        }
        public static Base_DataItemDetail GetBase_DataItemDetailBYkey(object key)
        {
            return services.QueryItembyKey<Base_DataItemDetail>(key);
        }

        public static List<Base_DataItemDetail> GetListbyItemId( List<string> ItemDetailIds)
        {
            List<EExpression> listexp = new List<EExpression>();
            listexp.Add(new EExpression("ItemDetailId", EnumExpression.In, ItemDetailIds));
            var list = services.GetList<Base_DataItemDetail>(null, listexp, false);
            return list;
        }

        public static List<Base_DataItemDetail> GetDataItemDetailList()
        {
            try
            {
              var data= services.GetList<Base_DataItemDetail>(null, new List<EExpression>());
                return data;
                    
            }
            catch (Exception ee)
            {

                LogHelper.Error(typeof(DataItemBLL), ee.Message + "  :GetDataItemDetailList ");
                return null;

            }
            
        }
             
        /// <summary>
        /// 根据id获取彩吧工具分类集合
        /// </summary>
        /// <param name="areacode"></param>
        /// <returns></returns>
        public static List<DataItemModel> GetDataItemListbyId(string id)
        {         
            string strSql = @"SELECT 
                                    d.ItemDetailId ,
                                    d.ParentId ,
                                    d.ItemCode ,
                                    d.ItemName ,
                                    d.ItemValue ,
                                    d.QuickQuery ,
                                    d.SimpleSpelling ,
                                    d.IsDefault ,
                                    d.SortCode ,
                                    d.EnabledMark,
                                    d.IsRecommend,
                                    d.IsHot,
                                    d.IsShowHomePage 
                            FROM    Base_DataItemDetail d
                                  
                            WHERE   1 = 1
                                    AND d.EnabledMark = 1
                                    AND d.DeleteMark = 0
                                     {0}
                            ORDER BY d.SortCode ASC";
            string sql = string.Format(strSql, string.Join("", (new EExpression(" and d.ItemId","=", id).GetSql())));
            return services.ExSqlGetList<DataItemModel>(sql);
        }
    }
}