LK.WXAD.Dals/ADClass.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
namespace LK.WXAD.Dals
{
	/// <summary>
	/// 数据访问类:ADClass
	/// </summary>
	public partial class ADClass
	{
        public string sqlConnectionString = LK.WXAD.SqlConn.SqlConn.SqlConnectionString();

        public ADClass()
		{}
		#region  BasicMethod

		/// <summary>
		/// 得到最大ID
		/// </summary>
		public int GetMaxId()
		{
		return new GetMaxID().GetID("ClassID", "LK_ADClass"); 
		}


        public DataTable GetList(string strWhere, int pageSize, int pageIndex, out int counts, out int pageCounts)
        {
           
           return LK.WXAD.Commons.PageView.GetPageView("LK_ADClass", "*", pageSize, pageIndex, "ClassID", true, strWhere, "ClassID", out counts, out pageCounts).Tables[0];
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int ClassID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from LK_ADClass");
			strSql.Append(" where ClassID=@ClassID");
			SqlParameter[] parameters = {
					new SqlParameter("@ClassID", SqlDbType.Int,4)
			};
			parameters[0].Value = ClassID;

            object o = SqlHelper.ExecuteScalar(sqlConnectionString, CommandType.Text, strSql.ToString(), parameters);



            if (o != null)
            {
                if (Convert.ToInt32(o) > 0)
                {
                    return true;
                }
                return false;
            }
            else