public IActionResult GetUserList(UserSelect entity)
{
ResponseModel resModel = new ResponseModel((int)ResponseCode.Success, "查询人员成功");
try
{
UserSelect model = new UserSelect()
{
sfqy = entity.sfqy,
txcx = entity.txcx,
page_num = entity.page_num,
page_size = entity.page_size
};
//机构接口
var user = this.GetInstance <IUser>();
//调用业务接口
var result = user.GetSystemUserList(model)?.Result;
resModel.data = result;
}
catch (System.Exception e)
{
LogError("查询人员失败", e);
resModel.code = (int)ResponseCode.Error;
resModel.msg = "服务器内部异常";
}
return(Json(resModel));
}
public void SelectReassignTo(string username)
{
UserSelect.Click();
UserSelect.Element.SendKeys(username);
UserSelect.Element.FindXPath(".//*[contains(.,'" + username + "')]").Click();
browser.Select(username).From(UserSelect.Element.Id);
}
protected void Page_Load(object sender, EventArgs e)
{
mm = (MinMaster)Master;
if (!Page.IsPostBack)
{
MembershipUserCollection users = Membership.GetAllUsers();
List <CE.Project> projects = mm.SysDriver.GetProjectObjects();
object userId = (Membership.GetUser().ProviderUserKey);
int globalAccess = mm.SysDriver.GetUserRights(userId, null);
if (globalAccess >= 1000)
{
projects.Reverse();
projects.Add(new CE.Project(0, "All Projects", DbServer.MsSql, null, null, 0));
projects.Reverse();
}
else
{
List <CE.Project> inaccessible = new List <CE.Project>();
foreach (CE.Project p in projects)
{
if (mm.SysDriver.GetUserRights(userId, p.Id) < 1000)
{
inaccessible.Add(p);
}
}
foreach (CE.Project p in inaccessible)
{
projects.Remove(p);
}
}
UserSelect.DataSource = users;
UserSelect.DataValueField = "ProviderUserKey";
UserSelect.DataTextField = "UserName";
UserSelect.DataBind();
ProjectSelect.DataSource = projects;
ProjectSelect.DataValueField = "Id";
ProjectSelect.DataTextField = "Name";
ProjectSelect.DataBind();
SetCheckboxes();
}
}
public override void OnPageHandlerExecuting(PageHandlerExecutingContext context)
{
base.OnPageHandlerExecuting(context);
if (User.Identity.IsAuthenticated)
{
Data.Initialize(User, TempData);
if (IsOrgRequired(context) && !CurrentUser.OrganizationId.HasValue)
{
context.Result = new RedirectResult("/Setup/Organization?mustCreate=true");
return;
}
using (var cn = Data.GetConnection())
{
SwitchOrgs = new MySwitchOrgs()
{
CurrentOrgId = OrgId, UserId = UserId
}.Execute(cn);
AssignToUsers = new UserSelect()
{
OrgId = OrgId, IsEnabled = true
}.ExecuteItems(cn);
var teams = new Teams()
{
OrgId = OrgId
}.Execute(cn);
TeamUseApps = JsonConvert.SerializeObject(teams.ToDictionary(row => row.Id, row => row.UseApplications));
var options = new MyOptions()
{
UserId = UserId
}.Execute(cn);
Options = options.ToDictionary(row => row.OptionName);
HasNotifications = cn.RowExists("[dbo].[Notification] WHERE [SendTo]=@userName AND [Method]=3 AND [DateDelivered] IS NULL", new { userName = User.Identity.Name });
}
}
}
public void RePlanLog()
{
PlanLogTab.Clicks();
DprtmntSelect.WaitUntil();
DprtmntSelect.SelectDropdown("Granite City - GrC");
TeamSelect.WaitUntil();
TeamSelect.SelectDropdown("Test Team");
UserSelect.WaitUntil();
UserSelect.SelectDropdown("Automation User 1");
string timeStamp = DateTime.Now.ToString("M'/'d'/'yyyy");
Assert.IsTrue(Date.GetText().Equals(timeStamp));
}
/// <summary>
/// 分页查询人员列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ListPageModel <SystemUser> GetSystemUserList(UserSelect model)
{
ListPageModel <SystemUser> listPage = new ListPageModel <SystemUser>();
try
{
int total = 0;
var items = new List <SystemUser>();
var param = new List <string>();
using (var db = new DbContext())
{
var sqlBuilder = db.Sql("");
//查询条件
if (model.txcx.IsNotNullOrEmpty())
{
param.Add("查询条件");
sqlBuilder.Parameters("strwhere", model.txcx);
}
if (model.sfqy.IsNotNullOrEmpty())
{
param.Add("用户状态");
sqlBuilder.Parameters("SFQY", int.Parse(model.sfqy));
}
var sqlStr = db.GetSql("BA00003-分页查询人员列表", null, param.ToArray());
//执行SQL脚本
items = sqlBuilder.SqlText(sqlStr)
.Paging(model.page_num, model.page_size)
.GetModelList <SystemUser>(out total);
}
listPage.Total = total;
listPage.PageList = items;
return(listPage);
}
catch (Exception ex)
{
Logger.Instance.Error("获取人员异常错误!", ex);
}
return(listPage);
}
public void PlanLog()
{
PlanLogTab.WaitUntil();
PlanLogTab.Clicks();
DprtmntSelect.WaitUntil();
DprtmntSelect.SelectDropdown("Granite City - GrC");
TeamSelect.WaitUntil();
TeamSelect.SelectDropdown("Test Team");
UserSelect.WaitUntil();
UserSelect.SelectDropdown("Automation User 1");
Console.WriteLine("The selected Department is " + DprtmntSelect.GetTextFromDdL());
Console.WriteLine("The selected Team is " + TeamSelect.GetTextFromDdL());
Console.WriteLine("The selected User is " + UserSelect.GetTextFromDdL());
string timeStamp = DateTime.Now.ToString("M'/'d'/'yyyy");
Console.WriteLine("PC Date " + timeStamp);
Console.WriteLine("Plan/Log Date " + Date.GetText());
Assert.IsTrue(PlanStatus("Not Started").Displayed);
Assert.IsTrue(Date.GetText().Equals(timeStamp));
/*Calender.Clicks();
*
* for (var i = 0; i < 11; i++)
* {
*
* PrevDate.WaitUntil();
*
* PrevDate.Clicks();
* }
*
* SelectDate(26).Clicks();
*
* while (true)
* {
* if (PlanStatus.Text != "Not Started")
* {
* Calender.Clicks();
*
* for (var j = 0; j < 10; j++)
* {
* _count++;
*
* PrevDate.WaitUntil();
*
* PrevDate.Clicks();
* }
*
* SelectDate.Clicks();
* }
*
* else
* {
* break;
* }
* }*/
}
void Awake()
{
instance = this;
}
public Task <ListPageModel <SystemUser> > GetSystemUserList(UserSelect model)
{
ListPageModel <SystemUser> list = this.Logic.GetSystemUserList(model);
return(Task.FromResult(list));
}
