public static void SetItem(ArticleSetModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("ArticleSet");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From ArticleSet Where CardNo = " + item.CardNo;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("CardNo");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.CardNo);
}
}
public string GetFirstImg(ArticleSetModels setting)
{
if (CustomIcon && !string.IsNullOrWhiteSpace(Icon))
{
ResourceImagesModels img = Newtonsoft.Json.JsonConvert.DeserializeObject <ResourceImagesModels>(Icon);
if (!string.IsNullOrWhiteSpace(img?.Img))
{
return(img.Img);
}
}
string paragraphImg = ParagraphDAO.GetFirstImage(ID);
if (!string.IsNullOrWhiteSpace(paragraphImg))
{
return(paragraphImg);
}
if (!string.IsNullOrWhiteSpace(setting?.DefaultImg))
{
ResourceImagesModels img = Newtonsoft.Json.JsonConvert.DeserializeObject <ResourceImagesModels>(setting.DefaultImg);
if (!string.IsNullOrWhiteSpace(img?.Img))
{
return(img.Img);
}
}
return(null);
}
public static List <ArticleModels> GetItems(ArticleSetModels articleSet, int pageIndex = 1)
{
string sql =
"Select ID, SiteID, CardNo, Type, Title, Link, IsOpenNew, Archive, IssueDate, CustomIcon, Icon, IsShowVideo, VideoID, " +
"(SELECT TOP(1) Contents FROM Paragraph WHERE SourceNo = A.ID AND Contents <> '' ORDER BY Sort) Summary " +
"From Article A Where {0} Order By {1}";
List <string> where = new List <string>();
where.Add("IsIssue = 1 And MenuID > 0"); // 去除掉模板
List <string> orSql = new List <string>();
IEnumerable <long> menus = articleSet.GetMenus();
if (menus?.Count() > 0)
{
orSql.Add($"MenuID In ({ string.Join(", ", menus) })");
}
IEnumerable <long> types = articleSet.GetTypes();
if (types?.Count() > 0)
{
orSql.Add($"ID IN (Select ArticleID From ArticleToType Where TypeID In ({ string.Join(", ", types) }))");
}
if (orSql.Count > 0)
{
where.Add($"({ string.Join(" OR ", orSql) })");
}
IEnumerable <int> issueSetting = articleSet.GetIssueSetting();
if (issueSetting.Count() == 1)
{
if (issueSetting.Contains(0))
{
where.Add("(IssueStart IS NULL OR IssueStart <= GETDATE()) AND (IssueEnd IS NULL OR IssueEnd >= GETDATE())");
}
else
{
where.Add("IssueEnd <= GETDATE()");
}
}
string whereSql = string.Join(" AND ", where);
sql = string.Format(sql, whereSql, articleSet.SortField);
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
int totalRecord;
DataTable datas = db.GetPageData(sql, articleSet.PageSize, pageIndex, out totalRecord);
return(GetListItems(datas));
}
public ActionResult Next(long siteId, long cardNo, int style, int pageIndex)
{
ArticleSetModels setting = ArticleSetDAO.GetItem(cardNo);
ViewBag.Setting = setting;
IEnumerable <ArticleModels> items = ArticleDAO.GetItems(setting, pageIndex);
ViewBag.ItemPages = CardsDAO.GetPages(items.Select(item => item.CardNo));
ViewBag.ItemTypes = ArticleDAO.GetItemTypes(items.Select(item => item.ID));
// style = 2;
return(View("NextStyle" + style, items));
}
public ActionResult Index(CardsModels model)
{
ArticleSetModels setting = ArticleSetDAO.GetItem(model.No);
ViewBag.Setting = setting;
IEnumerable <ArticleModels> items = ArticleDAO.GetItems(setting);
ViewBag.ItemPages = CardsDAO.GetPages(items.Select(item => item.CardNo));
ViewBag.ItemTypes = ArticleDAO.GetItemTypes(items.Select(item => item.ID));
ViewBag.SiteID = model.SiteID;
int style = model.StylesID == 0 ? 1 : model.StylesID;
// style = 3;
return(View("Style" + style, items));
}
public ActionResult Setting(long cardNo)
{
SitePage page = CardsDAO.GetPage(cardNo);
SettingInit(cardNo, page);
ArticleSetModels item = ArticleSetDAO.GetItem(cardNo);
if (item == null)
{
item = new ArticleSetModels {
PagingMode = "點擊看更多",
PageSize = 10,
IssueSetting = "0", // 刊登期間內的當期資料
SortMode = "時間排序"
};
}
return(View(item));
}
public ActionResult Setting(long cardNo, ArticleSetModels item)
{
SitePage page = CardsDAO.GetPage(cardNo);
SettingInit(cardNo, page);
if (item.SortMode == "隨機排序")
{
item.SortField = "NewID()";
}
if (!string.IsNullOrWhiteSpace(item.DefaultImg))
{
ResourceImagesModels imgModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ResourceImagesModels>(item.DefaultImg);
if (imgModel.ID == 0) // 新上傳的圖片
{
HttpPostedFileBase postedFile = Request.Files["fDefaultImg"];
if (postedFile == null || postedFile.ContentLength == 0)
{
item.DefaultImg = string.Empty;
}
else
{
string saveName = WorkV3.Golbal.UpdFileInfo.SaveFilesByMenuID(postedFile, page.SiteID, page.MenuID);
imgModel.ID = 1;
imgModel.Img = saveName;
item.DefaultImg = Newtonsoft.Json.JsonConvert.SerializeObject(imgModel);
}
}
}
ArticleSetDAO.SetItem(item);
ViewBag.Success = true;
return(View(item));
}
