SQLServerDAL/Gifts.cs

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

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

#region license
// CopyRight (c) 2009-2016 WMPT Teconology. All Rights Reserved.
// Function :礼品信息
// Created by tuhui at 2010-6-22 14:58:31.
// 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 Gifts
    {
        /// <summary>
        /// 获取记录所有字段
        /// </summary>
        /// 此代码由杭景科技代码内部生成器自动生成
        /// <param>GiftsId</param>
        /// <returns>GiftsInfo</returns> 
        public GiftsInfo GetModel(int GiftsId)
        {
            string sql = "select * from Gifts where GiftsId=@GiftsId";
            SqlParameter parameter = new SqlParameter("@GiftsId", SqlDbType.Int, 4);
	        parameter.Value = GiftsId;
	        GiftsInfo model = null;
	        using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.Text, sql, parameter))
	        {
		        if (dr.Read())
		        {
			        model = new GiftsInfo();
			        model.GiftsId = HJConvert.ToInt32(dr["GiftsId"]);
			        model.ClassId = HJConvert.ToString(dr["ClassId"]);
			        model.Gname = HJConvert.ToString(dr["Gname"]);
			        model.Content = HJConvert.ToString(dr["Content"]);
			        model.NeedIntegral = HJConvert.ToString(dr["NeedIntegral"]);
			        model.GiftsPrice = HJConvert.ToDecimal(dr["GiftsPrice"]);
			        model.Picture = HJConvert.ToString(dr["Picture"]);
                    model.Stocks = HJConvert.ToInt32(dr["stocks"]);
                    model.bigpicture = HJConvert.ToString(dr["bigpicture"]);
		        }
	        }
	        return model;
        }

        /// <summary>
        /// 获得总记录数
        /// </summary>
        /// 此代码由杭景科技代码内部生成器自动生成
        public int GetCount(string strWhere)
        {