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 static bool UpdateSocialItemSort(long SiteID, WorkV3.Models.MemberType socialType, int sort)
{
string sql = $"UPDATE MemberShipRegSocialSet SET Sort={sort} WHERE SiteID={SiteID} AND SocialType={(int)socialType};";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
return(true);
}
public static bool UpdateSocialItemSet(long SiteID, WorkV3.Models.MemberType socialType, bool isOpen)
{
string isOpenSet = "0";
isOpenSet = isOpen ? "1" : "0";
string sql = $"UPDATE MemberShipRegSocialSet SET IsOpen={isOpenSet} WHERE SiteID={SiteID} AND SocialType={(int)socialType}";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
return(true);
}
public static string GetMemberTypeName(WorkV3.Models.MemberType memberType)
{
switch (memberType)
{
case WorkV3.Models.MemberType.FB:
return("FB");
case WorkV3.Models.MemberType.Web:
return("網站");
default:
return("undefined");
}
}
public static bool UpdateSocialItemSet(long SiteID, WorkV3.Models.MemberType socialType, string SecretKey, string AppID, string Scope, bool isOpen)
{
string sql = $"UPDATE MemberShipRegSocialSet SET IsOpen=@IsOpen, SecretKey=@SecretKey, AppID=@AppID, Scope=@Scope WHERE SiteID=@SiteID AND SocialType=@SocialType";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@SiteID", SiteID);
paraList.Add("@SocialType", (int)socialType);
paraList.Add("@IsOpen", isOpen);
paraList.Add("@SecretKey", SecretKey);
paraList.Add("@AppID", AppID);
paraList.Add("@Scope", Scope);
db.ExecuteNonQuery(sql, paraList);
return(true);
}
public static string GetSocialTypeButtonStyle(WorkV3.Models.MemberType socialType)
{
switch (socialType)
{
case WorkV3.Models.MemberType.FB:
return("btn-social-facebook-o");
case WorkV3.Models.MemberType.Twitter:
return("btn-social-twitter-o");
case WorkV3.Models.MemberType.Google:
return("btn-social-google-plus-o");
case WorkV3.Models.MemberType.Line:
return("btn-social-line-o");
case WorkV3.Models.MemberType.Pinterest:
return("btn-social-pinterest-o");
case WorkV3.Models.MemberType.Bloger:
return("btn-social-bloger-o"); //有缺的
case WorkV3.Models.MemberType.Plurk:
return("btn-social-plurk-o");
case WorkV3.Models.MemberType.LinkedIn:
return("btn-social-linkedin-o"); //有缺的
case WorkV3.Models.MemberType.Weibo:
return("btn-social-sina-weibo-o");
case WorkV3.Models.MemberType.QQ:
return("btn-social-qqchat-o");
case WorkV3.Models.MemberType.Baidu:
return("btn-social-baidu-o"); //有缺的
case WorkV3.Models.MemberType.Renren:
return("btn-social-renren-o");
}
return("");
}
public static string GetSocialTypeEDMImage(WorkV3.Models.MemberType socialType)
{
switch (socialType)
{
case WorkV3.Models.MemberType.FB:
return("icon-facebook.png");
case WorkV3.Models.MemberType.Twitter:
return("icon-twitter.png");
case WorkV3.Models.MemberType.Google:
return("icon-g+.png");
case WorkV3.Models.MemberType.YouTube:
return("icon-youtube.png");
case WorkV3.Models.MemberType.Vimeo:
return("icon-vimeo.png");
case WorkV3.Models.MemberType.Instagram:
return("icon-instagram.png");
case WorkV3.Models.MemberType.Pinterest:
return("icon-pinterest.png");
case WorkV3.Models.MemberType.Bloger:
return("icon-blogger.png");
case WorkV3.Models.MemberType.Plurk:
return("icon-plurk.png");
case WorkV3.Models.MemberType.LinkedIn:
return("icon-linkedin.png");
case WorkV3.Models.MemberType.Weibo:
return("icon-weibo.png");
case WorkV3.Models.MemberType.QQ:
return("icon-qq.png");
case WorkV3.Models.MemberType.Baidu:
return("icon-baidu.png");
case WorkV3.Models.MemberType.Renren:
return("icon-renren.png");
case WorkV3.Models.MemberType.Tudou:
return("icon-todou.png");
case WorkV3.Models.MemberType.YK:
return("icon-youku.png");
case WorkV3.Models.MemberType.Pinkoi:
return("icon-pinkoi.png");
case WorkV3.Models.MemberType.Accupass:
return("icon-accupass.png");
case WorkV3.Models.MemberType.Web:
return("icon-laptop.png");
case WorkV3.Models.MemberType.Blog:
return("icon-reading.png");
case WorkV3.Models.MemberType.Store:
return("icon-shop.png");
case WorkV3.Models.MemberType.Org:
return("icon-flag.png");
case WorkV3.Models.MemberType.Channel:
return("icon-channel.png");
case WorkV3.Models.MemberType.Album:
return("icon-gallery.png");
case WorkV3.Models.MemberType.Links:
return("icon-link-variant.png");
case WorkV3.Models.MemberType.Other:
return("icon-lnr-bookmark.png");
}
return("");
}
public static string GetSocialTypeStyle(WorkV3.Models.MemberType socialType)
{
switch (socialType)
{
case WorkV3.Models.MemberType.FB:
return("cc-facebook");
case WorkV3.Models.MemberType.Twitter:
return("cc-twitter");
case WorkV3.Models.MemberType.Google:
return("cc-google-plus");
case WorkV3.Models.MemberType.Line:
return("cc-line-text");
case WorkV3.Models.MemberType.Pinterest:
return("cc-pinterest");
case WorkV3.Models.MemberType.Bloger:
return("cc-bloger"); //有缺的
case WorkV3.Models.MemberType.Plurk:
return("cc-plurk");
case WorkV3.Models.MemberType.LinkedIn:
return("cc-linkedin");
case WorkV3.Models.MemberType.Weibo:
return("cc-sina-weibo");
case WorkV3.Models.MemberType.QQ:
return("cc-qqchat");
case WorkV3.Models.MemberType.Baidu:
return("cc-baidu");
case WorkV3.Models.MemberType.Renren:
return("cc-renren");
case WorkV3.Models.MemberType.YouTube:
return("cc-youtube");
case WorkV3.Models.MemberType.Vimeo:
return("cc-vimeo");
case WorkV3.Models.MemberType.Instagram:
return("cc-instagram");
case WorkV3.Models.MemberType.Tudou:
return("cc-tudou");
case WorkV3.Models.MemberType.YK:
return("cc-youku");
case WorkV3.Models.MemberType.Pinkoi:
return("cc-pinkoi");
case WorkV3.Models.MemberType.Accupass:
return("cc-accupass");
case WorkV3.Models.MemberType.Web:
return("cc-laptop");
case WorkV3.Models.MemberType.Blog:
return("cc-reading");
case WorkV3.Models.MemberType.Store:
return("cc-shop");
case WorkV3.Models.MemberType.Org:
return("cc-flag");
case WorkV3.Models.MemberType.Channel:
return("cc-channel");
case WorkV3.Models.MemberType.Album:
return("cc-gallery");
case WorkV3.Models.MemberType.Links:
return("cc-link-variant");
case WorkV3.Models.MemberType.Other:
return("cc-lnr-bookmark");
}
return("");
}
public static string GetSocialTypeTitle(WorkV3.Models.MemberType socialType)
{
switch (socialType)
{
case WorkV3.Models.MemberType.FB:
return("Facebook");
case WorkV3.Models.MemberType.Twitter:
return("Twitter");
case WorkV3.Models.MemberType.Google:
return("Google +");
case WorkV3.Models.MemberType.Line:
return("Line");
case WorkV3.Models.MemberType.Pinterest:
return("Pinterest");
case WorkV3.Models.MemberType.Bloger:
return("Bloger");
case WorkV3.Models.MemberType.Plurk:
return("Plurk");
case WorkV3.Models.MemberType.LinkedIn:
return("LinkedIn");
case WorkV3.Models.MemberType.Weibo:
return("微博");
case WorkV3.Models.MemberType.QQ:
return("QQ");
case WorkV3.Models.MemberType.Baidu:
return("百度");
case WorkV3.Models.MemberType.Renren:
return("人人網");
case WorkV3.Models.MemberType.YouTube:
return("YouTube");
case WorkV3.Models.MemberType.Vimeo:
return("Vimeo");
case WorkV3.Models.MemberType.Instagram:
return("Instagram");
case WorkV3.Models.MemberType.Tudou:
return("土豆網");
case WorkV3.Models.MemberType.YK:
return("優酷"); //有缺的
case WorkV3.Models.MemberType.Accupass:
return("Accupass 活動通"); //有缺的
case WorkV3.Models.MemberType.Pinkoi:
return("Pinkoi"); //有缺的
case WorkV3.Models.MemberType.Web:
return("網站"); //有缺的
case WorkV3.Models.MemberType.Blog:
return("部落格"); //有缺的
case WorkV3.Models.MemberType.Store:
return("賣場 / 網路商店"); //有缺的
case WorkV3.Models.MemberType.Org:
return("機關 / 單位"); //有缺的
case WorkV3.Models.MemberType.Channel:
return("頻道"); //有缺的
case WorkV3.Models.MemberType.Album:
return("相簿"); //有缺的
case WorkV3.Models.MemberType.Links:
return("連結"); //有缺的
case WorkV3.Models.MemberType.Other:
return("其他"); //有缺的
}
return("");
}
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);
}
}
