source/HF.Core/HF.Sale.Data/SaleStockQRCodeData.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;
using Newtonsoft.Json.Linq;
using System.Drawing;
namespace HF.Sale.Data
{
    public class SaleStockQRCodeData : BaseData
    {
        public SaleStockQRCodeData()
        {
            TableName = "Sale_StockQRCode";
            KeyField = "StockId";
            TableViewName = "Sale_StockQRCodeView";
            Prefix = "qr";
            string[] fields = { "StockId"};
            FieldList = fields.ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
       
        public static SaleStockData GetInstance()
        {
            return new SaleStockData();
        }
        public override DataTable GetListTableById(string organizeId, string cateId, string queryJson, int pageindex, int pagesize, string sort)
        {
            return GetListTableByKeys(organizeId, "cateId", cateId, pageindex, pagesize, sort);
        }
        /// <summary>
        /// 获取应收款信息
        /// </summary>
        /// <param name="keyValue"></param>
        /// <returns></returns>
        public override DataRow GetDataRow(string keyValue)
        {
            return this.GetDataRow("Sale_StockQRCodeView", "StockId", keyValue);
        }
        /// <summary>
        /// 判断是否存在
        /// </summary>
        /// <param name="keyName"></param>
        /// <param name="keyValue"></param>
        /// <returns></returns>
        public override bool Exists(string keyName, string keyValue)
        {
            return base.Exists("StockId", keyValue);
        }


        public override DataTable GetListTableByKeys(string organizeId, string condition, string keyword, int pageindex, int pagesize, string sort)
        {
            SqlDataItem sqlItem = new SqlDataItem();
            string selectStr = " * ";