|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/794bf435/a236a820/ |
?#pragma checksum "d:\wwwroot\sznzpj\wwwroot\App_Code\AccessManager.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "0367CF51EFF7D3AB452C75197F3A5476"
#line 1 "d:\wwwroot\sznzpj\wwwroot\App_Code\AccessManager.cs"
using System;
using System.Collections.Generic;
using System.Web;
using System.Data.OleDb;
using System.Data;
using Model;
/// <summary>
///AdminManager 的提要注明
/// </summary>
public class AccessManager
{
#region 事务
/// <summary>
/// 使用事务的步骤
/// </summary>
public static int Add(string name)
{
OleDbConnection conn = new OleDbConnection(AccessHelper.ConnectionString);
conn.Open();
OleDbTransaction trans = conn.BeginTransaction();
string sql = " INSERT INTO User ([Name]) VALUES ('呵呵')";
OleDbParameter[] parm = { new OleDbParameter("@Name", name) };
try
{
int ii = AccessHelper.ExecuteNonQuery(trans, sql, parm);
ii = AccessHelper.ExecuteNonQuery(trans, sql, parm);
ii = AccessHelper.ExecuteNonQuery(trans, sql + "231", parm);
//提交事务
trans.Commit();
return ii;
}
catch (Exception e)
{
//犯错执行事务回滚
trans.Rollback();
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
//OleDbParameter[] parm = { new OleDbParameter("@Name", name), new OleDbParameter("@Color", Color), new OleDbParameter("@Display", Display) };
//return AccessHelper.returnID(string.Format("INSERT INTO Tag ([Name],[Color],[Display]) VALUES ('{0}','{1}','{2}')",name,Color,Display));
}
#endregion
#region Admin
/// <summary>
/// 治理员登陆
/// </summary>
public static Admin AdminLogin(string name, string password)
{
Admin a = null;
string sql = " select * from Admin where name=@name and password=@password ";
OleDbParameter[] parm = { new OleDbParameter("@name", name), new OleDbParameter("@password", password) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
a = new Admin();
a.Id = Convert.ToInt32(reader["Id"]);
a.Name = Convert.ToString(reader["Name"]);
a.Password = Convert.ToString(reader["Password"]);
a.Remark = Convert.ToString(reader["Remark"]);
a.Level = Convert.ToInt32(reader["Level"]);
}
return a;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 治理员列表
/// </summary>
public static List<Admin> GetAdminList()
{
List<Admin> list = new List<Admin>();
string sql = " select * from Admin";
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
while (reader.Read())
{
Admin a = new Admin();
a.Id = Convert.ToInt32(reader["Id"]);
a.Name = Convert.ToString(reader["Name"]);
a.Password = Convert.ToString(reader["Password"]);
a.Remark = Convert.ToString(reader["Remark"]);
a.Level = Convert.ToInt32(reader["Level"]);
list.Add(a);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据Id查问治理员
/// </summary>
public static Admin GetAdmin(int Id)
{
Admin a = null;
string sql = " select * from Admin where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
a = new Admin();
a.Id = Convert.ToInt32(reader["Id"]);
a.Name = Convert.ToString(reader["Name"]);
a.Password = Convert.ToString(reader["Password"]);
a.Remark = Convert.ToString(reader["Remark"]);
a.Level = Convert.ToInt32(reader["Level"]);
}
return a;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 增长治理员
/// </summary>
public static bool AddAdmin(Admin admin)
{
try
{
string sql = " INSERT INTO Admin ([Name],[Password],[Remark],[Level]) VALUES (@Name,@Password,@Remark,2) ";
OleDbParameter[] parm = { new OleDbParameter("@Name", admin.Name), new OleDbParameter("@Password", admin.Password), new OleDbParameter("@Remark", admin.Remark) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除治理员
/// </summary>
public static bool DelAdmin(int id)
{
try
{
string sql = " delete from Admin where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 批改密码
/// </summary>
public static bool UpdateAdminPassword(int id, string password)
{
try
{
string sql = " Update Admin set [Password]=@Password where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Password", password), new OleDbParameter("@Id", id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region 公共
/// <summary>
/// 分页查问信息
/// </summary>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">每页数量</param>
/// <param name="pageCount">总数量</param>
/// <param name="sql">Sql查问语句</param>
/// <param name="Key">主键 若是 ID </param>
/// <param name="strShow">现实字段，所有效 * </param>
/// <param name="where">前提</param>
/// <param name="Order">排序，如：Id Desc </param>
/// <returns></returns>
public static DataTable GetPage(int pageIndex, int pageSize, out int pageCount, string sql, string Key, string strShow, string where, string Order, OleDbParameter[] parm)
{
try
{
return AccessHelper.ExecutePager(pageIndex, pageSize, Key, strShow, sql, where, Order, out pageCount, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问信息
/// </summary>
public static DataTable Get(string Sql)
{
return AccessHelper.ExecuteDataTable(Sql);
}
/// <summary>
/// 获取上一条信息
/// </summary>
/// <param name="Id">Id</param>
/// <param name="TableName">表名</param>
/// <returns>OleDbDataReader</returns>
public static DataTable GetPre(int Id, string TableName)
{
string sql = string.Format(" select * from [{1}] where id= ( select top 1 id from [{1}] where id <{0} order by id desc) ", Id, TableName);
return AccessHelper.ExecuteDataTable(sql);
}
/// <summary>
///获取下一条信息
/// </summary>
/// <param name="Id">Id</param>
/// <param name="TableName">表名</param>
/// <returns>OleDbDataReader</returns>
public static DataTable GetNext(int Id, string TableName)
{
string sql = string.Format(" select * from [{1}] where id= ( select top 1 id from [{1}] where id >{0} order by id asc) ", Id, TableName);
return AccessHelper.ExecuteDataTable(sql);
}
/// <summary>
/// 随机查问
/// </summary>
/// <param name="count">查问条数</param>
/// <param name="TableName">表名</param>
/// <returns>OleDbDataReader</returns>
public static DataTable GetRnd(int count, string tableName, string where)
{
string sql = string.Format(" select top {0} * from {1} {2} order by Rnd(time()-id+rnd())", count, tableName, where);
return AccessHelper.ExecuteDataTable(sql);
}
#endregion
#region Other
/// <summary>
/// 增长 Other
/// </summary>
public static bool AddOther(string title,string Content)
{
try
{
string sql = " insert into Other ([Title],[Content]) VALUES (@Title,@Content) ";
OleDbParameter[] parm = {
new OleDbParameter("@Title", title),
new OleDbParameter("@Content", Content)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问Other
/// </summary>
public static string GetOther(string Title)
{
string content = "";
string sql = " select Content from Other where Title=@Title";
OleDbParameter[] parm = { new OleDbParameter("@Title", Title) };
using (OleDbDataReader reader = AccessHelper.ExecuteReader(sql, parm))
{
if (reader.Read())
content = Convert.ToString(reader["Content"]);
return content;
}
}
/// <summary>
/// 查问Other标题
/// </summary>
public static string GetOtherTitle(int Id)
{
string Title = "";
string sql = " select Title from Other where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
using (OleDbDataReader reader = AccessHelper.ExecuteReader(sql, parm))
{
if (reader.Read())
Title = Convert.ToString(reader["Title"]);
return Title;
}
}
/// <summary>
/// 批改Other
/// </summary>
public static bool UpdataOther(string Title, string Content)
{
try
{
string sql = "update Other set Content=@Content where Title=@Title";
OleDbParameter[] parm = { new OleDbParameter("@Content", Content), new OleDbParameter("@Title", Title) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除 Other
/// </summary>
public static bool DelOther(int Id)
{
try
{
string sql = "delete from Other where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region SEO
/// <summary>
/// 增长 keywords、description
/// </summary>
public static bool AddSEO(SEOS seo)
{
try
{
string sql = " INSERT INTO SEO ([Url],[Url2],[Title],[keywords],[description]) VALUES (@Url,@Url2,@Title,@keywords,@description) ";
OleDbParameter[] parm = {
new OleDbParameter("@Url", seo.Url),
new OleDbParameter("@Url2", seo.Url2),
new OleDbParameter("@Title", seo.Title),
new OleDbParameter("@keywords", seo.keywords),
new OleDbParameter("@description", seo.description) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问 keywords、description
/// </summary>
public static SEOS GetSEO(int Id)
{
SEOS seo = null;
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
string sql = " select * from SEO where Id=@Id";
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
seo = new SEOS();
seo.Id = Convert.ToInt32(reader["Id"]);
seo.Url = Convert.ToString(reader["Url"]);
seo.Url2 = Convert.ToString(reader["Url2"]);
seo.Title = Convert.ToString(reader["Title"]);
seo.keywords = Convert.ToString(reader["keywords"]);
seo.description = Convert.ToString(reader["description"]);
}
return seo;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问 keywords、description
/// </summary>
public static SEOS GetSEO(string Url2)
{
SEOS seo = null;
string sql = " select * from SEO where Url2=@Url2";
OleDbParameter[] parm = { new OleDbParameter("@Url2", Url2)};
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
seo = new SEOS();
seo.Id = Convert.ToInt32(reader["Id"]);
seo.Url = Convert.ToString(reader["Url"]);
seo.Url2 = Convert.ToString(reader["Url2"]);
seo.Title = Convert.ToString(reader["Title"]);
seo.keywords = Convert.ToString(reader["keywords"]);
seo.description = Convert.ToString(reader["description"]);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
return seo;
}
/// <summary>
/// 批改 keywords、description
/// </summary>
public static bool UpdateSEO(SEOS seo)
{
try
{
string sql = " update SEO set [Url]=@Url,[Url2]=@Url2,[Title]=@Title,[keywords]=@keywords,[description]=@description where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Url", seo.Url),
new OleDbParameter("@Url2", seo.Url2),
new OleDbParameter("@Title", seo.Title),
new OleDbParameter("@keywords", seo.keywords),
new OleDbParameter("@description", seo.description),
new OleDbParameter("@Id", seo.Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除 keywords、description
/// </summary>
public static bool DelSEO(int Id)
{
try
{
string sql = " delete from SEO where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 分页查问 keywords、description
/// </summary>
public static DataTable GetSEO(int pageIndex, int pageSize, out int pageCount, string whereStr)
{
try
{
string strSql = " SELECT * FROM SEO ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, " Id DESC ", out pageCount);
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region 图片
/// <summary>
/// 增长图片
/// </summary>
public static int Addtupian(Images g)
{
try
{
string sql = " insert into [tupian] ([Alt],[ImgUrl],[XID]) values (@Alt,@ImgUrl,@XID) ";
OleDbParameter[] parm = {
new OleDbParameter("@Alt", g.tableName),
new OleDbParameter("@ImgUrl", g.ImgUrl),
new OleDbParameter("@XID", g.TID)
};
return AccessHelper.returnID(sql, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问图片
/// </summary>
public static Images Gettupian(int id)
{
Images g = null;
string sql = " select * from [tupian] where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@=@", id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
g = new Images();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["Alt"]);
g.ImgUrl = Convert.ToString(reader["ImgUrl"]);
g.TID = Convert.ToInt32(reader["XID"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 删除图片
/// </summary>
public static bool Deltupian(int Id)
{
try
{
string sql = " delete from [tupian] where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 凭据分类ID获取
/// </summary>
public static List<Images> GettupianList(int XID)
{
List<Images> list = new List<Images>();
Images g = null;
string sql = " select * from tupian where XID=@XID Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@XID", XID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Images();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["Alt"]);
g.ImgUrl = Convert.ToString(reader["ImgUrl"]);
g.TID = Convert.ToInt32(reader["XID"]);
g.Order = Convert.ToInt32(reader["Order"]);
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据分类ID和数量获取
/// </summary>
public static List<Images> GettupianList(int id, int count)
{
List<Images> list = new List<Images>();
Images g = null;
string sql = " select top " + count + " * from tupian where XID=@XID";
OleDbParameter[] parm = { new OleDbParameter("@XID", id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Images();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["Alt"]);
g.ImgUrl = Convert.ToString(reader["ImgUrl"]);
g.TID = Convert.ToInt32(reader["XID"]);
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 分页查问Gong
/// </summary>
public static DataTable GettupianList(int pageIndex, int pageSize, out int pageCount, int XID, string Order)
{
try
{
string strSql = " SELECT * FROM [tupian] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, " where XID=" + XID, Order, out pageCount);
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region 在线留言
/// <summary>
/// 增长留言
/// </summary>
public static bool addMessage(Messame m)
{
try
{
string sql = " INSERT INTO Message ([Name],[sg],[tz],[xl],[phone],[qq],[Content],[Time]) VALUES (@Name,@sg,@tz,@xl,@phone,@qq,@Content,@Time) ";
OleDbParameter[] parm = {
new OleDbParameter("@Name", m.Name),
new OleDbParameter("@sg", m.sg),
new OleDbParameter("@tz", m.tz),
new OleDbParameter("@xl", m.xl),
new OleDbParameter("@phone", m.phone),
new OleDbParameter("@qq", m.qq),
new OleDbParameter("@Content", m.Content),
new OleDbParameter("@Time", m.Time)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 分页查问留言
/// </summary>
public static DataTable GetMessage(int pageIndex, int pageSize, out int pageCount)
{
try
{
string strSql = " SELECT * FROM Message ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, "", " Id DESC ", out pageCount);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除留言
/// </summary>
public static bool DelMessage(int Id)
{
try
{
string sql = " delete from Message where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region 分类Classification
/// <summary>
/// 增长分类
/// </summary>
public static bool AddCF(Classification cf)
{
try
{
string sql = " insert into [Classification] ([tableName],[Name],[Content],[FID],[Order],[C],[ImgUrl]) values (@tableName,@Name,@Content,@FID,@Order,@C,@ImgUrl) ";
OleDbParameter[] parm = {
new OleDbParameter("@tableName", cf.tableName),
new OleDbParameter("@Name", cf.Name),
new OleDbParameter("@Content", cf.Content),
new OleDbParameter("@FID", cf.FID),
new OleDbParameter("@Order", cf.Order),
new OleDbParameter("@C", cf.C),
new OleDbParameter("@ImgUrl", cf.ImgUrl)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问分类
/// </summary>
public static Classification GetCF(int Id)
{
Classification cf = null;
string sql = " select * from [Classification] where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
cf = new Classification();
cf.Id = Convert.ToInt32(reader["Id"]);
cf.tableName = Convert.ToString(reader["tableName"]);
cf.Name = Convert.ToString(reader["Name"]);
cf.Content = Convert.ToString(reader["Content"]);
cf.FID = Convert.ToInt32(reader["FID"]);
cf.Order = Convert.ToInt32(reader["Order"]);
cf.C = Convert.ToBoolean(reader["C"]);
cf.ImgUrl = Convert.ToString(reader["ImgUrl"]);
}
return cf;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 批改分类
/// </summary>
public static bool UpdateCF(Classification cf)
{
try
{
string sql = " update [Classification] set [Name]=@Name,[Content]=@Content,[FID]=@FID,[Order]=@Order,[C]=@C,[ImgUrl]=@ImgUrl where Id=@Id ";
OleDbParameter[] parm = {
new OleDbParameter("@Name", cf.Name),
new OleDbParameter("@Content", cf.Content),
new OleDbParameter("@FID", cf.FID),
new OleDbParameter("@Order", cf.Order),
new OleDbParameter("@C", cf.C),
new OleDbParameter("@ImgUrl", cf.ImgUrl),
new OleDbParameter("@Id", cf.Id)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 批改分类
/// </summary>
public static bool UpdateCF(string Name,int Order,int Id)
{
try
{
string sql = " update [Classification] set [Name]=@Name,[Order]=@Order where Id=@Id ";
OleDbParameter[] parm = {
new OleDbParameter("@Name", Name),
new OleDbParameter("@Order", Order),
new OleDbParameter("@Id", Id)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问该类下面Gong表是否有信息
/// </summary>
public static bool GetCfDel(int Id)
{
try
{
string sql = "select * from Gong where CID=@CID ";
OleDbParameter[] parm = { new OleDbParameter("@CID", Id) };
return AccessHelper.ExecuteReader(sql, parm).Read() ? false : true;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除分类
/// </summary>
public static bool DelCF(int Id)
{
try
{
string sql = " delete from [Classification] where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 凭据FID查问分类列表
/// </summary>
public static List<Classification> GetCFList(string tableName, int FID)
{
List<Classification> list = new List<Classification>();
Classification cf = null;
string sql = " select * from [Classification] where FID=@FID and tableName=@tableName Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@FID", FID), new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
cf = new Classification();
cf.Id = Convert.ToInt32(reader["Id"]);
cf.tableName = Convert.ToString(reader["tableName"]);
cf.Name = Convert.ToString(reader["Name"]);
cf.Content = Convert.ToString(reader["Content"]);
cf.FID = Convert.ToInt32(reader["FID"]);
cf.Order = Convert.ToInt32(reader["Order"]);
cf.C = Convert.ToBoolean(reader["C"]);
cf.ImgUrl = Convert.ToString(reader["ImgUrl"]);
list.Add(cf);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据FID查问分类列表
/// </summary>
public static List<Classification> GetCFList(string tableName, int FID, int count)
{
List<Classification> list = new List<Classification>();
Classification cf = null;
string sql = " select top " + count + " * from [Classification] where FID=@FID and tableName=@tableName Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@FID", FID), new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
cf = new Classification();
cf.Id = Convert.ToInt32(reader["Id"]);
cf.tableName = Convert.ToString(reader["tableName"]);
cf.Name = Convert.ToString(reader["Name"]);
cf.Content = Convert.ToString(reader["Content"]);
cf.FID = Convert.ToInt32(reader["FID"]);
cf.Order = Convert.ToInt32(reader["Order"]);
cf.C = Convert.ToBoolean(reader["C"]);
cf.ImgUrl = Convert.ToString(reader["ImgUrl"]);
list.Add(cf);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据FID查问分类列表
/// </summary>
public static List<Classification> GetCFList(string sql)
{
List<Classification> list = new List<Classification>();
Classification cf = null;
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
while (reader.Read())
{
cf = new Classification();
cf.Id = Convert.ToInt32(reader["Id"]);
cf.tableName = Convert.ToString(reader["tableName"]);
cf.Name = Convert.ToString(reader["Name"]);
cf.Content = Convert.ToString(reader["Content"]);
cf.FID = Convert.ToInt32(reader["FID"]);
cf.Order = Convert.ToInt32(reader["Order"]);
cf.C = Convert.ToBoolean(reader["C"]);
cf.ImgUrl = Convert.ToString(reader["ImgUrl"]);
list.Add(cf);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 分页查问分类
/// </summary>
public static DataTable GetCF(int pageIndex, int pageSize, out int pageCount, string whereStr)
{
try
{
string strSql = " SELECT * FROM [Classification] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, "[Order] Desc,Id Asc ", out pageCount);
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region Gong
/// <summary>
/// 增长Gong
/// </summary>
public static int AddGong(Gong g)
{
try
{
string sql = " insert into [Gong] ([tableName],[CID],[Title],[Content],[Alt],[keywords],[description],[CkCount],[Order],[Time]) values (@tableName,@CID,@Title,@Content,@Alt,@keywords,@description,@CkCount,@Order,@Time) ";
OleDbParameter[] parm = {
new OleDbParameter("@tableName", g.tableName),
new OleDbParameter("@CID", g.CID),
new OleDbParameter("@Title", g.Title),
new OleDbParameter("@Content", g.Content),
new OleDbParameter("@Alt", g.Alt),
new OleDbParameter("@keywords", g.keywords),
new OleDbParameter("@description", g.description),
new OleDbParameter("@CkCount", g.CkCount),
new OleDbParameter("@Order", g.Order),
new OleDbParameter("@Time", g.Time)
};
return AccessHelper.returnID(sql, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 凭据Id查问Gong
/// </summary>
public static Gong GetGong(int Id)
{
Gong g = null;
string sql = " select * from [Gong] where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名）
/// </summary>
public static List<Gong> GetGong(string tableName)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select * from [Gong] where tableName=@tableName Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名丶排序）
/// </summary>
public static List<Gong> GetGong(string tableName,string Order)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select * from [Gong] where tableName=@tableName Order By [Order] Desc,Id Asc " + Order;
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名丶数量）
/// </summary>
public static List<Gong> GetGong(string tableName, int Count)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select top " + Count + " * from [Gong] where tableName=@tableName Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名丶数量、排序）
/// </summary>
public static List<Gong> GetGong(string tableName, int Count,string Order)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select top " + Count + " * from [Gong] where tableName=@tableName " + Order;
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名丶分类ID、数量）
/// </summary>
public static List<Gong> GetGong(string tableName,int CID, int Count)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select top " + Count + " * from [Gong] where tableName=@tableName and CID=@CID Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@CID", CID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Gong列表（表名丶分类ID、数量丶排序）
/// </summary>
public static List<Gong> GetGong(string tableName, int CID, int Count,string Order)
{
List<Gong> list = new List<Gong>();
Gong g = null;
string sql = " select top " + Count + " * from [Gong] where tableName=@tableName and CID=@CID " + Order;
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@CID", CID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
Images img = GetImages(g.tableName, g.Id);
if (img != null)
g.ImgUrl = img.ImgUrl;
else
g.ImgUrl = "";
list.Add(g);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 批改Gong
/// </summary>
public static bool UpdateGong(Gong g)
{
try
{
string sql = " update [Gong] set [CID]=@CID,[Title]=@Title,[Content]=@Content,[Alt]=@Alt,[keywords]=@keywords,[description]=@description,[CkCount]=@CkCount,[Time]=@Time,[Order]=@Order where Id=@Id ";
OleDbParameter[] parm = {
new OleDbParameter("@CID", g.CID),
new OleDbParameter("@Title", g.Title),
new OleDbParameter("@Content", g.Content),
new OleDbParameter("@Alt", g.Alt),
new OleDbParameter("@keywords", g.keywords),
new OleDbParameter("@description", g.description),
new OleDbParameter("@CkCount", g.CkCount),
new OleDbParameter("@Time", g.Time),
new OleDbParameter("@Order", g.Order),
new OleDbParameter("@Id", g.Id)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 批改Gong点击数量
/// </summary>
public static void AddTime(int Id)
{
try
{
string sql = " update [Gong] set CkCount=CkCount+1 where Id=@Id ";
OleDbParameter[] parm = {
new OleDbParameter("@Id", Id)
};
AccessHelper.ExecuteNonQuery(sql, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除Gong
/// </summary>
public static bool DelGong(int Id)
{
try
{
string sql = " delete from [Gong] where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 获取上一条信息Gong
/// </summary>
public static Gong GetGongPre(string tableName, int Id)
{
Gong g = null;
string sql = string.Format(" select * from Gong where id=( select top 1 id from Gong where id <{0} and tableName='{1}' order by id desc) ", Id, tableName);
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
if (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 获取下一条信息Gong
/// </summary>
public static Gong GetGongNext(string tableName, int Id)
{
Gong g = null;
string sql = string.Format(" select * from Gong where id=( select top 1 id from Gong where id >{0} and tableName='{1}' order by id asc) ", Id, tableName);
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
if (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 获取上一条信息Gong
/// </summary>
public static Gong GetGongPre(string tableName, int Id, int CID)
{
Gong g = null;
string sql = string.Format(" select * from Gong where id=( select top 1 id from Gong where id <{0} and tableName='{1}' and CID={2} order by id desc) ", Id, tableName, CID);
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
if (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 获取下一条信息Gong
/// </summary>
public static Gong GetGongNext(string tableName, int Id, int CID)
{
Gong g = null;
string sql = string.Format(" select * from Gong where id=( select top 1 id from Gong where id >{0} and CID={2} and tableName='{1}' order by id asc) ", Id, tableName, CID);
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql);
if (reader.Read())
{
g = new Gong();
g.Id = Convert.ToInt32(reader["Id"]);
g.tableName = Convert.ToString(reader["tableName"]);
g.CID = Convert.ToInt32(reader["CID"]);
g.Title = Convert.ToString(reader["Title"]);
g.Content = Convert.ToString(reader["Content"]);
g.Alt = Convert.ToString(reader["Alt"]);
g.keywords = Convert.ToString(reader["keywords"]);
g.description = Convert.ToString(reader["description"]);
g.CkCount = Convert.ToInt32(reader["CkCount"]);
g.Order = Convert.ToInt32(reader["Order"]);
g.Time = Convert.ToDateTime(reader["Time"]);
}
return g;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 分页查问Gong
/// </summary>
public static DataTable GetGong(int pageIndex, int pageSize, out int pageCount, string whereStr)
{
try
{
string strSql = " SELECT * FROM [Gong] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, "[Order] Desc,Id Desc ", out pageCount);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 分页查问Gong
/// </summary>
public static DataTable GetGong2(int pageIndex, int pageSize, out int pageCount, string whereStr)
{
try
{
string strSql = " SELECT * FROM [Gong] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, "[Order] Desc,Id Asc ", out pageCount);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 分页查问Gong
/// </summary>
public static DataTable GetGong(int pageIndex, int pageSize, out int pageCount, string whereStr, OleDbParameter[] parm)
{
try
{
string strSql = " SELECT * FROM [Gong] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, "[Order] Desc,Id Desc ", out pageCount, parm);
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region Property属性
/// <summary>
/// 增长Property属性
/// </summary>
public static int AddProperty(Property p)
{
try
{
string sql = " insert into [Property] ([tableName],[TID],[Type],[PTitle],[PContent],[Order]) values (@tableName,@TID,@Type,@PTitle,@PContent,@Order)";
OleDbParameter[] parm = {
new OleDbParameter("@tableName", p.tableName),
new OleDbParameter("@TID", p.TID),
new OleDbParameter("@Type", p.Type),
new OleDbParameter("@PTitle", p.PTitle),
new OleDbParameter("@PTitle", p.PContent),
new OleDbParameter("@Order", p.Order)
};
return AccessHelper.returnID(sql, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问Property属性
/// </summary>
public static Property GetProperty(string tableName, int TID, int Type)
{
Property p = null;
string sql = " select * from [Property] where tableName=@tableName and TID=@TID and Type=@Type";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Type", Type) };
using (OleDbDataReader reader = AccessHelper.ExecuteReader(sql, parm))
{
if (reader.Read())
{
p = new Property();
p.tableName = Convert.ToString(reader["tableName"]);
p.TID = Convert.ToInt32(reader["TID"]);
p.Type = Convert.ToInt32(reader["Type"]);
p.PTitle = Convert.ToString(reader["PTitle"]);
p.PContent = Convert.ToString(reader["PContent"]);
p.Order = Convert.ToInt32(reader["Order"]);
}
return p;
}
}
/// <summary>
/// 删除Property列表
/// </summary>
public static bool DelProperty(string tableName, int TID, int Type)
{
try
{
string sql = " delete from [Property] where tableName=@tableName and TID=@TID and Type=@Type";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Type", Type) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问Property列表（表名、表ID、类型）
/// </summary>
public static List<Property> GetPropertyList(string tableName, int TID, int Type)
{
List<Property> list = new List<Property>();
Property p = null;
string sql = " select * from [Property] where tableName=@tableName and TID=@TID and Type=@Type Order By [Order] Desc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Type", Type) };
using (OleDbDataReader reader = AccessHelper.ExecuteReader(sql, parm))
{
while (reader.Read())
{
p = new Property();
p.tableName = Convert.ToString(reader["tableName"]);
p.TID = Convert.ToInt32(reader["TID"]);
p.Type = Convert.ToInt32(reader["Type"]);
p.PTitle = Convert.ToString(reader["PTitle"]);
p.PContent = Convert.ToString(reader["PContent"]);
p.Order = Convert.ToInt32(reader["Order"]);
list.Add(p);
}
return list;
}
}
#endregion
#region Images
/// <summary>
/// 增长Images
/// </summary>
public static bool AddImages(Images img)
{
try
{
string sql = " insert into [Images] ([tableName],[TID],[ImgUrl],[Alt],[Order]) values (@tableName,@TID,@ImgUrl,@Alt,@Order) ";
OleDbParameter[] parm = {
new OleDbParameter("@tableName", img.tableName),
new OleDbParameter("@TID", img.TID),
new OleDbParameter("@ImgUrl", img.ImgUrl),
new OleDbParameter("@Alt", img.Alt),
new OleDbParameter("@Order", img.Order)
};
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 凭据Id查问Images
/// </summary>
public static Images GetImages(int Id)
{
Images img = null;
string sql = " select * from [Images] where Id=@Id";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
}
return img;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问封面图片
/// </summary>
public static Images GetImages(string tableName, int TID)
{
Images img = null;
string sql = " select top 1 * from [Images] where tableName=@tableName and TID=@TID Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
}
return img;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问第二张封面图片
/// </summary>
public static Images GetImages_2(string tableName, int TID)
{
Images img = null;
string sql = " select top 2 * from [Images] where tableName=@tableName and TID=@TID and ID not in (select top 1 Id from [Images] where tableName=@tableName and TID=@TID Order By [Order] Desc,Id Asc) Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
}
return img;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问封面图片
/// </summary>
public static Images GetImages(string tableName, int TID,int Order)
{
Images img = null;
string sql = " select top 1 * from [Images] where tableName=@tableName and TID=@TID and [Order]=@Order";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Order", Order) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
}
return img;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 查问Top图片
/// </summary>
public static Images GetImagesTop(string tableName, int TID)
{
Images img = null;
string sql = " select top 1 * from [Images] where tableName=@tableName and TID=@TID Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
}
return img;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据对应表名和对应表TID查问Images列表
/// </summary>
public static List<Images> GetImagesList(string tableName, int TID)
{
List<Images> list = new List<Images>();
Images img = null;
string sql = " select * from [Images] where tableName=@tableName and TID=@TID Order By [Order] Desc,Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
list.Add(img);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 凭据对应表名和对应表TID查问Images列表
/// </summary>
public static List<Images> GetImagesList(string tableName, int TID,int Order)
{
List<Images> list = new List<Images>();
Images img = null;
string sql = " select * from [Images] where tableName=@tableName and TID=@TID and [Order]=@Order Order By Id Asc";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Order", Order) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
while (reader.Read())
{
img = new Images();
img.Id = Convert.ToInt32(reader["Id"]);
img.tableName = Convert.ToString(reader["tableName"]);
img.TID = Convert.ToInt32(reader["TID"]);
img.ImgUrl = Convert.ToString(reader["ImgUrl"]);
img.Alt = Convert.ToString(reader["Alt"]);
img.Order = Convert.ToInt32(reader["Order"]);
list.Add(img);
}
return list;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 设为封面图片
/// </summary>
public static bool UpdateImages(int Id,string tableName, int TID,int Order)
{
OleDbConnection conn = new OleDbConnection(AccessHelper.ConnectionString);
conn.Open();
OleDbTransaction trans = conn.BeginTransaction();
try
{
string sql = " update [Images] set [Order]=0 where tableName=@tableName and TID=@TID and [Order]=@Order";
OleDbParameter[] parm = { new OleDbParameter("@tableName", tableName), new OleDbParameter("@TID", TID), new OleDbParameter("@Order", Order) };
int ii = AccessHelper.ExecuteNonQuery(trans, sql, parm);
sql = " update [Images] set [Order]=@Order where Id=@Id ";
OleDbParameter[] parm2 = { new OleDbParameter("@Order", Order), new OleDbParameter("@Id", Id) };
ii = AccessHelper.ExecuteNonQuery(trans, sql , parm2);
//提交事务
trans.Commit();
return ii> 0 ? true : false;
}
catch (Exception e)
{
//犯错执行事务回滚
trans.Rollback();
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
}
/// <summary>
/// 删除Images
/// </summary>
public static bool DelImages(int Id)
{
try
{
string sql = " delete from [Images] where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除Images
/// </summary>
public static bool DelImages(string tabaName,int TID)
{
try
{
string sql = " delete from [Images] where tabaName=@tabaName and TID=@TID";
OleDbParameter[] parm = { new OleDbParameter("@tabaName", tabaName), new OleDbParameter("@TID", TID) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
#endregion
#region 条码
/// <summary>
/// 增长条码
/// </summary>
public static int AddTm(string tm)
{
try
{
string sql = " insert into [tm] ([tm],[Time]) values (@tm,@Time) ";
OleDbParameter[] parm = {
new OleDbParameter("@tm", tm),
new OleDbParameter("@Time", DateTime.Now)
};
return AccessHelper.returnID(sql, parm);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 查问Gong
/// </summary>
public static bool GetTm(string tm)
{
string sql = " select * from [tm] where tm=@tm";
OleDbParameter[] parm = { new OleDbParameter("@tm", tm) };
OleDbDataReader reader = null;
try
{
reader = AccessHelper.ExecuteReader(sql, parm);
if (reader.Read())
return true;
else
return false;
}
catch (Exception e)
{
throw e;
}
finally
{
if (reader != null)
reader.Close();
}
}
/// <summary>
/// 删除Gong
/// </summary>
public static bool DelTm(int Id)
{
try
{
string sql = " delete from [tm] where Id=@Id ";
OleDbParameter[] parm = { new OleDbParameter("@Id", Id) };
return AccessHelper.ExecuteNonQuery(sql, parm) > 0 ? true : false;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 分页查问Gong
/// </summary>
public static DataTable GetTm(int pageIndex, int pageSize, out int pageCount, string whereStr, OleDbParameter[] parm)
{
try
{
string strSql = " SELECT * FROM [tm] ";
string strShow = " * ";
return AccessHelper.ExecutePager(pageIndex, pageSize, "Id", strShow, strSql, whereStr, "Id Desc ", out pageCount, parm);
}
catch (Exception e)
{
throw e;
}
}
#endregion
}
#line default
#line hidden