public WebTags(_DbHelper c)
{
conn = c;
SettingData setData = new SettingData(conn);
this._setting = setData.GetSetting();
this._theme = setData.GetTheme;
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="sql">SQL</param>
public DataSet ExecSql(string sql)
{
DataSet result = new DataSet();
using (_DbHelper conn = new _DbHelper(_conn))
{
conn.Open();
try { result = conn.ExecuteDataSet(sql); }
catch (Exception err) { throw err; }
finally { conn.Close(); }
}
return result;
}
/// <summary>
/// 析构函数
/// </summary>
public XsltTemplate(_DbHelper c)
{
watch.Start();
conn = c;
_argList = new XsltArgumentList();
_argList.AddExtensionObject("roclog:function", new _ALFun(conn));
_argList.AddExtensionObject("sys:fun", new _ALFun(conn));
//扩展部分
foreach (object type in new SiteExpand().GetTypes(typeof(ITemplateFun).FullName))
{
ITemplateFun iae = ((ITemplateFun)type);
_argList.AddExtensionObject(string.Format("expand:{0}", iae.URI), iae);
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="sqls">SQL</param>
public int ExecSql(string[] sqls)
{
int result = 0;
using (_DbHelper conn = new _DbHelper(_conn))
{
conn.Open();
conn.BeginTransaction();
try
{
foreach (string sql in sqls)
{
result += conn.ExecuteNonQuery(sql);
}
conn.Commit();
}
catch (Exception err) { conn.Rollback(); throw err; }
finally { conn.Close(); }
}
return result;
}
public CommentUI(_DbHelper c)
{
conn = c;
}
public ServiceComment(_DbHelper c)
{
conn = c;
}
public TrackbackLogData(_DbHelper c)
{
conn = c;
}
public AttachmentData(_DbHelper c)
{
conn = c;
}
public AdminTag(_DbHelper c)
{
conn = c;
}
public AdminTheme(_DbHelper c)
{
conn = c;
}
public ServiceRss(_DbHelper c)
{
conn = c;
}
/// <summary>
/// 设置连接时的初始化工作
/// </summary>
private static void initConn()
{
using (_DbHelper conn = new _DbHelper(_conn))
{
conn.Open();
conn.BeginTransaction();
try
{
if (Convert.ToInt32(conn.ExecuteScalar("SELECT COUNT([ID]) FROM [Setting]")) == 0)
{
Dictionary<string, object> vals = new Dictionary<string, object>();
vals.Add("Name", "'我的网站'");
vals.Add("URL", "'http://www.GF.com/'");
vals.Add("ICP", "'备案号'");
vals.Add("Language", "'zh-CN'");
vals.Add("Theme", "'Amarketer-blue'");
vals.Add("Intro", "'我的个人网站'");
vals.Add("Keywords", "''");
vals.Add("Affiche", "'无'");
vals.Add("Filter", "'你妈,我操,日你,贱人,打飞机,干你'");
vals.Add("UploadExt", "'.ZIP,.RAR,.PNG,.JPG,.GIF'");
vals.Add("Mail", "''");
vals.Add("MailFrom", "''");
vals.Add("MailHost", "''");
vals.Add("MailPort", 0);
vals.Add("MailUID", "''");
vals.Add("MailPWD", "''");
vals.Add("WatermarkSeat", 0);
vals.Add("ParArticleNum", 8);
vals.Add("ParCommentNum", 10);
vals.Add("ParAppendFineArticleNum", 5);
vals.Add("ParAppendRandomArticleNum", 5);
vals.Add("ParAppendHotArticleNum", 5);
vals.Add("ParAppendHotTagNum", 10);
vals.Add("ParAppendNewCommentNum", 5);
vals.Add("RssNum", 50);
vals.Add("RssMode", 0);
vals.Add("WatermarkPath", "'Common/Images/Watermark.png'");
vals.Add("Key", "''");
string fields = string.Empty;
string values = string.Empty;
foreach (KeyValuePair<string, object> pair in vals)
{
fields = fields + string.Format("[{0}],", pair.Key);
values = values + string.Format("{0},", pair.Value);
}
fields = fields.Substring(0, fields.Length - 1);
values = values.Substring(0, values.Length - 1);
conn.ExecuteNonQuery(string.Format("INSERT INTO [Setting] ({0}) VALUES ({1})", fields, values));
}
conn.Commit();
}
catch (Exception err) { conn.Rollback(); throw err; }
conn.Close();
}
}
public AdminComment(_DbHelper c)
{
conn = c;
}
public AdminTrackback(_DbHelper c)
{
conn = c;
}
public PostData(_DbHelper c)
{
conn = c;
}
public ServicePost(_DbHelper c)
{
conn = c;
}
public _AdminBase(_DbHelper c)
{
conn = c;
}
public AdminUser(_DbHelper c)
{
conn = c;
}
public ServiceTag(_DbHelper c)
{
conn = c;
}
public AdminSetting(_DbHelper c)
{
conn = c;
}
public ServiceTrackback(_DbHelper c)
{
conn = c;
}
public MyTagData(_DbHelper c)
{
conn = c;
}
public UserData(_DbHelper c)
{
conn = c;
}
public AdminDB(_DbHelper c)
{
conn = c;
}
public _AdminUpload(_DbHelper c)
{
conn = c;
}
/// <summary>
/// 执行SQL并返回第一行第一列的数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public object ExeSqlScalar(string sql)
{
object result = new object();
using (_DbHelper conn = new _DbHelper(_conn))
{
conn.Open();
result = conn.ExecuteScalar(sql);
conn.Close();
}
return result;
}
public ColumnData(_DbHelper c)
{
conn = c;
}
public SettingData(_DbHelper c)
{
conn = c;
}
public _WebBaseXml(_DbHelper c)
{
conn = c;
}
public AdminColumn(_DbHelper c)
{
conn = c;
}
