SQLServerDAL/GiftsClass.cs

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

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

#region license
// CopyRight (c) 2009-2016 WMPT Teconology. All Rights Reserved.
// Function :礼品类别数据层
// Created by tuhui at 2010-6-22 15:03:49.
// E-Mail: tuhui@ihangjing.com.com
#endregion
using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Text;
using System.Data;

using WMPT.Model;
using WMPT.Common;
using WMPT.DBUtility;

using System.Data.SqlClient;

namespace WMPT.SQLServerDAL
{
    public class GiftsClass
    {
        /// <summary>
        /// 获取记录所有字段
        /// </summary>
        /// 此代码由杭景科技代码内部生成器自动生成
        /// <param>ClassId</param>
        /// <returns>GiftsClassInfo</returns>
        public GiftsClassInfo GetModel(int ClassId)
        {
            SqlParameter parameter = new SqlParameter("@nClassId", SqlDbType.Int, 4);
            parameter.Value = ClassId;
            GiftsClassInfo model = null;

            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.Text, "select * from GiftsClass where ClassId=@nClassId", parameter))
            {
                if (dr.Read())
                {
                    model = new GiftsClassInfo();
                    model.ClassId = HJConvert.ToInt32(dr["ClassId"]);
                    model.ClassName = HJConvert.ToString(dr["ClassName"]);
                    model.ParentId = HJConvert.ToString(dr["ParentId"]);
                    model.ClassOrder = HJConvert.ToInt32(dr["ClassOrder"]);
                }
            }
            return model;
        }

        /// <summary>
        /// 获得总记录数
        /// </summary>
        /// 此代码由杭景科技代码内部生成器自动生成
        public int GetCount(string strWhere)
        {
            return Convert.ToInt32(SQLHelper.ExecuteScalar(CommandType.StoredProcedure, "pagecount", new SqlParameter("@tblName", "GiftsClass"), new SqlParameter("@strWhere", strWhere)));
        }

        /// <summary>
        /// 获取列表