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