private void 填写原因ToolStripMenuItem_Click(object sender, EventArgs e) { var sheet = Datas.ActiveSheet; var rows = FarPointExtensions.GetSelectionRows(sheet); var ids = new List <string>(); if (rows.Length > 0) { var form = new TestOverTimeReason(new Guid(sheet.Cells[rows[0].Index, 10].Value.ToString()), OverTimeTable); //form.FormClosed += new FormClosedEventHandler(TestOverTimeProcess_FormClosed); form.Show(); } //Row Row = spread_test_overtime.ActiveSheet.ActiveRow; //if (Row != null) //{ // DataRow r = Row.Tag as DataRow; // if (r == null) // { // return; // } // Guid id = new Guid(r["ID"].ToString()); // TestOverTimeReason totr = new TestOverTimeReason(id); // totr.ShowDialog(); //} }
private void 填写原因ToolStripMenuItem_Click(object sender, EventArgs e) { var sheet = spread_test_overtime.ActiveSheet; var rows = FarPointExtensions.GetSelectionRows(sheet); var ids = new List <string>(); if (rows.Length > 0) { var form = new TestOverTimeReason(new Guid(sheet.Cells[rows[0].Index, 0].Value.ToString()), OverTimeTable); form.Show(); } }
public Guid GetSelectionModuleID() { var rows = FarPointExtensions.GetSelectionRows(TableModules.ActiveSheet); if (rows != null && rows.Length > 0) { var tag = TableModules.ActiveSheet.Cells[rows[0].Index, 0].Tag; return(new Guid(Convert.ToString(tag))); } return(Guid.Empty); }
private void 处理ToolStripMenuItem_Click(object sender, EventArgs e) { var sheet = spread_test_overtime.ActiveSheet; var rows = FarPointExtensions.GetSelectionRows(sheet); var ids = new List <string>(); foreach (var row in rows) { var form = new TestOverTimeProcess(new Guid(sheet.Cells[row.Index, 0].Value.ToString()), OverTimeTable); form.FormClosed += new FormClosedEventHandler(TestOverTimeProcess_FormClosed); form.Show(); } }
private void bt_approval_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tb_process.Text)) { MessageBox.Show("请填写处理结果", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } var rows = FarPointExtensions.GetSelectionRows(Sheet); var ids = new List <Guid>(); if (ApplyAll.Checked) { foreach (Row row in Sheet.Rows) { if (row.Tag == null) { continue; } var id = new Guid(row.Tag.ToString()); ids.Add(id); } } else { foreach (var row in rows) { var id = new Guid(row.Tag.ToString()); if (id == null) { continue; } ids.Add(id); } } if (ids.Count == 0) { MessageBox.Show("请选择要处理的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { ProcessOverTime(1, ids.ToArray()); } }
private void btnReset_Click(object sender, EventArgs e) { var rows = FarPointExtensions.GetSelectionRows(Sheet); var ids = new List <Guid>(); if (ApplyAll.Checked) { foreach (Row row in Sheet.Rows) { if (row.Tag == null) { continue; } var id = new Guid(row.Tag.ToString()); ids.Add(id); } } else { foreach (var row in rows) { var id = new Guid(row.Tag.ToString()); if (id == null) { continue; } ids.Add(id); } } if (ids.Count == 0) { MessageBox.Show("请选择要处理的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { CaiJiHelperClient.UpdateTestOverTimeStatus(ids.ToArray(), 0); SetDataSource(); this.Close(); //ProcessOverTime(1, ids.ToArray()); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { var sheet = spread_test_overtime.ActiveSheet; var rows = FarPointExtensions.GetSelectionRows(sheet); if (rows == null || rows.Length == 0) { MessageBox.Show("没有选中要删除的数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } var ids = new List <string>(); foreach (var row in rows) { ids.Add(sheet.Cells[row.Index, 0].Value.ToString()); } DocumentHelperClient.DeleteTestOverTime(ids); BindTestOverTime(Yqun.Common.ContextCache.ApplicationContext.Current); }
private void OverTimeMenu_Opening(object sender, CancelEventArgs e) { var rows = FarPointExtensions.GetSelectionRows(spread_test_overtime.ActiveSheet); if (rows == null || rows.Length == 0) { return; } var row = rows[0].Tag as DataRow; if (row == null) { return; } if (userType.IndexOf("监理") > 0) { var code = Convert.ToString(row["TestRoomCode"]); 填写原因ToolStripMenuItem.Visible = Yqun.Common.ContextCache.ApplicationContext.Current.InTestRoom.Code == code; } }
private void SetStatisticsTable() { var map = ""; var columns = new List <StatisticsSetting>(); var settings = new List <StatisticsModuleSetting>(); if (CurrentStatistics != null) { try { columns = JsonConvert.DeserializeObject <List <StatisticsSetting> >(CurrentStatistics.Columns); } catch (Exception e) { var m = JsonConvert.DeserializeObject <Dictionary <string, string> >(CurrentStatistics.Columns); columns = new List <StatisticsSetting>(); foreach (var key in m.Keys) { columns.Add(new StatisticsSetting() { ItemName = key, BindField = m[key], }); } } } if (columns == null) { columns = new List <StatisticsSetting>(); } if (SelectionModule != null) { map = Convert.ToString(SelectionModule["StatisticsMap"]); settings = JsonConvert.DeserializeObject <List <StatisticsModuleSetting> >(map); } if (settings == null) { settings = new List <StatisticsModuleSetting>(); } var fixIndex = 0; foreach (var column in columns) { var setting = settings.Find(m => m.StatisticsItemName == column.ItemName); if (setting == null) { settings.Insert(0, new StatisticsModuleSetting() { StatisticsItemName = column.ItemName, BindField = column.BindField }); fixIndex++; } } var sheet = CloneSheet(TableStatistics.ActiveSheet, settings.Count); var index = 0; foreach (var set in settings) { if (index < fixIndex) { FarPointExtensions.LockCell(sheet.Cells[index, 6], "#"); FarPointExtensions.LockCell(sheet.Cells[index, 1], "#"); FarPointExtensions.LockCell(sheet.Cells[index, 0], "#"); } sheet.Cells[index, 0].Value = set.StatisticsItemName; sheet.Cells[index, 1].Value = GetKey(set.BindField); sheet.Cells[index, 2].Value = set.SheetName; sheet.Cells[index, 2].Tag = set.SheetID; sheet.Cells[index, 3].Value = set.CellName; sheet.Cells[index, 3].Tag = set.CellName; index += 1; } TableStatistics.Sheets.Clear(); TableStatistics.Sheets.Add(sheet); sheet.CellChanged += new SheetViewEventHandler(TableStatistics_Sheet1_CellChanged); }
private void bt_save_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tb_reason.Text.Trim())) { MessageBox.Show("延时原因不能为空!"); return; } var ids = new List <Guid>(); if (chkAll.Checked) { for (int i = 0; i < Sheet.Rows.Count; i++) { var t = Sheet.Rows[i].Tag.ToString(); if (string.IsNullOrEmpty(t)) { continue; } ids.Add(new Guid(t)); } } else { var rows = FarPointExtensions.GetSelectionRows(Sheet); foreach (var row in rows) { var t = row.Tag.ToString(); if (string.IsNullOrEmpty(t)) { continue; } ids.Add(new Guid(t)); } } if (ids.Count <= 0) { MessageBox.Show("请选择要处理的数据!"); return; } try { CaiJiHelperClient.SubmitCommentMulti(ids.ToArray(), tb_reason.Text.Trim(), 2); SetDataSource(); MessageBox.Show("保存成功,请等待监理审批!"); if (chkAll.Checked) { this.Close(); } } catch { MessageBox.Show("保存失败,请联系管理员"); } //try //{ // CaiJiHelperClient.SubmitComment(id, tb_reason.Text.Trim()); // MessageBox.Show("保存成功"); //} //catch //{ // MessageBox.Show("保存失败,请联系管理员"); //} //this.Close(); }