SSWMS_2230395/SSWMS.Server/Persistence/P_House/P_GOODS_MAIN.cs

using SSWMS.Common;
using System.Collections;
using System.Collections.Generic;

namespace SSWMS.Server
{
    public class P_GOODS_MAIN : P_Base_House<GOODS_MAIN>
    {
        public GOODS_MAIN GetModelByGoodsCode(string sGoodsCode)
        {
            return this._sqlMap.QueryForObject<GOODS_MAIN>("GOODS_MAIN_SELECT_BY_GOODS_CODE", new Hashtable()
            {
                { "GOODS_CODE", sGoodsCode },
                { "GOODS_FLAG", SystemCode.FLAG.Enable }
            });
        }

        public GOODS_MAIN GetModelByGoodsName(string sGoodsName)
        {
            return this._sqlMap.QueryForObject<GOODS_MAIN>("GOODS_MAIN_SELECT_BY_GOODS_NAME", new Hashtable()
            {
                { "GOODS_NAME", sGoodsName },
                { "GOODS_FLAG", SystemCode.FLAG.Enable }
            });
        }

        public IList<GOODS_MAIN> GetListByGoodsClass(string sGoodsClass)
        {
            return this._sqlMap.QueryForList<GOODS_MAIN>("GOODS_MAIN_SELECT_BY_GOODS_CLASS", new Hashtable()
            {
                { "GOODS_CLASS", sGoodsClass },
                { "GOODS_FLAG", SystemCode.FLAG.Enable }
            });
        }
    }
}