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