/// <summary>
/// 获取阅读范围
/// </summary>
/// <param name="NoteId"></param>
/// <returns></returns>
public ChooseUser ChooseUser(int NoteId)
{
List <NoteReadRange> list = _readrepository.Query(x => x.NoteId == NoteId).ToList();
ChooseUser chooseUser = new ChooseUser();
Note note = _repository.GetSingle(x => x.Id == NoteId);
chooseUser.sel_type = note.SelType;
chooseUser.user = (from a in list
where a.TypeId == OrgType.User
select new User
{
id = a.UserId,
name = a.UserName,
dpt_id = a.DptId,
dpt_name = a.DptName,
company_id = a.CompanyId,
company_name = a.CompanyName
}).ToList();
chooseUser.department = (from a in list
where a.TypeId == OrgType.Dep
select new Dep
{
id = a.DptId,
name = a.DptName,
company_id = a.CompanyId,
company_name = a.CompanyName
}).ToList();
chooseUser.company = (from a in list
where a.TypeId == OrgType.Com
select new Com
{
id = a.CompanyId,
name = a.CompanyName
}).ToList();
chooseUser.position = (from a in list
where a.TypeId == OrgType.Position
select new Position
{
id = a.PositionId,
name = a.PositionName,
company_id = a.CompanyId,
company_name = a.CompanyName
}).ToList();
chooseUser.dpt_position = new List <dpt_position>();
return(chooseUser);
}
private void fillChange()
{
ChooseCompany.Items.Clear();
ChooseUser.Items.Clear();
changeCompanyUser.Clear();
changeUserCompany.Clear();
conn = new SqlConnection("server=10.100.100.25\\SPLAHOST;Database=graphs;Integrated Security=false;User ID=petpakn;Password=net123321!;");
conn.Open();
// Create SqlCommand to select pwd field from users table given supplied userName.
cmd = new SqlCommand("select company_name from companies ", conn); /// Intepolation or the F string. C# > 5.0
// Execute command and fetch pwd field into lookupPassword string.
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
changeCompanyUser.Add(reader["company_name"].ToString());
}
// unit test
cmd.Dispose();
conn.Close();
ChooseCompany.DataSource = changeCompanyUser;
ChooseCompany.DataBind();
conn = new SqlConnection("server=10.100.100.25\\SPLAHOST;Database=graphs;Integrated Security=false;User ID=petpakn;Password=net123321!;");
conn.Open();
// Create SqlCommand to select pwd field from users table given supplied userName.
cmd = new SqlCommand("select uname from Users ", conn); /// Intepolation or the F string. C# > 5.0
// Execute command and fetch pwd field into lookupPassword string.
SqlDataReader reader2 = cmd.ExecuteReader();
while (reader2.Read())
{
changeUserCompany.Add(reader2["uname"].ToString());
}
// unit test
cmd.Dispose();
conn.Close();
ChooseUser.DataSource = changeUserCompany;
ChooseUser.DataBind();
}
private void ChooseUserButton_Click(object sender, RibbonControlEventArgs e)
{
ChooseUser CU = new ChooseUser();
CU.Show();
}