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