public static MemberShipRegSocialSetModels GetSocialItem(long SiteID, int Sort, WorkV3.Models.MemberType SocialType, string SocialTitle) { string sql = $"SELECT * FROM MemberShipRegSocialSet WHERE SiteID={SiteID} AND SocialType={(int)SocialType} "; SQLData.Database db = new SQLData.Database(WebInfo.Conn); DataTable datas = db.GetDataTable(sql); DateTime now = DateTime.Now; if (datas == null || datas.Rows.Count <= 0) { MemberShipRegSocialSetModels m = new MemberShipRegSocialSetModels(); m.SiteID = SiteID; m.SocialType = SocialType; m.SocialTitle = SocialTitle; m.Sort = Sort; m.IsOpen = false; // default m.SecretKey = ""; m.AppID = ""; m.Scope = ""; m.Creator = Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id; m.CreateTime = now; m.Modifier = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id; m.ModifyTime = now; m.BackendIsOpen = false; SQLData.TableObject tableObj = db.GetTableObject("MemberShipRegSocialSet"); tableObj["SiteID"] = m.SiteID; tableObj["SocialType"] = (int)m.SocialType; tableObj["SocialTitle"] = m.SocialTitle; tableObj["IsOpen"] = m.IsOpen; tableObj["SecretKey"] = m.SecretKey; tableObj["AppID"] = m.AppID; tableObj["Scope"] = m.Scope; tableObj["Sort"] = m.Sort; tableObj["Creator"] = m.Creator; tableObj["CreateTime"] = m.CreateTime; tableObj["Modifier"] = m.Modifier; tableObj["ModifyTime"] = m.ModifyTime; tableObj["BackendIsOpen"] = m.BackendIsOpen; tableObj.Insert(); return(m); } else { DataRow dr = datas.Rows[0]; MemberShipRegSocialSetModels m = new MemberShipRegSocialSetModels(); m.SiteID = (long)dr["SiteID"]; m.SocialType = (WorkV3.Models.MemberType)((int)dr["SocialType"]); m.SocialTitle = dr["SocialTitle"].ToString(); m.IsOpen = Convert.ToBoolean(dr["IsOpen"].ToString()); m.SecretKey = dr["SecretKey"].ToString(); m.AppID = dr["AppID"].ToString(); m.Scope = dr["Scope"].ToString(); m.Sort = (int)dr["Sort"]; m.Creator = (long)dr["Creator"]; m.CreateTime = (DateTime)dr["CreateTime"]; m.Modifier = (long)dr["Modifier"]; m.ModifyTime = (DateTime)dr["ModifyTime"]; return(m); } }
public static MemberShipRegSocialSetModels GetSocialItem(long SiteID, WorkV3.Models.MemberType SocialType) { string sql = $"SELECT * FROM MemberShipRegSocialSet WHERE SiteID={SiteID} AND SocialType={(int)SocialType} "; SQLData.Database db = new SQLData.Database(WebInfo.Conn); DataTable datas = db.GetDataTable(sql); DateTime now = DateTime.Now; if (datas == null || datas.Rows.Count <= 0) { return(null); } else { DataRow dr = datas.Rows[0]; MemberShipRegSocialSetModels m = new MemberShipRegSocialSetModels(); m.SiteID = (long)dr["SiteID"]; m.SocialType = (WorkV3.Models.MemberType)((int)dr["SocialType"]); m.SocialTitle = dr["SocialTitle"].ToString(); m.IsOpen = Convert.ToBoolean(dr["IsOpen"].ToString()); m.SecretKey = dr["SecretKey"].ToString(); m.AppID = dr["AppID"].ToString(); m.Scope = dr["Scope"].ToString(); m.Sort = (int)dr["Sort"]; m.Creator = (long)dr["Creator"]; m.CreateTime = (DateTime)dr["CreateTime"]; m.Modifier = (long)dr["Modifier"]; m.ModifyTime = (DateTime)dr["ModifyTime"]; return(m); } }
public ActionResult UpdateMemberShipSocialSet(long SiteID, MemberType SocialType, bool IsOpen) { MemberShipRegSocialSetModels model = MemberShipRegSetDAO.GetSocialItem(SiteID, SocialType); bool Result = MemberShipRegSetDAO.UpdateSocialItemSet(SiteID, SocialType, IsOpen); if (Result) { return(Json("success")); } else { return(Json("fail")); } }
public static List <MemberShipRegSocialSetModels> GetSocialItems(long SiteID) { List <MemberShipRegSocialSetModels> items = new List <MemberShipRegSocialSetModels>(); string sql = $"SELECT * FROM MemberShipRegSocialSet WHERE SiteID={SiteID} And BackendIsOpen = 1 ORDER BY Sort "; SQLData.Database db = new SQLData.Database(WebInfo.Conn); DataTable datas = db.GetDataTable(sql); if (datas == null || datas.Rows.Count <= 0) { Dictionary <WorkV3.Models.MemberType, string> DefaultSocialList = new Dictionary <WorkV3.Models.MemberType, string>(); DefaultSocialList.Add(WorkV3.Models.MemberType.FB, "Facebook"); //DefaultSocialList.Add(WorkV3.Models.MemberType.Twitter, "Twitter"); Joe 20190930 尚無功能 DefaultSocialList.Add(WorkV3.Models.MemberType.Google, "Google"); //DefaultSocialList.Add(WorkV3.Models.MemberType.Yahoo, "Yahoo"); //DefaultSocialList.Add(WorkV3.Models.MemberType.Weibo, "微博"); //DefaultSocialList.Add(WorkV3.Models.MemberType.QQ, "QQ"); //DefaultSocialList.Add(WorkV3.Models.MemberType.Baidu, "百度"); int itemSort = 0; foreach (WorkV3.Models.MemberType defaultSocialKey in DefaultSocialList.Keys) { itemSort++; MemberShipRegSocialSetModels m = GetSocialItem(SiteID, itemSort, defaultSocialKey, DefaultSocialList[defaultSocialKey]); items.Add(m); } return(items); } else { foreach (DataRow dr in datas.Rows) { MemberShipRegSocialSetModels m = new MemberShipRegSocialSetModels(); m.SiteID = (long)dr["SiteID"]; m.SocialType = (WorkV3.Models.MemberType)((int)dr["SocialType"]); m.SocialTitle = dr["SocialTitle"].ToString().Trim(); m.IsOpen = Convert.ToBoolean(dr["IsOpen"].ToString()); m.Sort = Convert.ToInt32(dr["Sort"].ToString()); m.SecretKey = dr["SecretKey"].ToString().Trim(); m.AppID = dr["AppID"].ToString().Trim(); m.Scope = dr["Scope"].ToString().Trim(); m.Creator = (long)dr["Creator"]; m.CreateTime = (DateTime)dr["CreateTime"]; m.Modifier = (long)dr["Modifier"]; m.ModifyTime = (DateTime)dr["ModifyTime"]; items.Add(m); } } return(items); }
public ActionResult SetSocial(long SiteID, MemberType SocialType) { //int memberCount = 0; ViewBag.SiteID = SiteID; MemberShipRegSocialSetModels model = MemberShipRegSetDAO.GetSocialItem(SiteID, SocialType); ViewBag.SocialTitle = model.SocialTitle; //List<WorkV3.Areas.Backend.Models.MemberModels> managerList = Models.DataAccess.ManagerDAO.GetItems(99999, 1, out memberCount); //List<MemberShipRegEmailManagersModels> assignedManagerList = Models.DataAccess.MemberShipRegSetDAO.GetMemberShipRegManagers(SiteID); //var nonSelectManagers = managerList.Where(p => !assignedManagerList.Any(m => m.ManagerID == p.Id.ToString())); //if (nonSelectManagers != null) // ViewBag.Managers = nonSelectManagers.ToList(); return(View(model)); }