public static ArrayList GetList(int id)
{
string sql = "SELECT uv.*, u.FIO FROM UserVisits AS uv INNER JOIN Users AS u ON u.[Id] = uv.[UserId] WHERE u.[Id] = " + id.ToString();
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.UserVisits.UserVisits_WideDetails det = new DBLayer.UserVisits.UserVisits_WideDetails();
det.UserId = Convert.ToInt32(dr["UserId"]);
det.UserFIO = dr["FIO"].ToString();
det.Date = Convert.ToDateTime(dr["Date"]);
det.Id = Convert.ToInt32(dr["Id"]);
det.TimeOn = dr["TimeOn"].ToString();
det.TimeOff = dr["TimeOff"].ToString();
al.Add(det);
}
return(al);
}
private void LoadData()
{
ArrayList al = DBLayer.UserVisits.GetList();
DataTable dt = new DataTable();
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("User");
dt.Columns.Add("TimeOn");
dt.Columns.Add("TimeOff");
for (int i = 0; i < al.Count; i++)
{
DBLayer.UserVisits.UserVisits_WideDetails det = (DBLayer.UserVisits.UserVisits_WideDetails)al[i];
DataRow dr = dt.Rows.Add();
dr["Date"] = det.Date;
dr["User"] = det.UserFIO;
dr["TimeOn"] = det.TimeOn;
dr["TimeOff"] = det.TimeOff;
}
grVisits.DataSource = dt;
advBandedGridView1.BestFitColumns();
}