public JsonResult Delete(string id)
{
var isUsed = new UserGroupDao().CheckUserIsUsed(id);
if (!isUsed)
{
var res = new UserGroupDao().Delete(id);
if (res)
{
return(Json(new
{
status = true
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
status = false
}, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new
{
status = false,
message = "Nhóm tài khoản đang dùng. Vui lòng kiểm tra lại"
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
List <TreeViewNode> nodes = new List <TreeViewNode>();
var dao = new UserGroupDao();
var entities = dao.GetUserGroups();
//Loop and add the Parent Nodes.
foreach (UserGroup type in entities)
{
nodes.Add(new TreeViewNode {
id = type.ID.ToString(), parent = "#", text = type.Name
});
}
var childEntity = dao.GetRoleByGroup();
// Loop and add the Child Nodes.
foreach (UserRoleByGroupModel subType in childEntity)
{
nodes.Add(new TreeViewNode {
id = subType.role.ID.ToString(), parent = subType.userGroup.ID.ToString(), text = subType.role.Name
});
}
//Serialize to JSON string.
ViewBag.Json = (new JavaScriptSerializer()).Serialize(nodes);
SetAlert("Load thành công", "success");
return(View());
}
/// <summary>
/// 确定创建用户
/// </summary>
public void Comfirm()
{
Logger.Instance.WriteLog("保存新创建的用户信息");
UserBasicDao ubdao = new UserBasicDao();
ubdao.Insert001(IPTAccount.value, IPTPassword.value, IPTRealName.value,
IPTTelphone.value, System.DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss"),
IPTAddress.value, "正常", IPTMemo.value);
ubdao.Select003(IPTAccount.value);
UserBasicInfo ubInfo = ubdao.Result [0];
string goupId = "1";
foreach (GroupInfo info in Groups)
{
if (PPLGroup.value == info.Name)
{
goupId = info.Id;
break;
}
}
UserGroupDao ugpDao = new UserGroupDao();
ugpDao.Insert001(ubInfo.ID, goupId);
UserRecordManage.Instance.GetComponent <UserRecordManage> ().ReLoadUserRecord();
Destroy(gameObject);
}
public ActionResult Index(int page = 1, int pageSize = 5)
{
var dao = new UserGroupDao();
var model = dao.ListAllPaging(page, pageSize);
return(View(model));
}
/// <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);
}
public void SetViewBag(string selectId = null)
{
var dao = new UserGroupDao();
ViewBag.Usergroup = new SelectList(dao.ListAll(), "ID", "Name", selectId);
//ViewBag.Submenu = new SelectList(dao.ListAllMenu(), "IDMenu", "Text", selectId);
}
public Permissoes()
{
InitializeComponent();
this.Dock = DockStyle.Fill;
DataTable tbUsuarios = new SysUserDao().select();
DataTable tbGrupos = new UserGroupDao().select();
DataTable tbRelatorios = new ReportDao().select();
addOpcaoTodos(tbUsuarios, SysUserDao.DisplayMember, SysUserDao.ValueMember);
addOpcaoTodos(tbGrupos, UserGroupDao.DisplayMember, UserGroupDao.ValueMember);
addOpcaoTodos(tbRelatorios, ReportDao.DisplayMember, ReportDao.ValueMember);
//Listando todos os usuários
cmbUsuarios.DisplayMember = SysUserDao.DisplayMember;
cmbUsuarios.ValueMember = SysUserDao.ValueMember;
cmbUsuarios.DataSource = tbUsuarios;
//Listando todos os Grupos de Usuários
cmbGrupo.DisplayMember = UserGroupDao.DisplayMember;
cmbGrupo.ValueMember = UserGroupDao.ValueMember;
cmbGrupo.DataSource = tbGrupos;
//Listando todos os relatórios
cmbRelUsu.DisplayMember = ReportDao.DisplayMember;
cmbRelUsu.ValueMember = ReportDao.ValueMember;
cmbRelUsu.DataSource = tbRelatorios;
cmbRelGrupo.DisplayMember = ReportDao.DisplayMember;
cmbRelGrupo.ValueMember = ReportDao.ValueMember;
cmbRelGrupo.DataSource = tbRelatorios;
}
public ActionResult ChangeGroup(int id = 0)
{
var daoUser = new UserDao();
var daoUserGroup = new UserGroupDao();
var user = daoUser.ViewDetail(id);
List <string> result = new List <string>();
if (user.GroupID != null)
{
result = user.GroupID.Split(',').ToList();
}
var lstUserGroupFirst = daoUserGroup.GetUserGroup();
Dictionary <string, string> lstGroupId = new Dictionary <string, string>();
foreach (var item in result)
{
lstGroupId.Add(item, item);
}
TempData["lstGroupId"] = result;
foreach (var role in result)
{
foreach (var item in lstUserGroupFirst.ToList())
{
if (role.Trim() == item.ID.Trim())
{
lstUserGroupFirst.Remove(item);
}
}
}
// show data có thể dùng ajax
TempData["lstUserGroupFirst"] = lstUserGroupFirst;
return(View(user));
}
public JsonResult LoadData(int type, string keyword, int pageIndex, int pageSize)
{
string str = NonUnicode.RemoveUnicode(keyword).ToLower();
var model = new UserGroupDao().ListAll();
switch (type)
{
case 0: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name.ToLower()).Contains(str) || x.ID.ToLower().Contains(keyword)); break;
case 1: model = model.Where(x => NonUnicode.RemoveUnicode(x.Name.ToLower()).Contains(str)); break;
}
int totalRow = model.Count();
model = model.OrderByDescending(x => x.ID)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize);
int totalRowCurent = model.Count();
return(Json(new
{
data = model,
total = totalRow,
totalCurent = totalRowCurent,
status = true
}, JsonRequestBehavior.AllowGet));
}
public void AddNewUser()
{
Logger.Instance.WriteLog("保存新创建的用户信息");
UserBasicDao ubdao = new UserBasicDao();
ubdao.Insert001(accountName.value, UIRecord.UBInfo.Password, userName.value,
userMobile.value, System.DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss"),
userAdd.value, "正常", remark.value);
ubdao.Select003(accountName.value);
UserBasicInfo ubInfo = ubdao.Result [0];
string goupId = "1";
foreach (UILabel lb in groups)
{
if (lb.transform.parent.GetComponent <userGroupItem>().selectToggle.value)
{
goupId = lb.transform.parent.GetComponent <userGroupItem>().info.Id;
}
}
UserGroupDao ugpDao = new UserGroupDao();
ugpDao.Insert001(ubInfo.ID, goupId);
ReLoadUserRecord();
newBtn.SetActive(true);
updateBtn.SetActive(false);
}
public void start(SCApplication scApp)
{
this.scApp = scApp;
userDao = scApp.UserDao;
functionCodeDao = scApp.FunctionCodeDao;
userFuncDao = scApp.UserFuncDao;
userGroupDao = scApp.UserGroupDao;
}
public ActionResult Index(string searchString, int page = 1, int pageSize = 5)
{
var dao = new UserGroupDao();
var model = dao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public JsonResult GetDetail(string id)
{
var model = new UserGroupDao().GetByID(id);
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除当前用户
/// </summary>
public void DeleteUser()
{
Logger.Instance.WriteLog("删除当前用户");
UserBasicDao ubdao = new UserBasicDao();
ubdao.Delete001(UIRecord.UBInfo.ID);
UserGroupDao ugDao = new UserGroupDao();
ugDao.Delete001(UIRecord.UBInfo.ID);
UserRecordManage.Instance.GetComponent <UserRecordManage> ().ReLoadUserRecord();
}
public void SetViewBag(string userGroupID = null)
{
var dao = new UserGroupDao();
if (userGroupID != null)
{
var selectedId = dao.ViewDetail(userGroupID).ID;
ViewBag.GroupID = new SelectList(dao.ListAll(), "ID", "Name", selectedId);
}
else
{
var selectedId = dao.ViewDetail("MEMBER").ID;
ViewBag.GroupID = new SelectList(dao.ListAll(), "ID", "Name", selectedId);
}
}
public JsonResult SaveData(string strUserGroup)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
UserGroup userGroup = serializer.Deserialize <UserGroup>(strUserGroup);
bool status = false;
string action = string.Empty;
string message = string.Empty;
bool res = new UserGroupDao().CheckIDExist(userGroup.ID);
if (res)
{
var model = new UserGroupDao();
try
{
model.Insert(userGroup);
status = true;
action = "insert";
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
else
{
//update existing DB
//save db
try
{
var model = new UserGroupDao().Update(userGroup);
status = true;
action = "update";
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
return(Json(new
{
status = status,
message = message,
action = action
}));
}
public void TestMappingSetting()
{
var userGroup = new UserGroup("Name");
userGroup.Comment = "Comment";
user1.AddTo(userGroup);
user2.AddTo(userGroup);
var userGroupDao = new UserGroupDao();
userGroupDao.SaveOrUpdate(userGroup);
Assert.AreNotEqual(Guid.Empty, userGroup.Id);
UserGroup ug1 = userGroupDao.Get(userGroup.Id);
Assert.AreEqual(userGroup.Name, ug1.Name);
Assert.AreEqual(userGroup.Comment, ug1.Comment);
}
public ActionResult Create(NhomTK tt)
{
if (ModelState.IsValid)
{
var dao = new UserGroupDao();
long id = dao.Insert(tt);
if (id > 0)
{
SetAlert("Thêm nhóm user thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
ModelState.AddModelError("", "Thêm nhóm tài khoản không thành công");
}
}
return(View("Index"));
}
public ActionResult Edit(NhomTK tt)
{
if (ModelState.IsValid)
{
var dao = new UserGroupDao();
var result = dao.Update(tt);
if (result)
{
SetAlert("Sửa thông tin nhóm tài khoản thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
ModelState.AddModelError("", "Cập nhật nhóm tài khoản không thành công");
}
}
return(View("Index"));
}
public ActionResult Create(UserGroup model)
{
if (ModelState.IsValid)
{
var dao = new UserGroupDao();
string id = dao.Insert(model);
if (id != null)
{
SetAlert("Thêm user group thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
SetAlert("Thêm user group thất bại", "error");
ModelState.AddModelError("", "Thêm user thất bại");
}
}
return(View("Index"));
}
public static void Reset()
{
_databaseApi = null;
_accessTokenDao = null;
_administratorDao = null;
_administratorsInRolesDao = null;
_areaDao = null;
_channelDao = null;
_channelGroupDao = null;
_configDao = null;
_contentCheckDao = null;
_contentDao = null;
_contentGroupDao = null;
_contentTagDao = null;
_databaseDao = null;
_dbCacheDao = null;
_departmentDao = null;
_errorLogDao = null;
_keywordDao = null;
_logDao = null;
_permissionsInRolesDao = null;
_pluginConfigDao = null;
_pluginDao = null;
_recordDao = null;
_relatedFieldDao = null;
_relatedFieldItemDao = null;
_roleDao = null;
_siteDao = null;
_siteLogDao = null;
_sitePermissionsDao = null;
_specialDao = null;
_tableStyleDao = null;
_tableStyleItemDao = null;
_tagDao = null;
_templateDao = null;
_templateLogDao = null;
_templateMatchDao = null;
_userDao = null;
_userGroupDao = null;
_userLogDao = null;
_userMenuDao = null;
}
public ActionResult Edit(UserGroup model)
{
if (ModelState.IsValid)
{
var dao = new UserGroupDao();
var result = dao.Update(model);
if (result)
{
SetAlert("Cập nhật user group thành công", "success");
return(RedirectToAction("Index", "UserGroup"));
}
else
{
SetAlert("Cập nhật user group thất bại", "error");
ModelState.AddModelError("", "Cập nhật user group thất bại");
}
}
return(View("Index"));
}
public void TestMappingSetting()
{
var userGroup = new UserGroup("Name");
userGroup.Comment = "Comment";
user1.AddTo(userGroup);
user2.AddTo(userGroup);
var userGroupDao = new UserGroupDao();
userGroupDao.SaveOrUpdate(userGroup);
Assert.AreNotEqual(Guid.Empty, userGroup.Id);
UserGroup ug1 = userGroupDao.Get(userGroup.Id);
Assert.AreEqual(userGroup.Name, ug1.Name);
Assert.AreEqual(userGroup.Comment, ug1.Comment);
}
public void Confirm()
{
Logger.Instance.WriteLog("保存修改后的用户信息");
UserRecordItem tempItem = null;
if (UIRecord.UBInfo.Status == "新建")
{
return;
}
else
{
UserBasicDao ubdao = new UserBasicDao();
ubdao.Update003(userName.value, UIRecord.UBInfo.Password, userMobile.value,
userAdd.value, remark.value, UIRecord.UBInfo.ID);
}
for (int i = 0; i < Records.transform.childCount; i++)
{
tempItem = Records.transform.GetChild(i).GetComponent <UserRecordItem>();
if (tempItem.LblAccount.text == UIRecord.UBInfo.UserName)
{
UIRecord.UBInfo.Telphone = userMobile.value;
UIRecord.UBInfo.Address = userAdd.value;
UIRecord.UBInfo.RealName = userName.value;
UIRecord.UBInfo.Memo = remark.value;
break;
}
}
string gstr = string.Empty;
foreach (UILabel lab in groups)
{
if (lab.transform.parent.GetComponent <userGroupItem>().selectToggle.value)
{
gstr = lab.text;
break;
}
}
UIRecord.GInfo.Name = gstr;
GroupDao gpDao = new GroupDao();
gpDao.Select003();
List <GroupInfo> gpInfos = gpDao.Result;
foreach (GroupInfo info in gpInfos)
{
if (gstr == info.Name)
{
UserGroupDao ugDao = new UserGroupDao();
if (UIRecord.UBInfo.Status == "新建")
{
ugDao.Insert001(UIRecord.UBInfo.ID, info.Id);
UIRecord.UBInfo.Status = "正常";
}
else
{
ugDao.Update001(info.Id, UIRecord.UBInfo.ID);
break;
}
}
}
if (tempItem != null)
{
tempItem.SetValue(UIRecord);
}
//ReLoadUserRecord();
}
public void SetDropdownList(string selectedId = null)
{
var dao = new UserGroupDao();
ViewBag.UserGroupID = new SelectList(dao.ListAll(), "ID", "Name", selectedId);
}
public void PostGroupIDViewBag(string selectId)
{
var dao = new UserGroupDao();
ViewBag.GroupID = new SelectList(dao.ListAll(), "ID", "Name", selectId);
}
////Other methods
//Set ViewBag for GroupID options
public void SetGroupIDViewBag()
{
var dao = new UserGroupDao();
ViewBag.GroupID = new SelectList(dao.ListAll(), "ID", "Name");
}
public void SetViewBag(string selectedID = null)
{
var dao = new UserGroupDao();
ViewBag.GroupID = new SelectList(dao.ListAll(), "ID", "Name", selectedID);
}
public WindownApplication()
{
ViewerID = getString("Viewer_ID", "");
webClientManager = WebClientManager.getInstance();
ObjCacheManager = new ObjCacheManager(this);
elasticSearchManager = new ElasticSearchManager();
RailDao = new RAILDao();
AddressDao = new ADDRESSDao();
PortIconDao = new PortIconDao();
PointDao = new POINTDao();
GroupRailDao = new GROUPRAILSDao();
SegmentDao = new SegmentDao();
SectionDao = new SectionDao();
PortDao = new PortDao();
VehicleDao = new VehicleDao();
UserDao = new UserDao();
UserGroupDao = new UserGroupDao();
UserFuncDao = new UserFuncDao();
FunctionCodeDao = new FunctionCodeDao();
CMD_OHTCDao = new CMD_OHTCDao();
CMD_MCSDao = new CMD_MCSDao();
VCMD_MCSDao = new VCMD_MCSDao();
PortStationDao = new PortStationDao();
AlarmDao = new AlarmDao();
MapBLL = new MapBLL(this);
UserBLL = new UserBLL(this);
OperationHistoryBLL = new OperationHistoryBLL(this);
CmdBLL = new CmdBLL(this);
AlarmBLL = new AlarmBLL(this);
PortStationBLL = new PortStationBLL(this);
SegmentBLL = new SegmentBLL(this);
ObjCacheManager.start();
ID = ObjCacheManager.MapId;
LineBLL = new LineBLL(this);
VehicleBLL = new VehicleBLL(this);
SysExcuteQualityBLL = new SysExcuteQualityBLL(this);
dBTableWatcher = new EventAction.DBTableWatcher(this);
dBTableWatcher.initStart();
// setEFConnectionString(ObjCacheManager.EFConnectionString);
SysExcuteQualityQueryService = new SysExcuteQualityQueryService(this);
//initBackgroundWork();
// SysExcuteQualityQueryService = new SysExcuteQualityQueryService();
switch (WindownApplication.OHxCFormMode)
{
case OHxCFormMode.CurrentPlayer:
natsManager = new NatsManager(ID, "nats-cluster", ViewerID);
redisCacheManager = new RedisCacheManager(ID);
SubscriberNatsEvent();
SubscriberDBTableWatcherEvent();
//SysExcuteQualityQueryService.start();
break;
case OHxCFormMode.HistoricalPlayer:
HistoricalReplyService = new HistoricalReplyService(this);
//HistoricalReplyService.loadVhHistoricalInfo();
break;
}
//VehicleBLL.ReguestViewerUpdate();
}
void SetUserGroupViewBag()
{
var dao = new UserGroupDao();
ViewBag.UserGroups = dao.GetUserGroups().ToList();
}
public ActionResult Edit(string id)
{
var userGroup = new UserGroupDao().ViewDetail(id);
return(View(userGroup));
}
