public ActionResult UpgradeSelectManagers(long SiteID, string selectManagers)
{
if (string.IsNullOrEmpty(selectManagers))
{
return(Json("fail"));
}
string[] selectManagerList = selectManagers.Split(',');
// MemberShipRegSetDAO.DelMemberShipRegManagers(SiteID);
foreach (string selectManagerID in selectManagerList)
{
MemberShipRegEmailManagersModels model = MemberShipRegSetDAO.GetMemberShipRegManagers(SiteID, long.Parse(selectManagerID));
if (model == null)
{
model = new MemberShipRegEmailManagersModels();
model.ID = WorkLib.GetItem.NewSN().ToString();
model.SiteID = SiteID;
model.IsManager = true;
model.ManagerID = selectManagerID;
model.Email = "";
model.Sort = 0;
model.IsSelected = true;
}
MemberShipRegSetDAO.SetMemberShipRegManagers(model);
}
return(Json("success"));
}
public static List <MemberShipRegEmailManagersModels> GetMemberShipRegManagers(long SiteID)
{
List <MemberShipRegEmailManagersModels> modelList = new List <MemberShipRegEmailManagersModels>();
string sql = $"SELECT * FROM MemberShipRegEmailManagers 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)
{
for (int i = 0; i < datas.Rows.Count; i++)
{
MemberShipRegEmailManagersModels m = new MemberShipRegEmailManagersModels();
m.ID = datas.Rows[i]["ID"].ToString();
m.SiteID = SiteID;
m.IsManager = (bool)datas.Rows[i]["IsManager"];
m.ManagerID = datas.Rows[i]["ManagerID"].ToString();
m.Email = datas.Rows[i]["Email"].ToString();
m.Sort = (int)datas.Rows[i]["Sort"];
if (m.IsManager)
{
MemberModels mem = Models.DataAccess.ManagerDAO.GetItem(long.Parse(m.ManagerID));
if (mem != null)
{
m.ManagerName = mem.Name;
m.Email = mem.Email;
}
}
modelList.Add(m);
}
}
return(modelList);
}
public static void SetMemberShipRegManagers(MemberShipRegEmailManagersModels item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("MemberShipRegEmailManagers");
tableObj.GetDataFromObject(item);
string sql = $"Select 1 From MemberShipRegEmailManagers Where SiteID={item.SiteID} AND ManagerID='{item.ManagerID}'";
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
if (string.IsNullOrEmpty(item.ManagerID))
{
tableObj["ManagerID"] = "";
}
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("SiteID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public ActionResult UpgradeSelectEmail(long SiteID, string Email)
{
MemberShipRegEmailManagersModels model = MemberShipRegSetDAO.GetMemberShipRegManagerEmail(SiteID, Email);
if (model == null)
{
model = new MemberShipRegEmailManagersModels();
model.ID = WorkLib.GetItem.NewSN().ToString();
model.SiteID = SiteID;
model.IsManager = false;
model.ManagerID = "";
model.Email = Email;
model.Sort = 0;
model.IsSelected = true;
}
MemberShipRegSetDAO.SetMemberShipRegManagers(model);
return(Json("success"));
}
public static MemberShipRegEmailManagersModels GetMemberShipRegManagerEmail(long SiteID, string Email)
{
string sql = $"SELECT * FROM MemberShipRegEmailManagers WHERE SiteID={SiteID} AND Email='{Email}'";
DateTime now = DateTime.Now;
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
if (datas != null && datas.Rows.Count > 0)
{
MemberShipRegEmailManagersModels m = new MemberShipRegEmailManagersModels();
m.ID = datas.Rows[0]["ID"].ToString();
m.SiteID = SiteID;
m.IsManager = false;
m.ManagerID = "";
m.Email = datas.Rows[0]["Email"].ToString();
m.Sort = (int)datas.Rows[0]["Sort"];
return(m);
}
return(null);
}
