void SaveAssignments() { if (!_dirty || _currEmployeeId < 1) { return; } _dirty = false; for (int i = _data.Assignments.Count - 1; i >= 0; i--) { ViewRow row = _data.Assignments.Rows[i]; if ((int)row["EmployeeID"] == _currEmployeeId) { row.Delete(); } } foreach (ProductTreeNode productNode in treeViewFeatures.Nodes) { foreach (FeatureTreeNode featureNode in productNode.Nodes) { if (featureNode.Checked) { ViewRow newRow = _data.Assignments.Rows.CreateRow(); newRow["EmployeeID"] = _currEmployeeId; newRow["ProductID"] = productNode.ProductID; newRow["FeatureID"] = featureNode.FeatureID; newRow.EndEdit(); } } } }
private void comboBoxCity_SelectedIndexChanged(object sender, EventArgs e) { // Display the customers of the selected city. ViewRow row = comboBoxCity.SelectedItem as ViewRow; if (row != null) { listBoxCustomers.DisplayMember = "ContactName"; listBoxCustomers.DataSource = ((dynamic)row.Value).Customers; } }
/// <summary> /// 获取数据行数据 /// </summary> /// <param name="sheet"></param> /// <param name="columns"></param> /// <param name="firstRow"></param> /// <param name="firstColumn"></param> /// <param name="fixRowCount"></param> /// <returns></returns> public List <ViewRow> ReadDataRowFromWorksheet(Worksheet sheet, List <ViewColumn> columns, int firstRow, int firstColumn, int fixRowCount) { columns = columns ?? new List <ViewColumn>(); var rows = new List <ViewRow>(); for (int i = 0; i <= sheet.Cells.MaxDataRow; i++) { if (i >= firstRow - 1) { ViewRow row = new ViewRow(); row.cells = new List <ViewCell>(); for (int j = 0; j <= sheet.Cells.MaxDataColumn; j++) { if (j >= firstColumn - 1) { var cel = sheet.Cells[i, j]; if (cel.IsMerged) { goto BREAKLOOP; } ViewCell cell = new ViewCell(); cell.content = cel.StringValue; row.cells.Add(cell); } } if (!row.cells.Any(x => !string.IsNullOrEmpty(x.content))) { goto BREAKLOOP; } rows.Add(row); } continue; BREAKLOOP: break; } if (rows.Count < fixRowCount) { var newRowCount = fixRowCount - rows.Count; for (int i = 0; i < newRowCount; i++) { ViewRow row = new ViewRow(); row.cells = new List <ViewCell>(); for (int j = 0; j < columns.Count; j++) { var cell = new ViewCell(); cell.content = ""; row.cells.Add(cell); } rows.Add(row); } } return(rows); }
private void btnAdd_Click(object sender, EventArgs e) { ViewRow newRow = _data.Issues.Rows.CreateRow(); newRow["IssueID"] = Int32.Parse(txtIssueID.Text); newRow["ProductID"] = (int)comboProduct.SelectedValue; newRow["FeatureID"] = (int)comboFeature.SelectedValue; newRow["Description"] = txtDescription.Text; newRow["AssignedTo"] = (int)comboAssignedTo.SelectedValue; newRow["Fixed"] = false; newRow.EndEdit(); Close(); }
private void buttonReassign_Click(object sender, EventArgs e) { ViewRow row = issuesBindingSource.Current as ViewRow; if (row == null) { return; } Issue issue = row.Value as Issue; if (issue == null) { return; } issue.I.AssignedTo = comboReassign.SelectedIndex; }
private void buttonAssign_Click(object sender, EventArgs e) { string msg = string.Empty; foreach (IssueAssignment ia in _issuesToAssign.ToList()) { ViewRow issueRow = _data.FindIssueByID(ia.IssueID); issueRow["AssignedTo"] = ia.EmployeeID; issueRow.EndEdit(); msg += "\nto " + ia.EmployeeName + " issue #" + ia.IssueID; } if (msg.Length == 0) { msg = "\nNone"; } msg = "Assigned issues:" + msg; MessageBox.Show(msg, "Assigned issues"); }
private void buttonReassign_Click(object sender, EventArgs e) { ViewRow row = issuesBindingSource.Current as ViewRow; if (row == null) { return; } IssueInfo issue = row.Value as IssueInfo; if (issue == null) { return; } IssueItem xIssue = _data.FindIssueByID(issue.IssueID); xIssue.AssignedTo = comboReassign.SelectedIndex; }
public ViewRowChangeEvent(ViewRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }
private double GetSecondsLeft(ViewRow <Dictionary <string, object> > viewRow) { var expiration = (long)viewRow.Value["expiration"]; return(UnixTimestampToSecondsLeft(expiration)); }