public ActionResult UpdateMemberShipColumnSet(long SiteID, string ColumnName, bool IsOpen, bool IsNeedValue)
{
MemberShipRegSetModels model = MemberShipRegSetDAO.GetItem(SiteID);
bool Result = MemberShipRegSetDAO.UpdateColumnItemSet(SiteID, ColumnName, IsOpen, IsNeedValue);
if (Result)
{
return(Json("success"));
}
else
{
return(Json("fail"));
}
}
public ActionResult UpdateMemberShipSet(long SiteID, string columnName, string columnValue)
{
MemberShipRegSetModels model = MemberShipRegSetDAO.GetItem(SiteID);
bool Result = MemberShipRegSetDAO.UpdateItemSet(SiteID, columnName, columnValue);
if (Result)
{
return(Json("success"));
}
else
{
return(Json("fail"));
}
}
public ActionResult GetMemberShipSet(long SiteID)
{
MemberShipRegSetModels model = MemberShipRegSetDAO.GetItem(SiteID);
return(Json(model));
}
public static bool ChangeMemberShipStatusAndVerifyStatus(long ID, long SiteID, bool?Status, bool?VerifyType, string StatusNote)
{
MemberShipRegSetModels regSetModel = MemberShipRegSetDAO.GetItem(SiteID);
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DateTime now = DateTime.Now;
string sql = "Select 1 From MemberShip Where ID = " + ID.ToString();
string updColumn = "";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
return(false);
}
SQLData.ParameterCollection paraList = new SQLData.ParameterCollection();
paraList.Add("@ID", ID);
if (Status.HasValue)
{
updColumn += ",Status=@Status";
paraList.Add("@Status", Status.Value);
if (regSetModel.VerifyType != MemberShipVerifyType.Email &&
!VerifyType.HasValue)
{
updColumn += ",VerifyTime=@VerifyTime";
if (VerifyType.HasValue && VerifyType.Value)
{
paraList.Add("@VerifyTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
paraList.Add("@VerifyTime", "");
}
}
}
if (VerifyType.HasValue)
{
updColumn += ",VerifyTime=@VerifyTime";
if (VerifyType.Value)
{
paraList.Add("@VerifyTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
paraList.Add("@VerifyTime", "");
}
}
if (!string.IsNullOrEmpty(StatusNote))
{
updColumn += ",StatusNote=@StatusNote";
paraList.Add("@StatusNote", StatusNote);
}
string modifyStr = string.Format("UPDATE MemberShip SET ModifyTime=GETDATE() {0} WHERE ID=@ID ", updColumn);
int exeCount = db.ExecuteNonQuery(modifyStr, paraList);
if (exeCount > 0)
{
return(true);
}
return(false);
}
public static MemberShipRegSetModels GetItem(long SiteID)
{
string sql = $"SELECT * FROM MemberShipRegSet WHERE SiteID={SiteID} ";
DateTime now = DateTime.Now;
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
if (datas == null || datas.Rows.Count <= 0)
{
if (Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent != null)
{
MemberShipRegSetModels m = new MemberShipRegSetModels();
List <MemberShipLoginType> loginTypeList = new List <MemberShipLoginType>();
m.SiteID = SiteID;
m.IsOpenReg = false;
m.RegType = Areas.Backend.Models.MemberShipRegType.All; // default
m.VerifyType = Areas.Backend.Models.MemberShipVerifyType.None; // default
m.LoginType = "0"; // default
string[] loginTypes = m.LoginType.Split(';');
foreach (string loginType in loginTypes)
{
if (!string.IsNullOrEmpty(loginType))
{
MemberShipLoginType lType = (MemberShipLoginType)int.Parse(loginType);
if (!loginTypeList.Contains(lType))
{
loginTypeList.Add(lType);
}
}
}
m.LoginTypeList = loginTypeList;
m.IsNeedAgreeMemberDesc = false; // default
m.IsNeedVerifyCode = false; // default
m.IsAutoEmail = false; // default
m.AutoEmailManagers = ""; // default
m.Modifier = WorkV3.Areas.Backend.Models.DataAccess.MemberDAO.SysCurrent.Id;
m.ModifyTime = now;
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("MemberShipRegSet");
tableObj["SiteID"] = m.SiteID;
tableObj["IsOpenReg"] = m.IsOpenReg; // default
tableObj["RegType"] = (int)m.RegType; // default
tableObj["VerifyType"] = (int)m.VerifyType; // default
tableObj["LoginType"] = m.LoginType; // default
tableObj["IsNeedAgreeMemberDesc"] = m.IsNeedAgreeMemberDesc; // default
tableObj["IsNeedVerifyCode"] = m.IsNeedVerifyCode; // default
tableObj["IsAutoEmail"] = m.IsAutoEmail; // default
tableObj["AutoEmailManagers"] = m.AutoEmailManagers; // default
tableObj["BackendIsOpen"] = m.BackendIsOpen; // default
tableObj["Creator"] = m.Creator;
tableObj["CreateTime"] = m.CreateTime;
tableObj["Modifier"] = m.Modifier;
tableObj["ModifyTime"] = m.ModifyTime;
tableObj.Insert();
}
else
{
return(null);
}
}
else
{
DataRow dr = datas.Rows[0];
List <MemberShipLoginType> loginTypeList = new List <MemberShipLoginType>();
MemberShipRegSetModels m = new MemberShipRegSetModels();
m.SiteID = (long)dr["SiteID"];
m.IsOpenReg = (bool)dr["IsOpenReg"];
m.RegType = (Areas.Backend.Models.MemberShipRegType)((int)dr["RegType"]);
m.VerifyType = (Areas.Backend.Models.MemberShipVerifyType)((int)dr["VerifyType"]);
m.LoginType = dr["LoginType"].ToString();
string[] loginTypes = m.LoginType.Split(';');
m.AddFriend = dr["AddFriend"].ToString();
foreach (string loginType in loginTypes)
{
if (!string.IsNullOrEmpty(loginType))
{
MemberShipLoginType lType = (MemberShipLoginType)int.Parse(loginType);
if (!loginTypeList.Contains(lType))
{
loginTypeList.Add(lType);
}
}
}
m.LoginTypeList = loginTypeList;
m.RegColumnSets = GetColumnItems(SiteID);
m.RegSocialSets = GetSocialItems(SiteID);
m.IsNeedAgreeMemberDesc = (bool)dr["IsNeedAgreeMemberDesc"];
m.IsNeedVerifyCode = (bool)dr["IsNeedVerifyCode"];
m.IsAutoEmail = (bool)dr["IsAutoEmail"];
m.AutoEmailManagers = dr["AutoEmailManagers"].ToString();
m.Modifier = (long)dr["Modifier"];
m.ModifyTime = (DateTime )dr["ModifyTime"];
return(m);
}
return(null);
}
