public UserGroupDto FindGroupById(long groupId)
{
UserGroup group = GroupDao.Find(groupId);
UserGroupDto groupDto = new UserGroupDto(group);
return(groupDto);
}
public ActionResult Edit(Group collection)
{
try
{
//TODO: Add update logic here
if (ModelState.IsValid)
{
// TODO: Add insert logic here
GroupDao bdDao = new GroupDao();
UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION];
if (bdDao.Update(collection))
{
SetAlert("Sửa thành công", "success");
return(RedirectToAction("Index"));
}
else
{
SetAlert("Không sửa được", "danger");
}
}
return(View());
}
catch
{
SetAlert("Không sửa được", "danger");
return(View());
}
}
public ICollection <Recommendation> AddRecommendation(long eventId, ICollection <long> groups, long userId, string description)
{
Event e = EventDao.Find(eventId);
ICollection <Recommendation> recs = new List <Recommendation>();
foreach (long groupId in groups)
{
Recommendation r = RecommendationDao.FindByGroupIdAndEventIdAndUsrId(groupId, userId, eventId);
if (r != null)
{
r.reason = description;
RecommendationDao.Update(r);
}
else
{
UserGroup g = GroupDao.Find(groupId);
UserProfile u = UserProfileDao.Find(userId);
Recommendation rec = new Recommendation();
rec.UserGroup = g;
rec.UserProfile = u;
rec.Event = e;
rec.reason = description;
RecommendationDao.Create(rec);
recs.Add(rec);
}
}
return(recs);
}
public UserGroupDto FindGroupsByName(string name)
{
UserGroup group = GroupDao.FindByName(name);
UserGroupDto groupDto = new UserGroupDto(group);
return(groupDto);
}
public void Page_Load(object sender, EventArgs e)
{
if (!Main.Instance.AdminApi.IsPluginAuthorized)
{
HttpContext.Current.Response.Write("<h1>未授权访问</h1>");
HttpContext.Current.Response.End();
return;
}
_configInfo = Utils.GetConfigInfo();
if (!string.IsNullOrEmpty(Request.QueryString["delete"]) &&
!string.IsNullOrEmpty(Request.QueryString["groupId"]))
{
GroupDao.Delete(Convert.ToInt32(Request.QueryString["groupId"]));
LtlMessage.Text = Utils.GetMessageHtml("删除成功！", true);
}
if (IsPostBack)
{
return;
}
var groupInfoList = GroupDao.GetGroupInfoList();
groupInfoList.Insert(0, Utils.GetDefaultGroupInfo(_configInfo));
RptContents.DataSource = groupInfoList;
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
BtnAdd.OnClientClick = $"location.href = '{PageWritingSettings.GetAddUrl()}';return false;";
}
public ActionResult Create(Group collection)
{
try
{
if (ModelState.IsValid)
{
// TODO: Add insert logic here
GroupDao bdDao = new GroupDao();
// UserLogin us = (UserLogin)Session[CommonConstant.USER_SESSION];
//collection.CreateDate = Hepper.GetDateServer();
//collection.ModifiedDate = Hepper.GetDateServer();
//collection.CreateBy = us.UserName;
//collection.ModifiedBy = us.UserName;
if (bdDao.Insert(collection))
{
SetAlert("Thêm thành công", "success");
return(RedirectToAction("Index"));
}
else
{
SetAlert("Không thêm được", "danger");
}
}
return(View());
}
catch
{
SetAlert("Không thêm được", "danger");
return(View());
}
}
/// <summary>
/// Initializes a new instance of the AverageSpecialtyReport class.
/// </summary>
/// <param name="factory"></param>
public AverageSpecialtyReport(DaoFactory factory)
{
examDao = factory.GetExamDao();
resultDao = factory.GetResultDao();
groupDao = factory.GetGroupDao();
specialtyDao = factory.GetSpecialtyDao();
}
public static object GetChannels(IRequest request)
{
if (!request.IsUserLoggin)
{
throw new Exception("用户认证失败");
}
var nodes = new List <object>();
try
{
var siteId = request.GetPostInt("siteId");
var groupInfo = GroupDao.GetGroupInfo(GroupUserDao.GetGroupId(request.UserName)) ?? Utils.GetDefaultGroupInfo(Utils.GetConfigInfo());
var adminName = groupInfo.WritingAdmin;
var nodeIdList = Main.Instance.ChannelApi.GetChannelIdList(siteId, adminName);
foreach (var nodeId in nodeIdList)
{
var channelInfo = Main.Instance.ChannelApi.GetChannelInfo(siteId, nodeId);
nodes.Add(new
{
channelInfo.Id,
channelInfo.ChannelName
});
}
}
catch { }
return(nodes);
}
public static object Login(IRequest request)
{
var account = request.GetPostString("account");
var password = request.GetPostString("password");
string userName;
string errorMessage;
if (!Main.Instance.UserApi.Validate(account, password, out userName, out errorMessage))
{
Main.Instance.UserApi.UpdateLastActivityDateAndCountOfFailedLogin(userName);
throw new Exception(errorMessage);
}
Main.Instance.UserApi.UpdateLastActivityDateAndCountOfLogin(userName);
var user = Main.Instance.UserApi.GetUserInfoByUserName(userName);
var group = GroupDao.GetGroupInfo(GroupUserDao.GetGroupId(user.UserName)) ??
Utils.GetDefaultGroupInfo(Utils.GetConfigInfo());
request.UserLogin(userName);
return(new
{
User = user,
Group = group
});
}
public JsonResult ListGroupUser(long userID)
{
var dao = new GroupUserDao();
List <GroupUserGrand> lstgr = new List <GroupUserGrand>();
var list = dao.FindByLoginID(userID);
var lstGroup = new GroupDao().ToList();
foreach (var gr in lstGroup)
{
GroupUserGrand objGr = new GroupUserGrand();
objGr.GroupID = gr.GroupID;
objGr.GroupName = gr.GroupName;
objGr.isGranted = false;
foreach (var ug in list)
{
if (ug.GroupID == gr.GroupID)
{
objGr.isGranted = true;
}
}
lstgr.Add(objGr);
}
JsonResult result = new JsonResult();
result.Data = lstgr;
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(result);
}
/// <summary>
/// 设置指定的数据进行显示
/// </summary>
/// <param name="UIRecord">User interface record.</param>
public void SetValue(UserInfoRecord UIRecord)
{
Logger.Instance.WriteLog("显示用户相关信息");
this.UIRecord = UIRecord;
if (UIRecord.GInfo.Name == "超级管理员" || UIRecord.UBInfo.UserName == DataStore.UserInfo.UserName)
{
ForbiddenModify();
}
GroupDao gpDao = new GroupDao();
gpDao.Select003();
List <GroupInfo> gpInfos = gpDao.Result;
foreach (GroupInfo info in gpInfos)
{
PPLRole.AddItem(info.Name);
}
PPLRole.value = UIRecord.GInfo.Name;
LBLAccount.text = UIRecord.UBInfo.UserName;
LBLCreateTime.text = System.DateTime.Parse(UIRecord.UBInfo.CreateTime).ToString("yyyy年MM月dd日");
LBLPassword.text = "**********";
IPTAddress.value = UIRecord.UBInfo.Address;
IPTRealName.text = UIRecord.UBInfo.RealName;
IPTTelphone.value = UIRecord.UBInfo.Telphone;
IPTMemo.value = UIRecord.UBInfo.Memo;
if (UIRecord.UBInfo.Status == "禁用")
{
BtnContainer.transform.FindChild("BtnForbidden").GetComponentInChildren <UILabel>().text = "启用";
}
}
/// <summary>
/// 提交数据可修改相关信息
/// </summary>
public void Confirm()
{
Logger.Instance.WriteLog("保存修改后的用户信息");
UserBasicDao ubdao = new UserBasicDao();
ubdao.Update003(IPTRealName.text, UIRecord.UBInfo.Password, IPTTelphone.value,
IPTAddress.value, IPTMemo.value, UIRecord.UBInfo.ID);
GroupDao gpDao = new GroupDao();
gpDao.Select003();
List <GroupInfo> gpInfos = gpDao.Result;
foreach (GroupInfo info in gpInfos)
{
if (PPLRole.value == info.Name)
{
UserGroupDao ugDao = new UserGroupDao();
ugDao.Update001(info.Id, UIRecord.UBInfo.ID);
break;
}
}
UserRecordManage.Instance.GetComponent <UserRecordManage> ().ReLoadUserRecord();
Destroy(gameObject);
}
// GET: Group/Details/5
public ActionResult Details(Guid id)
{
GroupDao bdDao = new GroupDao();
var sl = bdDao.FindByID(id);
return(View(sl));
}
/// <summary>
/// Initializes a new instance of the SessionResult class.
/// </summary>
/// <param name="factory"></param>
public SessionResult(DaoFactory factory)
{
groupDao = factory.GetGroupDao();
subjectDao = factory.GetSubjectDao();
studentDao = factory.GetStudentDao();
examDao = factory.GetExamDao();
resultDao = factory.GetResultDao();
}
public void TestRead()
{
GroupDao groupDao = factory.GetGroupDao();
Group group = groupDao.Read(1);
Group expectedGroup = new Group("ИТ-11", 1);
Assert.AreEqual(expectedGroup, group);
}
/// <summary>
/// Gets the DAO group.
/// </summary>
/// <returns></returns>
public override GroupDao GetGroupDao()
{
if (groupDao == null)
{
groupDao = new GroupDao(connString);
}
return(groupDao);
}
/// <summary>
/// 用户登录
/// </summary>
public void Login()
{
Logger.Instance.WriteLog("开始登录");
//检索个人登录信息
UserBasicDao ubdao = new UserBasicDao();
try
{
ubdao.Select001(UserName.value, Password.value);
}
catch (Exception ex)
{
Logger.Instance.WriteLog("数据库连接异常");
Message.text = "数据库连接异常,请查看output_log.txt文件查看错误原因。";
Debug.Log(ex.ToString());
return;
}
if (ubdao.Result.Count == 1)
{
if (ubdao.Result[0].Status == "正常")
{
DataStore.UserInfo = ubdao.Result[0];
//检索用户所属组
GroupDao gDao = new GroupDao();
gDao.Select002(DataStore.UserInfo.ID);
DataStore.GPInfo = gDao.Result[0];
//检索用户所属组的权限列表
GroupAuthorityDao gaDao = new GroupAuthorityDao();
gaDao.Select001(DataStore.GPInfo.Id);
//检索权限信息
AuthorityDao aDao = new AuthorityDao();
aDao.Select001();
//将用户的权限详细信息保存下来
foreach (GroupAuthorityInfo gaInfo in gaDao.Result)
{
foreach (AuthorityInfo aInfo in aDao.Result)
{
if (gaInfo.AuthorityId == aInfo.Id)
{
DataStore.AuthorityInfos.Add(aInfo);
break;
}
}
}
Logger.Instance.WriteLog("登录成功");
Message.text = "";
LoadingUI.SetActive(true);
LoadingUI.SendMessage("LoadLevel", "EditScene");
}
}
else
{
Message.text = "登录失败，用户名或密码错误。";
}
}
public void RemoveGroup()
{
GroupDao groupDao = new GroupDao();
groupDao.MakeConnection(Properties.Resources.strConnection);
List <GroupDto> groups = (List <GroupDto>)mainWindow.GroupData;
groupDao.DeleteById(groups[mainWindow.SelectIndexGroup].Id);
}
public void TestReadAll()
{
GroupDao groupDao = factory.GetGroupDao();
List <Group> groups = groupDao.ReadAll();
Group group = groups[1];
Group expectedGroup = new Group("ИТ-21", 1);
Assert.AreEqual(expectedGroup, group);
}
// GET: Group/Edit/5
public ActionResult Edit(Guid id)
{
GroupDao bdDao = new GroupDao();
var sl = bdDao.FindByID(id);
//if (sl.Status == true) { ViewBag.Status = "Kích hoạt"; }
//else { ViewBag.Status = "Khóa"; }
return(View(sl));
}
public UserGroup UnJoinGroup(long userId, long groupId)
{
UserGroup group = GroupDao.Find(groupId);
UserProfile user = UserProfileDao.Find(userId);
group.UserProfiles.Remove(user);
GroupDao.Update(group);
return(group);
}
public void TestUpdate()
{
GroupDao groupDao = factory.GetGroupDao();
groupDao.Update(new Group("ИТ-21", 1), 3);
Group group = groupDao.Read(3);
Group expectedGroup = new Group("ИТ-21", 1);
Assert.AreEqual(expectedGroup, group);
}
protected override void SetUp()
{
base.SetUp();
IConnectionInfoAsync connectionInfo = A.Fake <IConnectionInfoAsync>();
_groupDao = new GroupDao(connectionInfo);
A.CallTo(() => connectionInfo.GetConnectionStringAsync()).Returns(ConnectionString);
}
public static object LoadConfig(IRequest request)
{
var dict = new Dictionary <string, List <MenuInfo> >();
foreach (var parentInfo in MenuDao.GetMenuInfoList(0))
{
dict.Add(parentInfo.Title, MenuDao.GetMenuInfoList(parentInfo.Id));
}
var systemConfig = Main.Instance.ConfigApi.SystemConfig;
var homeConfig = Utils.GetConfigInfo();
var user = Main.Instance.UserApi.GetUserInfoByUserName(request.UserName);
var group = GroupDao.GetGroupInfo(GroupUserDao.GetGroupId(request.UserName)) ??
Utils.GetDefaultGroupInfo(Utils.GetConfigInfo());
var weiboUrl = string.Empty;
var weixinUrl = string.Empty;
var qqUrl = string.Empty;
var loginPlugin = Main.Instance.PluginApi.GetPlugin <LoginPlugin>(LoginPlugin.PluginId);
if (loginPlugin != null)
{
if (loginPlugin.IsOAuthReady(OAuthType.Weibo))
{
weiboUrl = loginPlugin.GetOAuthLoginUrl(OAuthType.Weibo, string.Empty);
}
if (loginPlugin.IsOAuthReady(OAuthType.Weixin))
{
weixinUrl = loginPlugin.GetOAuthLoginUrl(OAuthType.Weixin, string.Empty);
}
if (loginPlugin.IsOAuthReady(OAuthType.Qq))
{
qqUrl = loginPlugin.GetOAuthLoginUrl(OAuthType.Qq, string.Empty);
}
}
return(new
{
IsUserRegistrationAllowed = systemConfig.GetBool(SystemConfigAttribute.IsUserRegistrationAllowed),
IsUserFindPassword = systemConfig.GetBool(SystemConfigAttribute.IsUserFindPassword),
homeConfig.HomeUrl,
homeConfig.Title,
homeConfig.Copyright,
homeConfig.BeianNo,
homeConfig.LogoUrl,
homeConfig.DefaultAvatarUrl,
weiboUrl,
weixinUrl,
qqUrl,
Menus = dict,
User = user,
Group = group
});
}
public UserGroup AddGroup(string name, string description, long userId)
{
UserProfile u = UserProfileDao.Find(userId);
UserGroup g = new UserGroup();
g.name = name;
g.description = description;
g.UserProfiles.Add(u);
GroupDao.Create(g);
return(g);
}
public static object CreateContent(IRequest request)
{
if (!request.IsUserLoggin)
{
throw new Exception("用户认证失败");
}
var siteId = request.GetPostInt("siteId");
var channelId = request.GetPostInt("channelId");
var groupInfo = GroupDao.GetGroupInfo(GroupUserDao.GetGroupId(request.UserName)) ?? Utils.GetDefaultGroupInfo(Utils.GetConfigInfo());
var adminName = groupInfo.WritingAdmin;
var contentInfo = Main.Instance.ContentApi.NewInstance();
var bodyStream = new StreamReader(request.HttpRequest.InputStream);
bodyStream.BaseStream.Seek(0, SeekOrigin.Begin);
var raw = bodyStream.ReadToEnd();
var postData = !string.IsNullOrEmpty(raw) ? JObject.Parse(raw) : new JObject();
var form = new NameValueCollection();
foreach (var item in postData)
{
form[item.Key] = item.Value.ToString();
}
contentInfo.Load(form);
contentInfo.IsChecked = false;
contentInfo.SiteId = siteId;
contentInfo.ChannelId = channelId;
contentInfo.AddUserName = adminName;
contentInfo.WritingUserName = request.UserName;
contentInfo.LastEditUserName = adminName;
contentInfo.AddDate = DateTime.Now;
contentInfo.LastEditDate = DateTime.Now;
var contentId = Main.Instance.ContentApi.Insert(siteId, channelId, contentInfo);
Main.Instance.UserApi.AddLog(request.UserName, "新增稿件", contentInfo.Title);
if (groupInfo.Id > 0)
{
groupInfo.LastWritingSiteId = siteId;
groupInfo.LastWritingChannelId = channelId;
GroupDao.Update(groupInfo);
}
return(new
{
Id = contentId
});
}
private void Insert(DataRow row)
{
try
{
GroupDao.Insert(_ConfigItem, row);
}
catch (Exception ex)
{
throw ex;
}
}
private void Delete(int _id)
{
try
{
GroupDao.Delete(_ConfigItem, _id);
}
catch (Exception ex)
{
throw ex;
}
}
public ICollection <UserGroupDto> FindAllGroups()
{
ICollection <UserGroup> groups = GroupDao.GetAllElements();
ICollection <UserGroupDto> groupsDto = new List <UserGroupDto>();
foreach (UserGroup group in groups)
{
groupsDto.Add(new UserGroupDto(group));
}
return(groupsDto);
}
public void PopulateGroupList(ref DropDownList dropDownList)
{
dropDownList.Items.Clear();
var groupList = GroupDao.GetGroupList();
dropDownList.Items.Add(new ListItem("All", "0"));
foreach (var g in groupList)
{
dropDownList.Items.Add(new ListItem(g.GroupName, g.IdGroup));
}
}
