WEBUI/WMS.BZCore/TDb/BillOrderOut.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using WMS.Info;
using WMS.Util;

namespace WMS.Core
{
    public class BillOrderOut
    {
        /// <summary>
        /// 获取列表数据
        /// <summary>
        /// <returns></returns>
        public IEnumerable<BILL_ORDEROUT> GetList(string keyword)
        {
            try
            {
                return SysDbCore.GetDbCtx().Queryable<BILL_ORDEROUT>().Where(it => it.F_ISDELETE == 0).WhereIF(!keyword.IsEmpty(), it => it.F_NO.Contains(keyword)).ToList();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 获取分页数据
        /// <summary>
        /// <returns></returns>
        public IEnumerable<BILL_ORDEROUT> GetPageList(Pagination pagination, string queryJson)
        {
            SqlSugarClient ctx = null;
            try
            {
                ctx = SysDbCore.GetDbCtx();
                int count = 0;
                var queryParam = queryJson.ToJObject();

                var db = ctx.Queryable<BILL_ORDEROUT>().Where(it => it.F_ISDELETE == 0);
                //单据日期
                if (!queryParam["Btime"].IsEmpty() && !queryParam["Etime"].IsEmpty())
                {
                    db.Where(ord => ord.F_ADDTIME >= queryParam["Btime"].ToDate() && ord.F_ADDTIME <= queryParam["Etime"].ToDate());
                }

                if (!queryParam["F_EDITUSERNO"].IsEmpty())
                {
                    string kw = queryParam["F_EDITUSERNO"].ToString();
                    db.Where(ord => ord.F_EDITUSERNO.Contains(kw));
                }
                if (!queryParam["F_ISSUCC"].IsEmpty())
                {
                    string kw = queryParam["F_ISSUCC"].ToString();
                    db.Where(ord => ord.F_ISSUCC == int.Parse(kw));
                }
                if (!queryParam["F_UPDOWN"].IsEmpty())
                {
                    string kw = queryParam["F_UPDOWN"].ToString();
                    db.Where(ord => ord.F_UPDOWN == kw);
                }
                if (!queryParam["F_ORDERTYPENUM"].IsEmpty())
                {
                    string kw = queryParam["F_ORDERTYPENUM"].ToString();
                    db.Where(ord => ord.F_ORDERTYPENUM == int.Parse(kw));
                }

                List<BILL_ORDEROUT> list = null;
                if (pagination.sord.ToUpper() == "ASC")
                {
                    list = db.OrderBy(pagination.sidx).ToPageList(pagination.page, pagination.rows, ref count);
                }
                else
                {
                    string orderstr = pagination.sidx + " desc";
                    list = db.OrderBy(orderstr).ToPageList(pagination.page, pagination.rows, ref count);
                }
                pagination.records = count;
                return list;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                ctx.Dispose();
            }
        }
        /// <summary>
        /// 获取实体数据
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public BILL_ORDEROUT GetEntity(string keyValue)
        {
            try
            {
                return SysDbCore.GetDbCtx().Queryable<BILL_ORDEROUT>().Where(it => it.F_ISDELETE == 0 && it.F_NO == keyValue).OrderBy(v => v.F_ADDTIME).First();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除实体数据
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public void DeleteEntity(string keyValue)
        {
            try
            {
                SysDbCore.GetDbCtx().Deleteable<BILL_ORDEROUT>().Where(it => it.F_NO == keyValue).ExecuteCommand();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 保存实体数据（新增、修改）
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public void SaveEntity(LoginUserInfo loginUserInfo, string keyValue, BILL_ORDEROUT entity)
        {
            try
            {
                if (entity == null)
                {
                    throw SysExCore.ThrowFailException("输入数据为空。");
                }
                if (string.IsNullOrWhiteSpace(entity.F_NO))
                {
                    throw SysExCore.ThrowFailException("编码为空。");
                }
                //if (string.IsNullOrWhiteSpace(entity.F_NAME))
                //{
                //    throw SysExCore.ThrowFailException("名称为空。");
                //}
                entity.F_EDITTIME = DateTime.Now;
                entity.F_EDITUSERNO = loginUserInfo.UserNo;
                if (string.IsNullOrEmpty(keyValue))
                {
                    entity.F_ADDTIME = DateTime.Now;
                    entity.F_ADDUSERNO = loginUserInfo.UserNo;
                    entity.F_ISDELETE = 0;
                    entity.F_ISSTOP = 0;
                    SysDbCore.GetDbCtx().Insertable<BILL_ORDEROUT>(entity).ExecuteCommand();
                }
                else
                {
                    SysDbCore.GetDbCtx().Updateable<BILL_ORDEROUT>(entity).IgnoreColumns(it => new { it.F_ADDTIME, it.F_ADDUSERNO }).Where(it => it.F_NO == keyValue).ExecuteCommand();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public Dictionary<string, BILL_ORDEROUT> GetMap()
        {
            try
            {
                Dictionary<string, BILL_ORDEROUT> dics = new Dictionary<string, BILL_ORDEROUT>();
                SysDbCore.GetDbCtx().Queryable<BILL_ORDEROUT>().ToList().ForEach(it => dics.Add(it.F_NO, it));
                return dics;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取树形数据
        /// </summary>
        /// <param name="parentId">父级id</param>
        /// <returns></returns>
        public List<TreeModel> GetTree()
        {
            try
            {

                List<TreeModel> treeList = new List<TreeModel>();

                treeList.Add(
                        new TreeModel
                        {
                            id = "上传",
                            text = "上传",
                            value = "上传",
                            showcheck = false,
                            checkstate = 0,
                            isexpand = true,
                            parentId = "0"
                        }
                    );

                treeList.Add(
                       new TreeModel
                       {
                           id = "下载",
                           text = "下载",
                           value = "下载",
                           showcheck = false,
                           checkstate = 0,
                           isexpand = true,
                           parentId = "0"
                       }
                   );


                return treeList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}