IA.Data/CustomerWarningData.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using IA.Data.EF;
using IA.Data.Ioc;
using IA.Models;
using Tonglu.Common.Extensions;
using System.Linq;
using IA.Core.Domain;
using IA.Models.Common;

namespace IA.Data
{
    public class CustomerWarningData : EfBaseData
    {
        /// <summary>
        /// 获取终端用户图片信息
        /// </summary>
        /// <param name="fBatchNo">出厂编号</param>
        /// <param name="startTime">开始时间</param>
        /// <param name="state">状态</param>
        /// <param name="endTime">结束时间</param>
        /// <param name="dealerid">经销商Id</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public PageResult<CustomerWarningModel> GetList(string fBatchNo, int? state, DateTime? startTime, DateTime? endTime,
            int? dealerid, int pageIndex = 1, int pageSize = 10)
        {
            using (var iefpersistance = IOCContainer.Get<IEfPersistance>())
            {
                var sql = new StringBuilder();
                sql.Append("select a.*,b.customer_name,b.phone_no,e.FName  from CustomerWarning as a ");
                sql.Append("inner join Customer as b on a.CustomerId=b.customer_id ");
                sql.Append("inner join t_DealStockBill_Entry as c on a.FBatchNo=c.product_no ");
                sql.Append("inner join t_Dealstockbill as d on c.billid=d.billId  and d.customer_id= a.CustomerId ");
                sql.Append("inner join t_Organization as e on d.dealerid=e.FItemID where 1=1 ");
                if (!string.IsNullOrWhiteSpace(fBatchNo))
                {
                    sql.AppendFormat("and a.FBatchNo like '%{0}%' ", fBatchNo);
                }
                if (state.HasValue)
                {
                    sql.AppendFormat("and a.state={0} ", state);
                }
                if (startTime.HasValue)
                {
                    sql.AppendFormat("and a.CreateTime >= '{0}' ", startTime.TryDateTime().ToString("yyyy-MM-dd 00:00:00"));
                }
                if (endTime.HasValue)
                {
                    sql.AppendFormat("and a.CreateTime <= '{0}' ", endTime.TryDateTime().ToString("yyyy-MM-dd 23:59:59"));
                }
                if (dealerid.HasValue)
                {
                    sql.AppendFormat("and e.FItemID={0} ", dealerid);
                }
                var list = iefpersistance.PagedList<CustomerWarningModel>(sql.ToString(), null, pageIndex, pageSize);
                return list;
            }