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(); }