public static void SetItem(SEOModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("SEO");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From SEO Where SourceNo = " + item.SourceNo;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Add("Creator", WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id);
tableObj.Add("CreateTime", DateTime.Now);
tableObj.Insert();
}
else
{
tableObj.Remove("SourceNo");
tableObj.Remove("MenuID");
tableObj.Add("Modifier", WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id);
tableObj.Add("ModifyTime", DateTime.Now);
tableObj.Update(item.SourceNo);
}
}
/// <summary>
/// 檢查是否已投過票, 依 IP 及 MemberID (若非 NULL 時) 目前限制為 10 分鐘, return: true 已投過, 時效未過 | false: 未投過或時效已過
/// </summary>
/// <param name="commentID"></param>
/// <param name="LogType"></param>
/// <param name="MemberID"></param>
/// <returns></returns>
public static bool IsAddGoodLogOverTime(long commentID, ViewModels.CommentLogType LogType, long?MemberID)
{
//因應 cc 所提, 先不限制時間, 故 always false 2018-04-18 charlie_shan
return(false);
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string AddCol = "";
SQLData.ParameterCollection paras = new SQLData.ParameterCollection();
paras.Add("@CommentID", commentID);
paras.Add("@LogType", (int)LogType);
paras.Add("@IP", WorkLib.GetItem.IPAddr());
if (MemberID.HasValue)
{
AddCol = " AND MemberShipID=@MemberShipID ";
paras.Add("@MemberShipID", MemberID.Value);
}
string sql = string.Format(@" SELECT TOP 1 * FROM PageCommentLogs WHERE CommentID=@CommentID AND LogType=@LogType AND IP=@IP {0} Order By AddTime DESC "
, AddCol);
DataTable logTable = db.GetDataTable(sql, paras);
if (logTable == null || logTable.Rows.Count <= 0)
{
return(false);
}
DateTime LastAddTime = DateTime.Parse(logTable.Rows[0]["AddTime"].ToString());
if (DateTime.Now.Subtract(LastAddTime).TotalMinutes > 10)
{
return(false);
}
return(true);
}
public static List <PageCommentsModels> GetItems(long SiteID, string PageSN, int pageIndex, int rowCount, out int totalRecord)
{
List <PageCommentsModels> itemList = new List <PageCommentsModels>();
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string query = $"Select Count(1) From PageComments Where PageSN='{PageSN.Replace("'", "")}' AND ShowStatus=1 AND ParentID IS NULL ";
DataTable countTable = db.GetDataTable(query);
totalRecord = 0;
if (countTable == null || countTable.Rows.Count <= 0)
{
return(itemList);
}
if (string.IsNullOrEmpty(countTable.Rows[0][0].ToString()))
{
return(itemList);
}
totalRecord = int.Parse(countTable.Rows[0][0].ToString());
string cond = $" PageSN='{PageSN.Replace("'", "")}' AND ShowStatus=1 AND ParentID IS NULL ";
string orderby = " Order By PostDate ASC ";
string sql =
$"Select TOP {rowCount} * From PageComments Where {cond} AND ID NOT IN (SELECT TOP {pageIndex * rowCount} ID FROM PageComments Where {cond} {orderby}) {orderby} ";
DataTable datas = db.GetDataTable(sql);
itemList = GetListItems(SiteID, datas);
return(itemList);
}
public static List <SysLogModels> GetAll()
{
List <SysLogModels> items = new List <SysLogModels>();
string sql = "SELECT s.*,m.LoginID as MemberLoginID,m.Name as MemberName,n.Title as MenuTitle FROM SysLog s JOIN Member m ON s.MemberID=m.ID LEFT JOIN Menus n ON n.ID=s.MenuID ";
sql += " ORDER BY s.AddTime DESC ";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
foreach (DataRow dr in datas.Rows)
{
SysLogModels m = new SysLogModels();
m.Id = (long)dr["ID"];
m.MemberID = (long)dr["MemberID"];
m.MemberName = dr["MemberName"].ToString().Trim();
m.MemberLoginID = dr["MemberLoginID"].ToString().Trim();
m.MgrNo = Convert.ToByte(dr["MgrNo"]);
m.MgrNoName = ((SysMgrNoName)Convert.ToByte(dr["MgrNo"])).ToString();
m.Actions = Convert.ToByte(dr["Actions"]);
m.ActionsName = ((SysActionsName)Convert.ToByte(dr["Actions"])).ToString();
m.MenuID = Convert.ToInt64(m.MenuID ?? 0);
m.MenuTitle = dr["MenuTitle"].ToString().Trim();
m.ReMark = dr["ReMark"].ToString().Trim();
m.AddTime = (DateTime)dr["AddTime"];
m.IP = dr["IP"].ToString().Trim();
items.Add(m);
}
return(items);
}
public static void SetItem(PageCommentsModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("PageComments");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = "Select 1 From PageComments Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["ModifyTime"] = now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("PageSN");
tableObj.Remove("ParentID");
tableObj.Remove("PostDate");
tableObj.Remove("ShowStatus");
tableObj.Remove("MemberShipID");
Common.Member curUser = Common.Member.Current;
tableObj["Modifier"] = curUser == null ? Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id : curUser.ID;
tableObj["ModifyTime"] = now;
tableObj.Update(item.ID);
}
}
public static void SaveInfo(MenusModels data)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject TableObj = db.GetTableObject("Menus");
//TableObj.GetDataFromObject(data);
TableObj.Add("Title", data.Title);
TableObj.Add("ShowStatus", data.ShowStatus);
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
if (data.ID == 0)
{
TableObj.Add("ID", GetItem.NewSN());
TableObj.Add("SN", data.SN);
TableObj.Add("SiteID", data.SiteID);
TableObj.Add("AreaID", data.AreaID);
TableObj.Add("ParentID", data.ParentID);
TableObj.Add("DataType", data.DataType);
TableObj.Add("Sort", data.Sort);
TableObj.Add("Creator", MemberDAO.SysCurrent.Id);
TableObj.Add("CreateTime", DateTime.Now.ToString(WebInfo.DateTimeFmt));
TableObj.Insert();
}
else
{
TableObj.Add("Modifier", MemberDAO.SysCurrent.Id);
TableObj.Add("ModifyTime", DateTime.Now.ToString(WebInfo.DateTimeFmt));
para.Add("@ID", data.ID);
TableObj.Update(para);
}
}
public JsonResult RefreshLoginInfo()
{
ViewBag.UploadUrl = uploadUrl;
MemberModels mem = MemberDAO.SysCurrent;
string sql = "select * from Member where LoginID=@ID";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.SelectObject selMem = db.GetSelectObject(sql, new SQLData.ParameterCollection("@ID", mem.LoginID));
if (selMem != null)
{
MemberModels member = new MemberModels
{
Id = long.Parse(selMem["Id"].ToString()),
isSysOnly = bool.Parse(selMem["isSysOnly"].ToString()),
LoginID = selMem["LoginID"].ToString(),
Name = selMem["Name"].ToString(),
Img = selMem["Img"].ToString(),
GroupId = long.Parse(selMem["GroupId"].ToString()),
Email = selMem["Email"].ToString()
};
string sessionID = Request.Cookies["sessionId"].Value;
Session[sessionID] = member;
return(Json("success"));
}
else
{
return(Json("fail"));
}
}
public static List <ResourceFilesModels> GetInfoAll(long SiteID, long SourceNo, long SourceType, int AreaID, int Ver)
{
string Sql = "Select * From ResourceFiles Where SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
para.Add("@SiteID", SiteID);
para.Add("@SourceNo", SourceNo);
para.Add("@SourceType", SourceType);
para.Add("@Ver", Ver);
para.Add("@AreaID", AreaID);
DataTable dt = db.GetDataTable(Sql, para);
List <ResourceFilesModels> nLists = new List <ResourceFilesModels>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ResourceFilesModels _TempRow = new ResourceFilesModels();
_TempRow = CreateData(dt.Rows[i]);
nLists.Add(_TempRow);
}
}
return(nLists);
}
public static void SetItem(ArticleModels item, int cardStyleID = 1)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Article");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From Article Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
MenusModels menu = MenusDAO.GetInfo(item.SiteID, item.MenuID);
long cardNo = WorkV3.Golbal.PubFunc.AddPage(item.SiteID, item.MenuID, menu.SN, "Article", "Content", true, item.Title, CardStyleId: cardStyleID);
tableObj["CardNo"] = cardNo;
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj["Sort"] = 1;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("MenuID");
tableObj.Remove("CardNo");
tableObj.Remove("Clicks");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public static ResourceFilesModels GetInfo(long SiteID, long SourceNo, byte SourceType, int AreaID, long Id, int Ver)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string Sql = "Select * From ResourceFiles Where Id=@Id and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID";
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
para.Add("@ID", Id);
para.Add("@SiteID", SiteID);
para.Add("@SourceNo", SourceNo);
para.Add("@SourceType", SourceType);
para.Add("@Ver", Ver);
para.Add("@AreaID", AreaID);
DataTable dt = db.GetDataTable(Sql, para);
ResourceFilesModels _TempRow = null;
if (dt.Rows.Count > 0)
{
_TempRow = new ResourceFilesModels();
_TempRow = CreateData(dt.Rows[0]);
}
return(_TempRow);
}
/// <summary>
/// 新增檔案選單
/// </summary>
/// <param name="data"></param>
public static void Save_Menu(ResourceFilesModels data)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string Sql =
"IF EXISTS (SELECT 1 FROM ResourceFiles WHERE ID=@ID and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID)" +
" UPDATE ResourceFiles SET FileType=@FileType, FileInfo=@FileInfo, FileSize=@FileSize, FileMimeType=@FileMimeType, Descriptions=@Descriptions, Detail=@Detail, ClickType=@ClickType, Modifier=@Modifier, ModifyTime=GetDate() WHERE ID=@ID and SiteID=@SiteID and SourceNo=@SourceNo and SourceType=@SourceType and Ver=@Ver and AreaID=@AreaID" +
" ELSE" +
" INSERT INTO ResourceFiles(ID,SiteID,SourceNo, SourceType,Ver,AreaID,FileType,FileInfo,FileSize,FileMimeType,Descriptions,Detail,ClickType,Creator,CreateTime)VALUES(@ID,@SiteID,@SourceNo,@SourceType,@Ver,@AreaID,@FileType,@FileInfo,@FileSize,@FileMimeType,@Descriptions,@Detail,@ClickType,@Creator,GetDate())";
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
para.Add("@ID", data.Id);
para.Add("@SiteID", data.SiteID);
para.Add("@SourceNo", data.SourceNo);
para.Add("@SourceType", data.SourceType);
para.Add("@Ver", data.Ver);
para.Add("@AreaID", data.AreaID);
para.Add("@FileType", data.FileType);
para.Add("@FileInfo", data.FileInfo);
para.Add("@FileSize", data.FileSize);
para.Add("@FileMimeType", data.FileMimeType);
para.Add("@Descriptions", data.Descriptions);
para.Add("@Detail", data.Detail);
para.Add("@ClickType", data.ClickType);
para.Add("@Creator", MemberDAO.SysCurrent.Id);
para.Add("@Modifier", MemberDAO.SysCurrent.Id);
db.ExecuteNonQuery(Sql, para);
}
public static void WriteReadLog(long mailId, long formItemId)
{
string sql = $"Update FormMailLog Set ReadDate = GetDate() Where MailID = { mailId } AND FormItemID = { formItemId } AND ReadDate Is Null";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
public static void WriteLog(long mailId, long formItemId)
{
string sql = $"Insert FormMailLog(MailID, FormItemID) Values({ mailId }, { formItemId })";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
public static IEnumerable <string> GetKeywords(long siteId, long menuId)
{
string sql = $"SELECT MenuID, Keywords FROM SEO Where Keywords <> '' AND MenuID IN (SELECT ID FROM Menus WHERE SiteID = { siteId })";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
Dictionary <string, int> wordList = new Dictionary <string, int>();
foreach (DataRow dr in datas.Rows)
{
long mId = (long)dr["MenuID"];
string[] words = dr["Keywords"].ToString().Trim().Split(';');
foreach (string w in words)
{
if (!wordList.ContainsKey(w))
{
wordList[w] = 0;
}
wordList[w] += (mId == menuId ? 3 : 2);
}
}
return(wordList.OrderByDescending(w => w.Value).Select(w => w.Key));
}
public static void SetItem(IntraIPlimitModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("IntraIPlimit");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From IntraIPlimit Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["OpenStatus"] = item.OpenStatus == OpenStatus.Open ? 1 : 0;
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public static Dictionary <long, List <ArticleTypesModels> > GetItemTypes(IEnumerable <long> itemIds)
{
Dictionary <long, List <ArticleTypesModels> > types = new Dictionary <long, List <ArticleTypesModels> >();
if (itemIds == null || itemIds.Count() == 0)
{
return(types);
}
string sql = "SELECT I.ArticleID, I.TypeID, T.Name FROM ArticleToType I JOIN ArticleTypes T ON I.TypeID = T.ID WHERE I.ArticleID IN ({0}) ORDER BY T.Sort";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(string.Format(sql, string.Join(", ", itemIds)));
foreach (DataRow dr in datas.Rows)
{
long articleId = (long)dr["ArticleID"];
List <ArticleTypesModels> articleTypes;
if (!types.TryGetValue(articleId, out articleTypes))
{
articleTypes = new List <ArticleTypesModels>();
types.Add(articleId, articleTypes);
}
articleTypes.Add(new ArticleTypesModels {
ID = (long)dr["TypeID"],
Name = dr["Name"].ToString().Trim()
});
}
return(types);
}
public static void Save_Single(MenusModels data)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject TableObj = db.GetTableObject("Menus");
TableObj.Add("Title", data.Title);
//TableObj.Add("ParentID", data.ParentID);
TableObj.Add("ShowStatus", data.ShowStatus);
//TableObj.Add("Sort", data.Sort);
TableObj.Add("Modifier", MemberDAO.SysCurrent.Id);
TableObj.Add("ModifyTime", DateTime.Now.ToString(WebInfo.DateTimeFmt));
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
para.Add("@ID", data.ID);
TableObj.Update(para);
PagesModels mPage = PagesDAO.GetPageInfo(data.SiteID, data.ID);
if (mPage != null)
{
mPage.Title = data.Title;
PagesDAO.SetPageInfo(mPage);
}
}
public static void SetCardInfo(CardsModels card)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Cards");
tableObj.GetDataFromObject(card);
string sql = $"Select 1 From Cards Where No = { card.No } AND Lang = '{ card.Lang.Replace("'", "''") }' AND Ver = { card.Ver }";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
string[] removeFields = { "No", "Lang", "Ver", "Creator", "CreateTime" };
foreach (string field in removeFields)
{
tableObj.Remove(field);
}
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
SQLData.ParameterCollection keys = new SQLData.ParameterCollection();
keys.Add("@No", card.No);
keys.Add("@Lang", card.Lang);
keys.Add("@Ver", card.Ver);
tableObj.Update(keys);
}
}
public static void SetItem(ArticleIntroModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("ArticleIntro");
item.Icon = item.Icon ?? string.Empty;
item.RemarkText = item.RemarkText ?? string.Empty;
tableObj.GetDataFromObject(item);
string sql = "Select 1 From ArticleIntro Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
long cardNo = WorkV3.Models.DataAccess.MenusDAO.GetFirstCardNo(item.MenuID, "ArticleIntro") ?? 0;
tableObj.Add("CardNo", cardNo);
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("MenuID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj.Update(item.ID);
}
}
public static void SetItem(ResourceImagesModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("ResourceImages");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From ResourceImages Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Insert();
}
else
{
string[] removeFields = { "ID", "SiteID", "SourceNo", "SourceType", "Ver", "AreaID", "Creator", "CreateTime" };
foreach (string f in removeFields)
{
tableObj.Remove(f);
}
SQLData.ParameterCollection keys = new SQLData.ParameterCollection();
keys.Add("@ID", item.ID);
keys.Add("@SiteID", item.SiteID);
keys.Add("@SourceNo", item.SourceNo);
keys.Add("@SourceType", item.SourceType);
keys.Add("@Ver", item.Ver);
keys.Add("@AreaID", item.AreaID);
tableObj.Update(keys);
}
}
public JsonResult UploadPersonPhotoFile(HttpPostedFileBase File)
{
if (File != null && File.ContentLength > 0)
{
string Path = string.Format("{0}/{1}", GetItem.UpdPath(), "Manager");
if (!System.IO.Directory.Exists(Path))
{
System.IO.Directory.CreateDirectory(Path);
}
string saveName = WorkV3.Golbal.UpdFileInfo.SaveFiles(File, Path);
MemberModels mem = MemberDAO.SysCurrent;
string sql = "UPDATE Member SET Img=@Img WHERE LoginID=@ID";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@ID", mem.LoginID);
paraList.Add("@Img", saveName);
int exeCount = db.ExecuteNonQuery(sql, paraList);
if (exeCount > 0)
{
return(Json("success"));
}
}
return(Json("fail"));
}
public static void SetItem(ArticlePosterModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("ArticlePoster");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From ArticlePoster Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("MenuID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public static void Click(long id)
{
string sql = "Update MainVision Set Clicks = Clicks + 1 Where ID = " + id;
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
public long MenuAddPage(long SiteID, long MenuID, long MenuSN, string Title, bool appendIdToName = false)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
long NewPageNO = GetItem.NewSN();
string sql =
"INSERT Pages(No,Lang,Ver,SiteID,MenuID,SN,Title,ShowStatus,PublishStatus,Creator,CreateTime) VALUES(@No,@Lang,@Ver,@SiteID,@MenuID,@SN,@Title,@ShowStatus,@PublishStatus,@Creator,Getdate());\n";
SQLData.ParameterCollection para = new SQLData.ParameterCollection();
para.Add("@No", NewPageNO);
para.Add("@Lang", "zh-tw");
para.Add("@Ver", 1);
para.Add("@MenuID", MenuID);
para.Add("@SiteID", SiteID);
para.Add("@SN", MenuSN);
para.Add("@PublishStatus", 1);
para.Add("@ShowStatus", 1);
db.ExecuteNonQuery(sql, para);
if (appendIdToName)
{
sql = " Update Pages Set SN = SN + '_'+ NO Where No = @NO ;\n";
}
SQLData.ParameterCollection para2 = new SQLData.ParameterCollection();
para2.Add("@No", NewPageNO);
db.ExecuteNonQuery(sql, para2);
return(NewPageNO);
}
public static Models.PageCommentLogsModels GetGoodLogs(long commentID, ViewModels.CommentLogType LogType, long MemberID)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.ParameterCollection paras = new SQLData.ParameterCollection();
paras.Add("@CommentID", commentID);
paras.Add("@MemberShipID", MemberID);
paras.Add("@LogType", (int)LogType);
string sql = @" SELECT * FROM PageCommentLogs WHERE CommentID=@CommentID AND MemberShipID=@MemberShipID AND LogType=@LogType";
DataTable logTable = db.GetDataTable(sql, paras);
if (logTable != null && logTable.Rows.Count > 0)
{
DataRow dr = logTable.Rows[0];
PageCommentLogsModels item = new PageCommentLogsModels();
item.ID = long.Parse(dr["ID"].ToString());
item.CommentID = long.Parse(dr["CommentID"].ToString());
item.MemberShipID = long.Parse(dr["MemberShipID"].ToString());
item.LogType = int.Parse(dr["LogType"].ToString());
item.Browser = dr["Browser"].ToString().Trim();
item.UserAgent = dr["UserAgent"].ToString().Trim();
item.IP = dr["IP"].ToString().Trim();
item.IPNum = dr["IPNum"].ToString().Trim();
item.AddTime = (DateTime)dr["AddTime"];
return(item);
}
return(null);
}
public static void WriteLog(long mailId, long memberId)
{
string sql = $"Insert MemberShipSendMailLog(MailID, MemberShipID) Values({ mailId }, { memberId })";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
public static bool DeleteItem(long ID)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string sql = $"DELETE PageComments Where ID = {ID}";
return(db.ExecuteNonQuery(sql) > 0);
}
public static void WriteReadLog(long mailId, long memberId)
{
string sql = $"Update MemberShipSendMailLog Set ReadDate = GetDate() Where MailID = { mailId } AND MemberShipID = { memberId } AND ReadDate Is Null";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
public static PageCommentsModels GetSingleItem(long SiteID, string ID)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string cond = $" ID='{ID.Replace("'", "")}' AND ShowStatus=1 ";
string sql =
$"Select * From PageComments Where {cond} ";
DataTable datas = db.GetDataTable(sql);
if (datas != null)
{
foreach (DataRow dr in datas.Rows)
{
PageCommentsModels item = new PageCommentsModels();
item.ID = long.Parse(dr["ID"].ToString());
item.CommentID = dr["ID"].ToString();
item.PageSN = dr["PageSN"].ToString();
item.ParentID = string.IsNullOrEmpty(dr["ParentID"].ToString()) ? (long?)null : (long)dr["ParentID"];
item.Title = dr["Title"].ToString().Trim();
item.PosterName = dr["PosterName"].ToString().Trim();
item.PostDate = (DateTime)dr["PostDate"];
item.PostDateDiff = GetDateDiffNow(item.PostDate);
item.ShowStatus = Convert.ToBoolean(dr["ShowStatus"].ToString());
item.MemberShipID = string.IsNullOrEmpty(dr["MemberShipID"].ToString()) ? (long?)null : (long)dr["MemberShipID"];
item.CommentContent = dr["CommentContent"].ToString().Trim();
item.IP = dr["IP"].ToString().Trim();
item.IPNum = dr["IPNum"].ToString().Trim();
item.GoodCount = int.Parse(dr["GoodCount"].ToString());
item.Modifier = string.IsNullOrEmpty(dr["Modifier"].ToString()) ? (long?)null : (long)dr["Modifier"];
item.ModifyTime = (DateTime)dr["ModifyTime"];
item.ChildCommentList = GetChildItems(SiteID, item.ID);
return(item);
}
}
return(null);
}
public static void SetItem(AdsStatisticsLabelsModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("AdsStatisticsLabels");
tableObj.GetDataFromObject(item);
bool isNew = false;
string sql = "Select 1 From AdsStatisticsLabels Where ID = " + item.ID;
isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Title"] = item.Title;
tableObj["LabelDate"] = item.LabelDate;
tableObj["LabelColor"] = item.LabelColor;
tableObj["ShowStatus"] = item.ShowStatus;
tableObj["Creator"] = item.Creator;
tableObj["CreateTime"] = item.CreateTime;
tableObj.Insert();
}
else
{
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Title"] = item.Title;
tableObj["LabelDate"] = item.LabelDate;
tableObj["ShowStatus"] = item.ShowStatus;
tableObj["LabelColor"] = item.LabelColor;
tableObj["Modifier"] = item.Modifier;
tableObj["ModifyTime"] = item.ModifyTime;
tableObj.Update(item.ID);
}
}
