/// <summary> /// Update the grid of the shared files. /// </summary> private void UpdateSharedFilesGrid() { DataGridViewRowCollection rows = this.SharedFilesGrid.Rows; if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { rows.Clear(); })); } else { rows.Clear(); } for (int i = 0; i < FilesList.Count; i++) { if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { rows.Add(FilesList.List[i].Name, FilesList.List[i].Size, FilesList.List[i].SHA1, FilesList.List[i].Path); })); } else { rows.Add(FilesList.List[i].Name, FilesList.List[i].Size, FilesList.List[i].SHA1, FilesList.List[i].Path); } } }
/// <summary> /// Update the grid of the downloads. /// </summary> private void UpdateDownloadGrid() { DataGridViewRowCollection rows = this.DownloadsGrid.Rows; if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { rows.Clear(); })); } else { rows.Clear(); } for (int i = 0; i < Downloader.Count; i++) { if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { rows.Add(Downloader.List[i].Name, Downloader.List[i].CurrentSize, Downloader.List[i].Progress, "SPEED", Downloader.List[i].Size, Downloader.List[i].SHA1); })); } else { rows.Add(Downloader.List[i].Name, (Downloader.List[i].Size - (Downloader.List[i].RemainingFilePacks * 16384)), Downloader.List[i].Progress, "SPEED", Downloader.List[i].Size, Downloader.List[i].SHA1); } } }
private void showAllGigs() { VenueGridRows.Clear(); foreach (XElement gig in doc.Element("Event_Guide").Elements("Gig")) { searchXMLForBand(gig); } }
private void PushElements() { listref.Clear(); listBox.Columns.Clear(); listBox.Columns.Add("text", "Data"); listBox.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; foreach (string i in list) { listref.Add(i); } }
/// <summary> /// Fills left column of columns assignment datagridview /// with entrys of Ogama aoi table database columns, /// or simple rectangle import columns. /// </summary> private void FillLeftAssignColumn() { DataGridViewRowCollection rows = this.dGVAssignments.Rows; rows.Clear(); switch (ImportAOI.AoiSettings.ImportMode) { case AOIImportModes.UseSimpleRectangles: rows.Add(new[] { "TrialID", string.Empty }); rows.Add(new[] { "NameOfShape", string.Empty }); rows.Add(new[] { "Left top corner X", string.Empty }); rows.Add(new[] { "Left top corner Y", string.Empty }); rows.Add(new[] { "Right bottom corner X", string.Empty }); rows.Add(new[] { "Right bottom corner Y", string.Empty }); rows.Add(new[] { "ShapeGroup", string.Empty }); break; case AOIImportModes.UseOgamaColumns: rows.Add(new[] { "TrialID", string.Empty }); rows.Add(new[] { "SlideNr", string.Empty }); rows.Add(new[] { "ShapeName", string.Empty }); rows.Add(new[] { "ShapeType", string.Empty }); rows.Add(new[] { "ShapeNumPts", string.Empty }); rows.Add(new[] { "ShapePts", string.Empty }); rows.Add(new[] { "ShapeGroup", string.Empty }); break; } }
/////////////////////////////////////////////////////////////////////////////// // Small helping Methods // /////////////////////////////////////////////////////////////////////////////// #region HELPER /// <summary> /// Fills left column of columns assignment datagridview /// with entrys of Ogama raw data database columns /// </summary> private void FillLeftAssignColumn() { DataGridViewRowCollection rows = this.dGVAssignments.Rows; rows.Clear(); string[] row0 = { "SubjectName", string.Empty }; string[] row1 = { "TrialSequence", string.Empty }; string[] row2 = { "TrialID", string.Empty }; string[] row3 = { "TrialImage", string.Empty }; string[] row4 = { "TrialCategory", string.Empty }; string[] row5 = { "Time", string.Empty }; string[] row6 = { "PupilDiaX", string.Empty }; string[] row7 = { "PupilDiaY", string.Empty }; string[] row8 = { "GazePosX", string.Empty }; string[] row9 = { "GazePosY", string.Empty }; string[] row10 = { "MousePosX", string.Empty }; string[] row11 = { "MousePosY", string.Empty }; rows.Add(row0); rows.Add(row1); rows.Add(row2); rows.Add(row3); rows.Add(row4); rows.Add(row5); rows.Add(row6); rows.Add(row7); rows.Add(row8); rows.Add(row9); rows.Add(row10); rows.Add(row11); }
private void UpdateTaskList() { List <model.Task> tasks = database.GetTasksForUser(user); DataGridViewRowCollection col = uxTaskList.Rows; col.Clear(); foreach (model.Task task in tasks) { StringBuilder taskCategories = new StringBuilder(); foreach (TaskCategory tc in task.TaskCategories) { taskCategories.Append(tc.Name); taskCategories.Append(", "); } if (taskCategories.Length >= 2) { taskCategories.Length -= 2; } if ((uxFilterDateRange.Checked && task.DueDate >= uxDateRange.SelectionStart && task.DueDate < uxDateRange.SelectionEnd) || (uxFilterUserGroup.Checked && task.UserGroup.UserGroupID.Equals(((UserGroup)uxUserGroup.SelectedItem).UserGroupID)) || (uxFilterOwner.Checked && task.Owner.UserID.Equals(user.UserID)) || (uxFilterNotCompleted.Checked && task.CompletionDate == null) || (uxFilterName.Checked && task.Name.ToUpper().Contains(uxTaskName.Text.ToUpper())) || (!uxFilterDateRange.Checked && !uxFilterUserGroup.Checked && !uxFilterOwner.Checked && !uxFilterNotCompleted.Checked && !uxFilterName.Checked)) { col.Add(new object[] { task, task.CompletionDate != null ? "Completed" : task.TaskState.Name, taskCategories.ToString(), task.UserGroup.Name, task.Owner.Name, task.DueDate, task.StartDate, task.CompletionDate != null ? task.CompletionDate.ToString() : "Not Completed" }); } } }
public void get_course_table(String c_table) { string[] course_table = new string[6] { "", "", "", "", "", "" }; rows = dataGridView1.Rows; rows.Clear(); HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument(); doc.LoadHtml(c_table); HtmlAgilityPack.HtmlNodeCollection nodes = doc.DocumentNode.SelectNodes("//table[@id='ctl00_MainContent_TabContainer1_tabCourseSearch_wcCourseSearch_gvWishListTimeTable']//tr"); //製作課表 for (int i = 1; i <= 14; i++) { HtmlAgilityPack.HtmlNode node = nodes[i]; for (int j = 1; j <= 6; j++) { if (node.ChildNodes[j].Attributes["class"].Value != "week" && node.ChildNodes[j].Attributes["class"].Value != "week w") { course_table[j - 1] = node.ChildNodes[j].InnerText; } } rows.Add(course_table[0], course_table[1], course_table[2], course_table[3], course_table[4], course_table[5]); Array.Clear(course_table, 0, course_table.Length); rows[i - 1].Resizable = DataGridViewTriState.False; } }
void LoadEntry(CompositeIsotopics comp_iso) { DataGridViewRowCollection rows = this.IsoDataGrid.Rows; rows.Clear(); string[] summ = new string[9]; summ[0] = comp_iso.pu_mass.ToString("F3"); summ[1] = comp_iso.pu238.ToString("F6"); summ[2] = comp_iso.pu239.ToString("F6"); summ[3] = comp_iso.pu240.ToString("F6"); summ[4] = comp_iso.pu241.ToString("F6"); summ[5] = comp_iso.pu242.ToString("F6"); summ[6] = comp_iso.pu_date.ToString("yyyy-MM-dd"); summ[7] = comp_iso.am241.ToString("F6"); summ[8] = comp_iso.am_date.ToString("yyyy-MM-dd"); rows.Add(summ); foreach (CompositeIsotopic ci in comp_iso.isotopicComponents) { string[] sub = new string[9]; sub[0] = ci.pu_mass.ToString("F3"); sub[1] = ci.pu238.ToString("F6"); sub[2] = ci.pu239.ToString("F6"); sub[3] = ci.pu240.ToString("F6"); sub[4] = ci.pu241.ToString("F6"); sub[5] = ci.pu242.ToString("F6"); sub[6] = ci.pu_date.ToString("yyyy-MM-dd"); sub[7] = ci.am241.ToString("F6"); sub[8] = ci.am_date.ToString("yyyy-MM-dd"); rows.Add(sub); } }
internal void AnalisaEntradas() { DataGridViewRowCollection RowsEntradas = frmFront.GetRows("dataGridEntradas"); RowsEntradas.Clear(); //TODO: continuar daqui }
void LoadSchemas() { if (this.cache == null) { if (this.Site != null) { this.cache = (SchemaCache)this.Site.GetService(typeof(SchemaCache)); } } items.Clear(); DataGridViewRowCollection col = this.dataGridView1.Rows; col.Clear(); if (this.cache != null) { foreach (CacheEntry e in this.cache.GetSchemas()) { Uri uri = e.Location; string filename = uri.IsFile ? uri.LocalPath : uri.AbsoluteUri; SchemaItem item = new SchemaItem(e.Disabled, e.TargetNamespace, filename); items.Add(item); int i = col.Add(item.Values); col[i].Tag = item; } } }
private void UpdateUserGroupList() { if (userGroup != null) { List <Role> roles = database.GetRoles(); DataGridViewRowCollection col = uxGroupTable.Rows; col.Clear(); foreach (KeyValuePair <User, Role> kvp in database.GetUsersInUserGroup(userGroup)) { DataGridViewRow row = new DataGridViewRow(); row.CreateCells(uxGroupTable); row.Cells[0].Value = kvp.Key; row.Cells[1].Value = kvp.Key.Email; row.Cells[2].Value = kvp.Value; col.Add(row); } uxGroupName.Text = userGroup.Name; uxOwner.Text = userGroup.Owner.Name; uxDescription.Text = userGroup.Description; } else { uxOwner.Text = user.Name; } }
private void ResourceGroupCombo_SelectedIndexChanged(object sender, EventArgs e) { // Grab the fields we'll want to pull MSProject.PjField colorFieldId = Globals.ThisAddIn.Application.FieldNameToFieldConstant(Globals.ThisAddIn.resourceColorField, MSProject.PjFieldType.pjResource); MSProject.PjField borderColorFieldId = Globals.ThisAddIn.Application.FieldNameToFieldConstant(Globals.ThisAddIn.resourceBorderColorField, MSProject.PjFieldType.pjResource); // Initialize the grid with the existing data String group = this.ResourceGroupCombo.SelectedItem.ToString(); DataGridViewRowCollection rows = this.ResourceColorGrid.Rows; rows.Clear(); int row = 0; foreach (MSProject.Resource res in Globals.ThisAddIn.Application.ActiveProject.Resources) { if (res.Group != group) { continue; } rows.Add(res.Name); rows[row].Cells[ColorColumn.Index].Style.BackColor = Globals.ThisAddIn.stringToColor(res.GetField(colorFieldId), Color.White); rows[row].Cells[ColorColumn.Index].Style.SelectionBackColor = Globals.ThisAddIn.stringToColor(res.GetField(colorFieldId), Color.White); rows[row].Cells[BorderColorColumn.Index].Style.BackColor = Globals.ThisAddIn.stringToColor(res.GetField(borderColorFieldId), Color.Black); rows[row].Cells[BorderColorColumn.Index].Style.SelectionBackColor = Globals.ThisAddIn.stringToColor(res.GetField(borderColorFieldId), Color.Black); row++; } }
/// <summary> /// Update the panel. /// </summary> public new void Update() { Thread t = new Thread(new ParameterizedThreadStart( delegate { DataGridViewRowCollection rows = FilesFoundGrid.Rows; // clear the dataGrid this.Invoke(new MethodInvoker(delegate { rows.Clear(); })); if (this.m_lastSearchedFile != null) { List <Lists.FilesFoundList.File> list = Lists.FilesFoundList.SearchFileByText(m_lastSearchedFile); for (int i = 0; i < list.Count; i++) { this.Invoke(new MethodInvoker(delegate { rows.Add(list[i].Name, Utilities.Converterer.AutoConvertSizeFromByte(list[i].Size), list[i].SHA1); })); } } } )); t.Name = "UpdateFileSearchPanel"; t.IsBackground = true; t.Start(); }
/// <summary> /// Fills left column of columns assignment data grid view /// with entries of Ogama aoi table database columns /// </summary> private void FillLeftAssignColumn() { DataGridViewRowCollection rows = this.dGVAssignments.Rows; rows.Clear(); string[] row0 = { "SubjectName", string.Empty }; string[] row1 = { "TrialSequence", string.Empty }; string[] row2 = { "TrialID", string.Empty }; string[] row3 = { "TrialImage", string.Empty }; string[] row4 = { "CountInTrial", string.Empty }; string[] row5 = { "StartTime", string.Empty }; string[] row6 = { "EndTime", string.Empty }; string[] row7 = { "Length", string.Empty }; string[] row8 = { "PosX", string.Empty }; string[] row9 = { "PosY", string.Empty }; rows.Add(row0); rows.Add(row1); rows.Add(row2); rows.Add(row3); rows.Add(row4); rows.Add(row5); rows.Add(row6); rows.Add(row7); rows.Add(row8); rows.Add(row9); }
private void button1_Click(object sender, EventArgs e) { BandGridRows.Clear(); foreach (XElement gig in doc.Element("Event_Guide").Elements("Gig")) { searchXMLForBandMember(gig); } }
/// <summary> /// Populates a DataGridView's rows with details of all users, with 1 user per row. /// </summary> /// <param name="rows"></param> public static void PopulateDataGridView(DataGridViewRowCollection rows) { rows.Clear(); foreach (User user in _userDatabase.UserList) { rows.Add(user.ID, user.FullName, user.Role, user.UserName, user.Password); } }
PopulateSourceColumnsDataGridView() { AssertValid(); DataGridViewRowCollection oDataGridRows = dgvSourceColumns.Rows; oDataGridRows.Clear(); // Attempt to get the non-empty range of the active worksheet of the // selected source workbook. Range oNonEmptyRange; if (!TryGetSourceWorkbookNonEmptyRange(out oNonEmptyRange)) { return; } Boolean bSourceColumnsHaveHeaders = cbxSourceColumnsHaveHeaders.Checked; // Get the first row and column of the non-empty range. Range oFirstRow = oNonEmptyRange.get_Resize(1, Missing.Value); Range oColumn = oNonEmptyRange.get_Resize(Missing.Value, 1); Object [,] oFirstRowValues = ExcelUtil.GetRangeValues(oFirstRow); Int32 iNonEmptyColumns = oNonEmptyRange.Columns.Count; Int32 iColumnOneBased = oColumn.Column; for (Int32 i = 1; i <= iNonEmptyColumns; i++, iColumnOneBased++) { String sColumnLetter = ExcelUtil.GetColumnLetter( ExcelUtil.GetRangeAddress((Range)oColumn.Cells[1, 1])); // Get the value of the column's first cell, if there is one. String sFirstCellValue; if (!ExcelUtil.TryGetNonEmptyStringFromCell(oFirstRowValues, 1, i, out sFirstCellValue)) { sFirstCellValue = null; } String sItemText = GetSourceColumnItemText(sFirstCellValue, sColumnLetter, bSourceColumnsHaveHeaders); oDataGridRows.Add(new ObjectWithText(iColumnOneBased, sItemText), false, false, false); // Move to the next column. oColumn = oColumn.get_Offset(0, 1); } }
// this event handler will clear out the results from // the FileSystemWatcher private void onClear(object sender, EventArgs e) { var choice = MessageBox.Show("Do you really want to clear the table?", "Drive Watcher", MessageBoxButtons.YesNo); if (choice == DialogResult.Yes) { DataGridViewRowCollection coll = this.dataGrid.Rows; coll.Clear(); } }
private string cartSplash(Profile profile, DataGridViewCell cell, DataGridViewRowCollection rows) { cell.Value = "Waiting for HMAC...(check settings page)"; C_Proxy proxy = null; C_Session session = null; if (!proxy_running && profile.splashmode == 1) { Task.Run(() => runProxyList(profile, rows)); while (proxylist.FirstOrDefault(s => proxy.passed) == null) { System.Threading.Thread.Sleep(1000); } cell.Value = "GOT HMAC!"; proxy = proxylist.FirstOrDefault(s => proxy.passed && s.hmac_cookie.expiry > DateTime.Now); } else if (!sessions_running && profile.splashmode == 2) { for (int i = 0; i < Properties.Settings.Default.sessions_count; i++) { sessionlist.Add(new C_Session { refresh = false }); } for (int i = 0; i < Properties.Settings.Default.r_sessions_count; i++) { sessionlist.Add(new C_Session { refresh = true }); } rows.Clear(); foreach (C_Session s in sessionlist) { rows.Add(new string[] { "session", s.refresh.ToString(), "False", null, null, null, null, null, null }); } Task.Run(() => runSessionList(profile, rows)); while (sessionlist.FirstOrDefault(x => x.passed == true) == null) { System.Threading.Thread.Sleep(1000); } cell.Value = "GOT HMAC!"; session = sessionlist.FirstOrDefault(s => s.passed && s.hmac_cookie.expiry > DateTime.Now); } return(cartNoSplash(profile, cell, proxy, session)); }
public void Populate(string[][] data) { DataGridViewRowCollection rows = this.dataGrid.Rows; rows.Clear(); foreach (string [] d in data) { rows.Add(d[0], d[1]); int idx = rows.GetLastRow(DataGridViewElementStates.None); rows[idx].Cells[2].Tag = d[2]; } }
private void refreshDataGridView() { rows.Clear(); int rowIndex = 0; ArrayList hostCollection = monitorSystem.currentHosts(); foreach (Host host in hostCollection) { rows.Add(new Object[] { host.name(), host.ip(), host.status() }); Color statusColor = host.status() == "Up" ? Color.Green : Color.Red; dataGridView1.Rows[rowIndex].Cells[2].Style.BackColor = statusColor; rowIndex++; } }
public void LoadControlExample() { rows.Clear(); AddRow(1, 100, 80, 50, 60); AddRow(2, 90, 70, 60, 50); AddRow(3, 80, 50, 40, 40); AddRow(4, 100, 60, 70, 30); AddRow(5, 70, 80, 80, 70); AddRow(6, 70, 60, 80, 50); AddRow(7, 90, 40, 70, 60); AddRow(8, 80, 50, 60, 40); AddRow(9, 80, 70, 30, 70); AddRow(10, 60, 80, 40, 50); }
public void guestMode_Cart(Profile profile, DataGridViewRowCollection rows) { C_Proxy proxy = null; C_Session session = null; if (!proxy_running && profile.splashmode == 1) { Task.Run(() => runProxyList(profile, rows)); while (proxylist.FirstOrDefault(s => proxy.passed) == null) { System.Threading.Thread.Sleep(1000); } proxy = proxylist.FirstOrDefault(s => proxy.passed && s.hmac_cookie.expiry > DateTime.Now); MessageBox.Show("proxy_" + proxy.index.ToString() + " : on product page! Right click on the session and show the window in order to purchase the shoe!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (!sessions_running && profile.splashmode == 2) { for (int i = 0; i < Properties.Settings.Default.sessions_count; i++) { sessionlist.Add(new C_Session { refresh = false }); } for (int i = 0; i < Properties.Settings.Default.r_sessions_count; i++) { sessionlist.Add(new C_Session { refresh = true }); } rows.Clear(); foreach (C_Session s in sessionlist) { rows.Add(new string[] { "session_" + s.index.ToString(), s.refresh.ToString(), "False", null, null, null, null, null, null }); } Task.Run(() => runSessionList(profile, rows)); while (sessionlist.FirstOrDefault(x => x.passed == true) == null) { System.Threading.Thread.Sleep(1000); } session = sessionlist.FirstOrDefault(s => s.passed == true); MessageBox.Show("session_" + session.index.ToString() + " : on product page! Right click on the session and show the window in order to purchase the shoe!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
//Methods private void displayBandInfo() { //CLear data grid view rows dgvRows.Clear(); // Get the root element XElement evGuide = bandDoc.Element("Event_Guide"); foreach (XElement gig in evGuide.Elements("Gig")) { string bandName = gig.Element("Band").Element("Name").Value; string genre = gig.Element("Band").Element("Genre").Value; string venue = gig.Element("Venue").Value; string date = gig.Element("Date").Attribute("day").Value + "/" + gig.Element("Date").Attribute("month").Value + "/" + gig.Element("Date").Attribute("year").Value; string time = gig.Element("Time").Value; String[] newRowValue = { bandName, genre, venue, date, time }; // Add the string array to the row dgvRows.Add(newRowValue); } }
private void btnScanAP_Click(object sender, EventArgs e) { //fix: It should works even if wlaninterface doesn't connect to AP var client = new WlanClient(); WlanClient.WlanInterface[] apCount = client.Interfaces; DataGridViewRowCollection rows = this.dataGridView1.Rows; //define DataGridViewRowCollection rows for adding new APs rows.Clear(); //fix: Clear() previous records of AP after press down button second time. //fix: 2 string concatenate to form a new one to perform DataGridViewCollection.add(). foreach (WlanClient.WlanInterface APC in apCount) //loop all element returned by client.Interfaces with type WlanClient.WlanInterface { Wlan.WlanBssEntry[] bssNetworks = APC.GetNetworkBssList(); //exception occurs when WlanInterface doesn't connect to AP Wlan.WlanAvailableNetwork[] availableNetworks = APC.GetAvailableNetworkList(Wlan.WlanGetAvailableNetworkFlags.IncludeAllAdhocProfiles); foreach (Wlan.WlanBssEntry network in bssNetworks) { int rssi = network.rssi; byte[] macAddr = network.dot11Bssid; string tMac = ""; for (int i = 0; i < macAddr.Length; i++) { tMac += macAddr[i].ToString("x2").PadLeft(2, '0').ToUpper(); } /* * for (int i = 0; i < availableNetworks.Length; i++) * { * string AuthMech = availableNetworks[i].dot11DefaultAuthAlgorithm.ToString(); * string EncrypMech = availableNetworks[i].dot11DefaultCipherAlgorithm.ToString(); * string[] MechString = { "", "", "", "", AuthMech, EncrypMech }; * rows.Add(MechString); * * } */ //string[] row1 = { "hpinc", "3168", "-50", "36", "2F" }; for test only string[] APstring = { System.Text.ASCIIEncoding.ASCII.GetString(network.dot11Ssid.SSID).ToString(), network.rssi.ToString(), APC.Channel.ToString(), tMac, }; //DataGridViewRowCollection rows = this.dataGridView1.Rows; rows.Add(APstring); //APC.Scan(); } } }
private void loadSettings() { DataGridViewRowCollection rows = settingsTable.Rows; rows.Clear(); SettingsPropertyValueCollection settings = Properties.Settings.Default.PropertyValues; foreach (SettingsPropertyValue setting in settings) { string name = setting.Name; object value = setting.PropertyValue; string typeName = value.GetType().Name; object[] row = new object[] { name, typeName, value }; settingsTable.Rows.Add(row); } }
private void 輸出當月員工時數表ToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult Dr = MessageBox.Show("是否要輸出上個月員工時數表 ?", "詢問", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (Dr.Equals(DialogResult.OK)) { SaveFileDialog saveDia = new SaveFileDialog(); saveDia.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); saveDia.FileName = (DateTime.Now.Month - 1).ToString() + "月員工薪資與上班報表"; saveDia.Filter = "*.xlsx|*.xlsx"; if (saveDia.ShowDialog() != DialogResult.OK) { return; } excel.Application xls = null; try { xls = new excel.Application(); excel.Workbook book = xls.Workbooks.Add(); excel.Worksheet sheet = (excel.Worksheet)book.Worksheets.Item[1]; DataGridViewRowCollection DGVC = dataGridView_check.Rows; DGVC.Clear(); search_single_staff(sheet);//搜尋人 book.SaveAs(saveDia.FileName); } catch (Exception) { throw; } finally { dataGridView_check.Enabled = false; comboBox_Employee.Text = "選擇員工"; xls.Quit(); } //這邊近來Input_Employee_2combo 不用清掉 因為就是要上面Form inital的值 //搜尋當年當月的所以上班時數 //計算小時 //存入EXCEL // } }
public void setDefaultProject() { int row; // Setup the dialog ShotgunProjectsForm form = new ShotgunProjectsForm(); DataGridViewRowCollection rows = form.projectsGrid.Rows; rows.Clear(); dynamic projects = _pythonModule.GetVariable("projects")(); int selectedRow = -1; Hashtable rowToId = new Hashtable(); Hashtable rowToInst = new Hashtable(); Hashtable rowToName = new Hashtable(); foreach (dynamic project in projects) { if (project["name"] == "Template Project") { continue; } row = rows.Add(project["name"]); if (project["id"] == Properties.Settings.Default.ShotgunProject) { selectedRow = row; } rowToId[row] = project["id"]; rowToInst[row] = project["inst"]["name"]; rowToName[row] = project["name"]; } if (selectedRow != -1) { form.projectsGrid.CurrentCell = rows[selectedRow].Cells[0]; } // Show the dialog System.Windows.Forms.DialogResult result = form.ShowDialog(); if (result == DialogResult.Cancel) { return; } row = form.projectsGrid.SelectedRows[0].Index; Properties.Settings.Default.ShotgunProject = (int)rowToId[row]; Properties.Settings.Default.ShotgunInstance = (String)rowToInst[row]; Properties.Settings.Default.ShotgunProjectName = (String)rowToName[row]; Properties.Settings.Default.Save(); MessageBox.Show("Project set to \"" + (String)rowToName[row] + "\"."); }
private void PopulateTable() { dataGridView.CellValueChanged -= CellValueChangedHandler; DataGridViewRowCollection rows = dataGridView.Rows; rows.Clear(); for (int i = 0; i < enemies.Count; i++) { UpdateRow(rows.Add()); } UpdateRowHeaders(); dataGridView.AutoResizeColumns(); dataGridView.CellValueChanged += CellValueChangedHandler; }