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);
}
