/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static TemplatePublic Find(string m_where)
{
IDbHelper Sql = GetHelper();
TemplatePublic M = new TemplatePublic();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [ID],[GroupID],[IndexContent],[Controlcontent],[SiteSearchContent],[AdvancedSearch],[HorizontaSearch],[VerticalSearch],[RelationInfo],[MessageBoard],[Reply],[FinalDown],[DownAddress],[OLPlayaddress],[ListPager],[LoginStatus],[JSLogin],[ImageList],[AnswerList],[ChapterList],[BookChapter],[KuaiboPage],[BaiduPage],[SingleDrama] from [TemplatePublic] where " + m_where, true);
if (!Rs.Read())
{
M.Id = 0;
}
else
{
M.Id = Rs["ID"].ToInt32();
M.GroupID = Rs["GroupID"].ToInt32();
M.IndexContent = Rs["IndexContent"].ToString();
M.Controlcontent = Rs["Controlcontent"].ToString();
M.SiteSearchContent = Rs["SiteSearchContent"].ToString();
M.AdvancedSearch = Rs["AdvancedSearch"].ToString();
M.HorizontaSearch = Rs["HorizontaSearch"].ToString();
M.VerticalSearch = Rs["VerticalSearch"].ToString();
M.RelationInfo = Rs["RelationInfo"].ToString();
M.MessageBoard = Rs["MessageBoard"].ToString();
M.Reply = Rs["Reply"].ToString();
M.FinalDown = Rs["FinalDown"].ToString();
M.DownAddress = Rs["DownAddress"].ToString();
M.OLPlayaddress = Rs["OLPlayaddress"].ToString();
M.ListPager = Rs["ListPager"].ToString();
M.LoginStatus = Rs["LoginStatus"].ToString();
M.JSLogin = Rs["JSLogin"].ToString();
M.ImageList = Rs["ImageList"].ToString();
M.AnswerList = Rs["AnswerList"].ToString();
M.ChapterList = Rs["ChapterList"].ToString();
M.BookChapter = Rs["BookChapter"].ToString();
M.KuaiboPage = Rs["KuaiboPage"].ToString();
M.BaiduPage = Rs["BaiduPage"].ToString();
M.SingleDrama = Rs["SingleDrama"].ToString();
}
Rs.Close();
Rs = null;
return(M);
}
/// <summary>
/// DataTable转换为list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <TemplatePublic> DataTableToList(DataTable dt)
{
List <TemplatePublic> Ms = new List <TemplatePublic>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TemplatePublic M = new TemplatePublic();
M.Id = dt.Rows[i]["ID"].ToInt32();
M.GroupID = dt.Rows[i]["GroupID"].ToInt32();
M.IndexContent = dt.Rows[i]["IndexContent"].ToString();
M.Controlcontent = dt.Rows[i]["Controlcontent"].ToString();
M.SiteSearchContent = dt.Rows[i]["SiteSearchContent"].ToString();
M.AdvancedSearch = dt.Rows[i]["AdvancedSearch"].ToString();
M.HorizontaSearch = dt.Rows[i]["HorizontaSearch"].ToString();
M.VerticalSearch = dt.Rows[i]["VerticalSearch"].ToString();
M.RelationInfo = dt.Rows[i]["RelationInfo"].ToString();
M.MessageBoard = dt.Rows[i]["MessageBoard"].ToString();
M.Reply = dt.Rows[i]["Reply"].ToString();
M.FinalDown = dt.Rows[i]["FinalDown"].ToString();
M.DownAddress = dt.Rows[i]["DownAddress"].ToString();
M.OLPlayaddress = dt.Rows[i]["OLPlayaddress"].ToString();
M.ListPager = dt.Rows[i]["ListPager"].ToString();
M.LoginStatus = dt.Rows[i]["LoginStatus"].ToString();
M.JSLogin = dt.Rows[i]["JSLogin"].ToString();
M.ImageList = dt.Rows[i]["ImageList"].ToString();
M.AnswerList = dt.Rows[i]["AnswerList"].ToString();
M.ChapterList = dt.Rows[i]["ChapterList"].ToString();
M.BookChapter = dt.Rows[i]["BookChapter"].ToString();
M.KuaiboPage = dt.Rows[i]["KuaiboPage"].ToString();
M.BaiduPage = dt.Rows[i]["BaiduPage"].ToString();
M.SingleDrama = dt.Rows[i]["SingleDrama"].ToString();
Ms.Add(M);
}
return(Ms);
}
/// <summary>
/// 将数据插入表
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static void Insert(TemplatePublic M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [TemplatePublic]([GroupID],[IndexContent],[Controlcontent],[SiteSearchContent],[AdvancedSearch],[HorizontaSearch],[VerticalSearch],[RelationInfo],[MessageBoard],[Reply],[FinalDown],[DownAddress],[OLPlayaddress],[ListPager],[LoginStatus],[JSLogin],[ImageList],[AnswerList],[ChapterList],[BookChapter],[KuaiboPage],[BaiduPage],[SingleDrama]) values(");
sb.Append(M.GroupID.ToS());
sb.Append(",");
sb.Append("N'" + M.IndexContent + "'");
sb.Append(",");
sb.Append("N'" + M.Controlcontent + "'");
sb.Append(",");
sb.Append("N'" + M.SiteSearchContent + "'");
sb.Append(",");
sb.Append("N'" + M.AdvancedSearch + "'");
sb.Append(",");
sb.Append("N'" + M.HorizontaSearch + "'");
sb.Append(",");
sb.Append("N'" + M.VerticalSearch + "'");
sb.Append(",");
sb.Append("N'" + M.RelationInfo + "'");
sb.Append(",");
sb.Append("N'" + M.MessageBoard + "'");
sb.Append(",");
sb.Append("N'" + M.Reply + "'");
sb.Append(",");
sb.Append("N'" + M.FinalDown + "'");
sb.Append(",");
sb.Append("N'" + M.DownAddress + "'");
sb.Append(",");
sb.Append("N'" + M.OLPlayaddress + "'");
sb.Append(",");
sb.Append("N'" + M.ListPager + "'");
sb.Append(",");
sb.Append("N'" + M.LoginStatus + "'");
sb.Append(",");
sb.Append("N'" + M.JSLogin + "'");
sb.Append(",");
sb.Append("N'" + M.ImageList + "'");
sb.Append(",");
sb.Append("N'" + M.AnswerList + "'");
sb.Append(",");
sb.Append("N'" + M.ChapterList + "'");
sb.Append(",");
sb.Append("N'" + M.BookChapter + "'");
sb.Append(",");
sb.Append("N'" + M.KuaiboPage + "'");
sb.Append(",");
sb.Append("N'" + M.BaiduPage + "'");
sb.Append(",");
sb.Append("N'" + M.SingleDrama + "'");
sb.Append(")");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@Identity");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select last_insert_rowid()");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";select LAST_INSERT_ID()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select max(ID) from TemplatePublic");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.Id = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(TemplatePublic M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [TemplatePublic] set ");
sb.Append("[GroupID]=" + M.GroupID.ToS());
sb.Append(",");
sb.Append("[IndexContent]=N'" + M.IndexContent + "'");
sb.Append(",");
sb.Append("[Controlcontent]=N'" + M.Controlcontent + "'");
sb.Append(",");
sb.Append("[SiteSearchContent]=N'" + M.SiteSearchContent + "'");
sb.Append(",");
sb.Append("[AdvancedSearch]=N'" + M.AdvancedSearch + "'");
sb.Append(",");
sb.Append("[HorizontaSearch]=N'" + M.HorizontaSearch + "'");
sb.Append(",");
sb.Append("[VerticalSearch]=N'" + M.VerticalSearch + "'");
sb.Append(",");
sb.Append("[RelationInfo]=N'" + M.RelationInfo + "'");
sb.Append(",");
sb.Append("[MessageBoard]=N'" + M.MessageBoard + "'");
sb.Append(",");
sb.Append("[Reply]=N'" + M.Reply + "'");
sb.Append(",");
sb.Append("[FinalDown]=N'" + M.FinalDown + "'");
sb.Append(",");
sb.Append("[DownAddress]=N'" + M.DownAddress + "'");
sb.Append(",");
sb.Append("[OLPlayaddress]=N'" + M.OLPlayaddress + "'");
sb.Append(",");
sb.Append("[ListPager]=N'" + M.ListPager + "'");
sb.Append(",");
sb.Append("[LoginStatus]=N'" + M.LoginStatus + "'");
sb.Append(",");
sb.Append("[JSLogin]=N'" + M.JSLogin + "'");
sb.Append(",");
sb.Append("[ImageList]=N'" + M.ImageList + "'");
sb.Append(",");
sb.Append("[AnswerList]=N'" + M.AnswerList + "'");
sb.Append(",");
sb.Append("[ChapterList]=N'" + M.ChapterList + "'");
sb.Append(",");
sb.Append("[BookChapter]=N'" + M.BookChapter + "'");
sb.Append(",");
sb.Append("[KuaiboPage]=N'" + M.KuaiboPage + "'");
sb.Append(",");
sb.Append("[BaiduPage]=N'" + M.BaiduPage + "'");
sb.Append(",");
sb.Append("[SingleDrama]=N'" + M.SingleDrama + "'");
sb.Append(" where Id='" + M.Id + "'");
sb.Append("");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@ROWCOUNT");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";SELECT ROW_COUNT()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select SQL%ROWCOUNT");
}
return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32());
}
public static TemplatePublic CreateTemplatePublic(int id)
{
TemplatePublic templatePublic = new TemplatePublic();
templatePublic.ID = id;
return templatePublic;
}
public void AddToTemplatePublic(TemplatePublic templatePublic)
{
base.AddObject("TemplatePublic", templatePublic);
}
