public static ArrayList GetList(int id)
{
string sql = "SELECT ua.[Id], ua.UserId, ua.AdministratorId, a.[FIO] AS AdminName, u.FIO ";
sql += " FROM UserAdministrator AS ua INNER JOIN Administrators AS a ON ua.[AdministratorId] = a.[Id] ";
sql += " INNER JOIN Users AS u ON u.[Id] = ua.UserId WHERE ua.UserId = " + id.ToString();
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.UserAdministrator.UserAdministrator_WideDetails det = new DBLayer.UserAdministrator.UserAdministrator_WideDetails();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
//det.AdminName = dr["AdminName"].ToString();
det.UserName = dr["FIO"].ToString();
if (!dr.IsNull("UserId"))
{
det.UserId = Convert.ToInt32(dr["UserId"]);
}
if (!dr.IsNull("AdministratorId"))
{
det.AdministratorId = Convert.ToInt32(dr["AdministratorId"]);
}
al.Add(det);
}
return(al);
}
private void LoadAdminsData()
{
ArrayList al = DBLayer.UserAdministrator.GetList(this.Id);
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("FIO");
for (int i = 0; i < al.Count; i++)
{
DBLayer.UserAdministrator.UserAdministrator_WideDetails det = (DBLayer.UserAdministrator.UserAdministrator_WideDetails)al[i];
DataRow dr = dt.Rows.Add();
dr["Id"] = det.Id;
dr["FIO"] = det.AdministratorName;
}
grAdmins.DataSource = dt;
advBandedGridView2.BestFitColumns();
}
