private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == Row_Type.Index) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Type); if (frm.ShowDialog() == DialogResult.OK) { if (dgv.Rows[e.RowIndex].IsNewRow == true) { dgv.Rows.Add(); } dgv[Row_Type.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); for (int c = Row_Accounts.Index; c <= Row_Divide_By_Amt.Index; c++) { dgv[c, e.RowIndex].Value = dgv[c, e.RowIndex].DefaultNewRowValue; } } } else if (dgv[Row_Type.Index, e.RowIndex].FormattedValue.ToString() == "DTL" && (e.ColumnIndex == Row_Accounts.Index || e.ColumnIndex == Row_Divide_By_Acc.Index)) { FrmGLAccount_Select frm = new FrmGLAccount_Select(); if (frm.ShowDialog() == DialogResult.OK) { dgv[e.ColumnIndex, e.RowIndex].Value = frm.MyValue.Trim(); if (dgv[Row_Desc.Index, e.RowIndex].FormattedValue.ToString().Trim() == "") { dgv[Row_Desc.Index, e.RowIndex].Value = DataClass.ReturnRecordNameByID("Select AccountName From GLAccounts Where AccountNumber = '" + frm.MyValue.Trim() + "'"); } } } else if (e.ColumnIndex == Row_Divide_By_Amt.Index && dgv[Row_Type.Index, e.RowIndex].FormattedValue.ToString() == "DTL") { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Divide_By_Amt); if (frm.ShowDialog() == DialogResult.OK) { if (frm.selrow.Cells[0].FormattedValue.ToString() == "Num") { FrmInsertText frmNum = new FrmInsertText("double", false, false); if (frmNum.ShowDialog() == DialogResult.OK) { dgv[Row_Divide_By_Amt.Index, e.RowIndex].Value = frmNum.MyValue.Trim(); } } else { dgv[Row_Divide_By_Amt.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "System Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnRow_Code_Click(object sender, EventArgs e) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DataClass.RetrieveData("SELECT GRC.Row_Code, GRC.Row_Name, GRC.Active, GRC.User_ID, dbo.Users.UserName FROM dbo.G_Report_Row AS GRC LEFT OUTER JOIN dbo.Users ON GRC.User_ID = dbo.Users.UserID")); if (frm.ShowDialog() == DialogResult.OK) { txtRow_Code.Text = frm.selrow.Cells[0].FormattedValue.ToString(); } }
private void btnFind_Click(object sender, EventArgs e) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DataClass.RetrieveData("SELECT GR.Rpt_Code, GR.Rpt_Name, GR.Col_Code, GR.Row_Code, GR.Paper_Size, GR.StylePaper, GR.Rpt_Font, GR.Daily_Rev, GR.Active, GR.User_ID, dbo.Users.UserName FROM dbo.G_Report AS GR LEFT OUTER JOIN dbo.Users ON GR.User_ID = dbo.Users.UserID")); if (frm.ShowDialog() == DialogResult.OK) { FindReport(frm.selrow.Cells[0].FormattedValue.ToString()); } }
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == Col_Type.Index) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Type); if (frm.ShowDialog() == DialogResult.OK) { if (dgv.Rows[e.RowIndex].IsNewRow == true) { dgv.Rows.Add(); } dgv[Col_Type.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); for (int c = Col_Source.Index; c <= Col_Calc_Divide.Index; c++) { dgv[c, e.RowIndex].Value = dgv[c, e.RowIndex].DefaultNewRowValue; } } } else if (e.ColumnIndex == Col_Source.Index && (dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "GL" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "DB" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "CR")) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Source); if (frm.ShowDialog() == DialogResult.OK) { dgv[Col_Source.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); } } else if (e.ColumnIndex == Col_Range.Index && (dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "GL" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "DB" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "CR")) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Range); if (frm.ShowDialog() == DialogResult.OK) { dgv[Col_Range.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); } } else if (e.ColumnIndex == Col_Period.Index && (dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "GL" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "DB" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "CR")) { FrmDgv frm = new FrmDgv(); frm.MyView = new DataView(DT_Period); if (frm.ShowDialog() == DialogResult.OK) { dgv[Col_Period.Index, e.RowIndex].Value = frm.selrow.Cells[0].FormattedValue.ToString(); } } if (dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "CALC" && dgv[Col_Header.Index, e.RowIndex].FormattedValue.ToString().Trim() == "") { dgv[Col_Header.Index, e.RowIndex].Value = "Variance"; } else if ((dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "GL" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "DB" || dgv[Col_Type.Index, e.RowIndex].FormattedValue.ToString() == "CR") && dgv[Col_Header.Index, e.RowIndex].FormattedValue.ToString().Trim() == "") { DataRow[] drs = DT_Source.Select("Code = '" + dgv[Col_Source.Index, e.RowIndex].FormattedValue.ToString() + "'"); if (drs.Length > 0) { dgv[Col_Header.Index, e.RowIndex].Value = drs[0][1].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "System Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }