/// <summary>
/// 获取站点个人设置信息
/// </summary>
/// <param name="SiteID"></param>
/// <param name="EditorID"></param>
/// <returns></returns>
public static DataTable GetSitePersonalSet(string SiteID, string EditorID)
{
SiteGlobalSettings SiteGlobalSet = new SiteGlobalSettings();
string sql = "select * from SitePersonalSettings where SiteID='" + SiteID + "' and EditorID='" + EditorID + "' Limit 1";
DataTable dt = SQLiteHelper.GetTable(sql);
return(dt);
}
/// <summary>
/// 获取站点全局设置信息
/// </summary>
/// <param name="SiteID"></param>
/// <returns></returns>
public static DataTable GetSiteGlobalSet(string SiteID)
{
SiteGlobalSettings SiteGlobalSet = new SiteGlobalSettings();
string sql = "select * from SiteGlobalSettings where SiteID='" + SiteID + "' Limit 1";
DataTable dt = SQLiteHelper.GetTable(sql);
if (dt.Rows.Count == 0)
{
sql = "insert into SiteGlobalSettings(SiteID,SysSuperAdmin,IsEnableRegActivate,IsHideEditorInfoForAuthor,IsHideEditorInfoForExpert,ShowNameForHide,IsStopNotLoginDownPDF,ShowMoreFlowInfoForAuthor,ShowHistoryFlowInfoForExpert,IsAutoHandle,IsStatByGroup) values('" + SiteID + "','*****@*****.**','0','1','1','','0','1','1','0','1')";
SQLiteHelper.ExeSql(sql);
}
return(dt);
}