source/HF.Core/HF.Sale.Data/SaleAccDayRecordData.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Threading.Tasks;
using HF.DataAccess.SqlDataContract;
using HF.DataAccess.DBAgent;
using HF.Business.Common;
using HF.Framework;
namespace HF.Sale.Data
{
    public class SaleAccDayRecordData : HF.Business.Common.BaseData
    {
        public SaleAccDayRecordData()
        {
            TableName = "Sale_AccDayRecord";
            KeyField = "Id";
            string[] fields = { "Id","AccDate","ShopId","OrganizeId","FirstTime","EndTime","InitMoney",
                                "BillCount","GoodsQty","BillMoneyTotal" ,"YingShouMoneyTotal","YiShouMoneyTotal","DiscountMoneyTotal",
                                "ReturnMoneyTotal","ReturnQtyTotal","AlipayMoneyTotal","WeiXinMoneyTotal","CashMoneyTotal","BalanceMoenyTotal",
                                "OtherMoneyTotal","AlipayCount","WeiXinCount","CashCount","BalanceCount","OtherCount","CreateUserId","CreateUserName",
                                "CreateTime"};
            FieldList = fields.ToArray();//
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
       
        public static SaleAccDayRecordData GetInstance()
        {
            return new SaleAccDayRecordData();
        }
        /// <summary>
        /// 获取交班信息列表
        /// </summary>
        /// <param name="organizeId">所属公司id</param>
        /// <param name="queryJson">综合查询条件</param>
        /// <param name="pageindex">页码</param>
        /// <param name="pagesize">每页条数</param>
        /// <param name="sort">排序</param>
        /// <returns>商品销售单</returns>
        public DataTable GetAccDayRecordTable(string organizeId, string queryJson, string pageindex, string pagesize, string sort)
        {
            SqlDataItem sqlItem = new SqlDataItem();
            string selectStr = " * ";
            if (string.IsNullOrEmpty(sort)) sort = " CreateTime ";
            var queryParam = queryJson.ToJObject();
            string whereStr = " organizeId=@organizeId ";
            //部门权限
            if (UserEntity != null)
            {
                whereStr = whereStr + "and DepartEnCode like @DepartEnCode";
                sqlItem.AppendParameter("@DepartEnCode", UserEntity.UserDepartEncode + "%");
            }
            //店铺名称
            if (!queryParam["Caption"].IsEmpty())
            {
                whereStr = whereStr + " and  Caption like @Caption";
                string caption = queryParam["Caption"].ToString();
                sqlItem.AppendParameter("@Caption", "%"+ caption + "%");
            }