/// <summary>
/// 取得 model 內容
/// </summary>
/// <param name="siteID"></param>
/// <returns></returns>
public static SocialSettingModels GetItem(long siteID)
{
SocialSettingModels item = null;
string sql = $"Select * from [SocialSetting] Where SiteID={siteID}";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
if (datas != null && datas.Rows.Count > 0)
{
DataRow dr = datas.Rows[0];
item = new SocialSettingModels()
{
SiteID = (long)dr["SiteID"],
IsOpen = (bool)dr["IsOpen"],
SocialDefaultImage = dr["SocialDefaultImage"].ToString(),
IsHeaderOpenChannel = (bool)dr["IsHeaderOpenChannel"],
IsFooterOpenChannel = (bool)dr["IsFooterOpenChannel"],
IsEDMOpenChannel = (bool)dr["IsEDMOpenChannel"],
Creator = (long)dr["Creator"],
CreateTime = (DateTime)dr["CreateTime"],
Modifier = (long)dr["Modifier"],
ModifyTime = (DateTime)dr["ModifyTime"]
};
}
return(item);
}
public static bool SetItem(SocialSettingModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("SocialSetting");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = $"SELECT * FROM SocialSetting WHERE SiteID='{ item.SiteID }' ";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = now;
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = now;
tableObj.Insert();
}
else
{
tableObj.Remove("SiteID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = now;
tableObj.Update(item.SiteID);
}
return(true);
}
public ActionResult SetSocialSetting(string SiteID, string Column, bool IsChecked)
{
SocialSettingModels socialSettingModel = SocialSettingDAO.GetItem(long.Parse(SiteID));
if (socialSettingModel == null)
{
socialSettingModel = new SocialSettingModels();
socialSettingModel.SiteID = WorkLib.GetItem.NewSN();
socialSettingModel.SiteID = long.Parse(SiteID);
socialSettingModel.IsOpen = true;
socialSettingModel.SocialDefaultImage = "";
socialSettingModel.IsEDMOpenChannel = false;
socialSettingModel.IsHeaderOpenChannel = false;
socialSettingModel.IsFooterOpenChannel = false;
socialSettingModel.Creator = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
socialSettingModel.CreateTime = DateTime.Now;
socialSettingModel.Modifier = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
socialSettingModel.ModifyTime = DateTime.Now;
WorkV3.Areas.Backend.Models.DataAccess.SocialSettingDAO.SetItem(socialSettingModel);
}
if (Column == "IsOpen")
{
socialSettingModel.IsOpen = IsChecked;
}
if (Column == "IsHeaderOpenChannel")
{
socialSettingModel.IsHeaderOpenChannel = IsChecked;
}
if (Column == "IsFooterOpenChannel")
{
socialSettingModel.IsFooterOpenChannel = IsChecked;
}
if (Column == "IsEDMOpenChannel")
{
socialSettingModel.IsEDMOpenChannel = IsChecked;
}
bool Result = SocialSettingDAO.SetItem(socialSettingModel);
return(Json(Result ? "success" : "fail"));
}
public ActionResult SetSocialSettingImage(string SiteID, HttpPostedFileBase postedFile, string FileBase64)
{
SocialSettingModels socialSettingModel = SocialSettingDAO.GetItem(long.Parse(SiteID));
WorkV3.Models.ImageModel imgModel = new ImageModel();
imgModel.ID = 0;
// 新上傳的圖片
string postedFileBase64 = FileBase64;
if (postedFile == null || postedFile.ContentLength == 0)
{
socialSettingModel.SocialDefaultImage = "";
}
else
{
string saveName = WorkV3.Golbal.UpdFileInfo.SaveFilesBySiteID(postedFile, long.Parse(SiteID), customImageFolder, postedFileBase64);
imgModel.Img = saveName;
socialSettingModel.SocialDefaultImage = JsonConvert.SerializeObject(imgModel);
}
bool Result = SocialSettingDAO.SetItem(socialSettingModel);
return(Json(Result ? "success" : "fail"));
}
public ActionResult Index(long SiteID)
{
AppendViewBagParameters(SiteID);
SocialSettingModels socialSettingModel = WorkV3.Areas.Backend.Models.DataAccess.SocialSettingDAO.GetItem(SiteID);
if (socialSettingModel == null)
{
socialSettingModel = new SocialSettingModels();
socialSettingModel.SiteID = WorkLib.GetItem.NewSN();
socialSettingModel.SiteID = SiteID;
socialSettingModel.IsOpen = true;
socialSettingModel.SocialDefaultImage = "";
socialSettingModel.IsEDMOpenChannel = false;
socialSettingModel.IsHeaderOpenChannel = false;
socialSettingModel.IsFooterOpenChannel = false;
socialSettingModel.Creator = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
socialSettingModel.CreateTime = DateTime.Now;
socialSettingModel.Modifier = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
socialSettingModel.ModifyTime = DateTime.Now;
WorkV3.Areas.Backend.Models.DataAccess.SocialSettingDAO.SetItem(socialSettingModel);
}
return(View(socialSettingModel));
}
