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 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); }
private static List <PageCommentsModels> GetListItems(long SiteID, DataTable datas) { long? memberID = null; Member curUser = Member.Current; if (curUser != null) { memberID = curUser.ID; } int rowIndex = 0; string vPath = WorkV3.Golbal.UpdFileInfo.GetVPathBySiteID(SiteID, "Member"); MemberShipSearchModels searchModel = new MemberShipSearchModels(); searchModel.SiteID = SiteID; var memberList = Models.DataAccess.MemberShipDAO.GetItems(searchModel, 99999, 0, out rowIndex); List <PageCommentsModels> items = new List <PageCommentsModels>(); 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"]; if (item.MemberShipID.HasValue) { var m = memberList.Where(p => p.ID == item.MemberShipID.Value); if (m != null && m.Count() > 0) { item.PosterName = m.First().Name; if (!string.IsNullOrEmpty(m.First().Photo)) { if (m.First().Photo.StartsWith("http")) { item.Photo = m.First().Photo; } else { item.Photo = vPath + m.First().Photo; } } item.MemberType = m.First().MemberType.ToString(); } } //item.PosterName = memberList.Count().ToString(); 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); item.IsAddedGood = false; if (memberID.HasValue) { PageCommentLogsModels logModel = PageCommentsDAO.GetGoodLogs((long)dr["ID"], ViewModels.CommentLogType.Good, memberID.Value); if (logModel != null) { item.IsAddedGood = true; } } items.Add(item); } } return(items); }