/// <summary>
/// 取得 model 內容
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static SocialRelationModels GetRelationItem(long id)
{
SocialRelationModels item = null;
string sql = $"Select * from [SocialRelations] Where ID={id}";
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 SocialRelationModels()
{
ID = dr["ID"].ToString(),
SiteID = (long)dr["SiteID"],
RelationType = (RelationType)((int)dr["RelationType"]),
SocialType = (WorkV3.Models.MemberType)((int)dr["SocialType"]),
SocialTitle = dr["SocialTitle"].ToString(),
IsOpen = (bool)dr["IsOpen"],
ShowType = (ShowType)((int)dr["ShowType"]),
Sort = (int)dr["Sort"],
LinkTitle = dr["LinkTitle"].ToString(),
LinkUrl = dr["LinkUrl"].ToString(),
Creator = (long)dr["Creator"],
CreateTime = (DateTime)dr["CreateTime"],
Modifier = (long)dr["Modifier"],
ModifyTime = (DateTime)dr["ModifyTime"]
};
}
return(item);
}
public ActionResult ChannelEdit(long SiteID, long?DetailID)
{
AppendViewBagParameters(SiteID);
if (DetailID.HasValue)
{
SocialRelationModels item = Models.DataAccess.SocialSettingDAO.GetRelationItem(DetailID.Value);
return(View(item));
}
return(View());
}
public static void SetRelationStatus(long ID, bool IsOpen)
{
SocialRelationModels item = new SocialRelationModels();
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@ID", ID);
paraList.Add("@IsOpen", IsOpen);
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string updateSQL = " UPDATE SocialRelations SET IsOpen=@IsOpen WHERE ID=@ID ";
db.ExecuteNonQuery(updateSQL, paraList);
}
public ActionResult ChannelEdit(long SiteID, SocialRelationModels item)
{
item.SiteID = SiteID;
if (item.ID == "0")
{
item.ID = WorkLib.GetItem.NewSN().ToString();
}
bool result = Models.DataAccess.SocialSettingDAO.SetRelationItem(item);
if (result)
{
ViewBag.Exit = true;
}
AppendViewBagParameters(SiteID);
return(View(item));
}
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);
}
