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);
}
}
public static void SetMemberShipRegManagers(MemberShipRegEmailManagersModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("MemberShipRegEmailManagers");
tableObj.GetDataFromObject(item);
string sql = $"Select 1 From MemberShipRegEmailManagers Where SiteID={item.SiteID} AND ManagerID='{item.ManagerID}'";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
if (string.IsNullOrEmpty(item.ManagerID))
{
tableObj["ManagerID"] = "";
}
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
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 SetItem(FieldValue item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("FieldValue");
tableObj.GetDataFromObject(item);
string sql = $"Select 1 From FieldValue Where FormItemID = { item.FormItemID } AND FieldID = { item.FieldID }";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Insert();
}
else
{
tableObj.Remove("FormItemID");
tableObj.Remove("FieldID");
SQLData.ParameterCollection paras = new SQLData.ParameterCollection();
paras.Add("@FormItemID", item.FormItemID);
paras.Add("@FieldID", item.FieldID);
tableObj.Update(paras);
}
}
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);
}
}
public static void SetItem(SiteLangMenuModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("SiteLangMenu");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From SiteLangMenu Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj["Sort"] = 1;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public static bool SetMailTemplateItems(MailTemplateSetModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
item.AttFiles = item.AttFiles == null ? "" : item.AttFiles;
SQLData.TableObject tableObj = db.GetTableObject("MailTemplateSet");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = $"SELECT * FROM MailTemplateSet WHERE TemplateName='{ item.TemplateName.Replace("'", "")}' ";
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("TemplateName");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = now;
tableObj.Update(item.TemplateName);
}
return(true);
}
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 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 void SetItem(ParagraphModels item)
{
item.Title = item.Title ?? string.Empty;
item.MatchType = item.MatchType ?? string.Empty;
item.Contents = item.Contents ?? string.Empty;
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Paragraph");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From Paragraph Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SourceNo");
tableObj.Update(item.ID);
}
}
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 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(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 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 bool SetRelationItem(SocialRelationModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("SocialRelations");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = $"SELECT * FROM SocialRelations WHERE ID={ item.ID } ";
string sql_sort = $"SELECT Max(Sort) FROM SocialRelations WHERE RelationType='{(int)item.RelationType}' AND SiteID={item.SiteID} ";
bool isNew = db.GetFirstValue(sql) == null;
string sortIndex = db.GetFirstValue(sql_sort).ToString();
int newSortIndex = 1;
if (!string.IsNullOrEmpty(sortIndex))
{
newSortIndex = int.Parse(sortIndex) + 1;
}
if (isNew)
{
tableObj["ID"] = item.ID;
tableObj["SocialTitle"] = GetSocialTypeTitle(item.SocialType);
tableObj["Sort"] = newSortIndex;
tableObj["LinkTitle"] = item.LinkTitle == null ? "" : item.LinkTitle;
tableObj["LinkUrl"] = item.LinkUrl == null?"":item.LinkUrl;
tableObj["Creator"] = WorkV3.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("ID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj.Remove("Sort");
tableObj["SocialTitle"] = item.SocialTitle == null ? "" : item.SocialTitle;
tableObj["LinkTitle"] = item.LinkTitle == null ? "" : item.LinkTitle;
tableObj["LinkUrl"] = item.LinkUrl == null ? "" : item.LinkUrl;
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = now;
tableObj.Update(item.ID);
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <param name="IsManually">是否手動新增</param>
public static void SetItem(PointsModel item, bool IsManually = false)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Points");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = "Select 1 From Points Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
tableObj["SiteID"] = item.SiteID;
tableObj["MemberShipID"] = item.MemberShipID;
tableObj["Remark"] = string.IsNullOrEmpty(item.Remark) ? "" : item.Remark;
tableObj["Description"] = string.IsNullOrEmpty(item.Description) ? "" : item.Description;
tableObj["Point"] = item.Point;
tableObj["IsManually"] = IsManually;
tableObj["PointType"] = item.PointType;
if (isNew)
{
if (item.Creator == 0)
{
tableObj["Creator"] = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
}
tableObj["CreateTime"] = now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
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 SetItem(MemberShipMailModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("MemberShipSendMail");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From MemberShipSendMail Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SendDate");
tableObj.Update(item.ID);
}
}
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 SetItem(FormModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Form");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From Form Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("SourceID");
tableObj.Remove("IsRemove");
tableObj.Update(item.ID);
}
}
public static void SetItem(FormItem item, bool hasCreateDate = false)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("FormItem");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
tableObj.Add("ModifyDate", now);
string sql = "Select ID, CheckStatus From FormItem Where ID = " + item.ID;
SQLData.SelectObject selectObj = db.GetSelectObject(sql);
bool isNew = selectObj.Count == 0;
if (isNew)
{
if (!hasCreateDate)
{
tableObj["CreateDate"] = now;
}
if (item.CheckStatus != (byte)FormCheckStatus.待審核)
{
tableObj["CheckDate"] = DateTime.Now;
}
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("FormID");
tableObj.Remove("CreateDate");
tableObj.Remove("SN");
tableObj.Remove("IsTemp");
tableObj.Remove("IsBack");
tableObj.Remove("CheckDate");
tableObj.Remove("CheckInDate");
if (item.CheckStatus != (byte)FormCheckStatus.待審核 && (byte)selectObj["CheckStatus"] != item.CheckStatus)
{
tableObj.Add("CheckDate", DateTime.Now);
}
tableObj.Update(item.ID);
}
}
public static void SetItem(FieldModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Field");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From Field Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
sql = "Select IsNull(Max(SN), 0) From Field Where ParentID = " + item.ParentID;
tableObj["SN"] = (int)db.GetFirstValue(sql) + 1;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("ParentID");
tableObj.Remove("SN");
tableObj.Update(item.ID);
}
}
public static void UpdatePageInfo(PagesModels page)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Pages");
tableObj.GetDataFromObject(page);
tableObj.Remove("No");
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
SQLData.ParameterCollection keys = new SQLData.ParameterCollection();
keys.Add("@No", page.No);
tableObj.Update(keys);
}
public static void SetItem(ResourceVideosModels item)
{
item.Spec = item.Spec ?? string.Empty;
item.Duration = item.Duration ?? string.Empty;
item.Screenshot = item.Screenshot ?? string.Empty;
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("ResourceVideos");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From ResourceVideos Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
string[] removeFields = { "ID", "SiteID", "SourceNo", "SourceType", "Ver", "AreaID", "Code", "Creator", "CreateTime" };
foreach (string f in removeFields)
{
tableObj.Remove(f);
}
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
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 static void SetZoneInfo(ZonesModels zone)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("Zones");
tableObj.GetDataFromObject(zone);
string sql = $"Select 1 From Zones Where No = { zone.No } AND Ver = { zone.Ver } AND SiteID = { zone.SiteID } AND PageNo = { zone.PageNo }";
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", "Ver", "SiteID", "PageNo", "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", zone.No);
keys.Add("@Ver", zone.Ver);
keys.Add("@SiteID", zone.SiteID);
keys.Add("@PageNo", zone.PageNo);
tableObj.Update(keys);
}
}
public static bool SetItem(SiteSeoSettingModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("SiteSeoSetting");
tableObj.GetDataFromObject(item);
DateTime now = DateTime.Now;
string sql = $"SELECT * FROM SiteSeoSetting 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");
if (string.IsNullOrEmpty(item.Title))
{
tableObj["Title"] = "";
}
if (string.IsNullOrEmpty(item.Description))
{
tableObj["Description"] = "";
}
if (string.IsNullOrEmpty(item.Author))
{
tableObj["Author"] = "";
}
if (string.IsNullOrEmpty(item.Copyright))
{
tableObj["Copyright"] = "";
}
if (string.IsNullOrEmpty(item.Keywords))
{
tableObj["Keywords"] = "";
}
if (string.IsNullOrEmpty(item.GA))
{
tableObj["GA"] = "";
}
if (string.IsNullOrEmpty(item.GTM))
{
tableObj["GTM"] = "";
}
if (string.IsNullOrEmpty(item.Baidu))
{
tableObj["Baidu"] = "";
}
if (string.IsNullOrEmpty(item.Alexa))
{
tableObj["Alexa"] = "";
}
if (string.IsNullOrEmpty(item.GoogleSearch))
{
tableObj["GoogleSearch"] = "";
}
if (string.IsNullOrEmpty(item.BaiduMA))
{
tableObj["BaiduMA"] = "";
}
if (string.IsNullOrEmpty(item.Bing))
{
tableObj["Bing"] = "";
}
if (string.IsNullOrEmpty(item.ExtraCode))
{
tableObj["ExtraCode"] = "";
}
tableObj["Modifier"] = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = now;
tableObj.Update(item.SiteID);
}
return(true);
}