private void CreateGrid(int RptID)
{
DataTable tb = new DataTable();
switch (RptID)
{
case 1:
string AccountID = MyCommon.GetSelectedID(cmbPara3, true);
dgvAccounts.ColumnCount = 8;
dgvAccounts.Columns[0].Name = "Trans ID";
dgvAccounts.Columns[1].Name = "Description";
dgvAccounts.Columns[1].Width = 350;
dgvAccounts.Columns[2].Name = "Main Ref";
dgvAccounts.Columns[2].Width = 100;
dgvAccounts.Columns[3].Name = "Rel Ref";
dgvAccounts.Columns[4].Name = "Voucher";
dgvAccounts.Columns[5].Name = "Date";
dgvAccounts.Columns[6].Name = "Debit";
dgvAccounts.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvAccounts.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvAccounts.Columns[7].Name = "Credit";
tb = MyAccount.GetEachLedger(AccountID, Program.AccountStatic.CurrentAccPeriod, chkinFCur.Checked);
MyCommon.LoadDatatoTableWithoutBind(dgvAccounts, tb, "Load Each ledgers");
break;
case 2:
dgvAccounts.ColumnCount = 8;
dgvAccounts.Columns[0].Name = "Trans ID";
dgvAccounts.Columns[1].Name = "Account";
dgvAccounts.Columns[1].Width = 100;
dgvAccounts.Columns[2].Name = "Account Name";
dgvAccounts.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvAccounts.Columns[2].Width = 250;
dgvAccounts.Columns[3].Name = "Description";
dgvAccounts.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvAccounts.Columns[3].Width = 300;
dgvAccounts.Columns[4].Name = "Date";
dgvAccounts.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvAccounts.Columns[5].Name = "Voucher";
dgvAccounts.Columns[5].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvAccounts.Columns[6].Name = "Debit";
dgvAccounts.Columns[6].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvAccounts.Columns[7].Name = "Credit";
dgvAccounts.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
if (chkinFCur.Checked)
{
tb = MyAccount.GetGeneralLedger(Program.AccountStatic.CurrentAccPeriod, true, chKWithSub.Checked, dtrTo.Value);
}
else
{
tb = MyAccount.GetGeneralLedger(Program.AccountStatic.CurrentAccPeriod, false, chKWithSub.Checked, dtrTo.Value);
}
MyCommon.LoadDatatoTableWithoutBind(dgvAccounts, tb, "Load Each ledgers");
break;
case 3:
dgvAccounts.ColumnCount = 4;
dgvAccounts.Columns[0].Name = "Account ID";
dgvAccounts.Columns[1].Name = "Account Name";
dgvAccounts.Columns[1].Width = 300;
dgvAccounts.Columns[2].Name = "Debit";
dgvAccounts.Columns[2].Width = 100;
dgvAccounts.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvAccounts.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvAccounts.Columns[3].Name = "Credit";
dgvAccounts.Columns[3].Width = 100;
int cht = 0;
if (chKWithSub.CheckState == CheckState.Checked)
{
cht = 1;
}
else
{
cht = 0;
}
tb = MyAccount.GetTrialBalance(Program.AccountStatic.CurrentAccPeriod, dtrTo.Value, cht);
MyCommon.LoadDatatoTableWithoutBind(dgvAccounts, tb, "Load Trial balance");
CalTotalTrialbalanceTotal();
string delete1 = "Delete from tbltrialbalance where UseName='" + Program.AccountStatic.UserName + "'";
string respond2 = MyCommon.ExicuteAnyCommandAccount(delete1, "SAve Trial Balance");
foreach (DataRow rm in tb.Rows)
{
string sql1 = "Insert into tbltrialbalance values(" + Program.AccountStatic.CompanyID + ",'"
+ rm["AccountID"].ToString() + "','"
+ rm["AccountName"].ToString() + "',"
+ rm["FinalBalanceDr"].ToString() + ","
+ rm["FinalBalanceCr"].ToString() + ",'" + Program.AccountStatic.UserName + "')";
string respond = MyCommon.ExicuteAnyCommandAccount(sql1, "SAve Trial Balance");
}
break;
case 4:
AccountID = MyCommon.GetSelectedID(cmbPara3, true);
dgvAccounts.ColumnCount = 3;
dgvAccounts.Columns[0].Name = "Account ID";
dgvAccounts.Columns[1].Name = "Account Name";
dgvAccounts.Columns[1].Width = 300;
dgvAccounts.Columns[2].Name = "Amount";
dgvAccounts.Columns[2].Width = 100;
dgvAccounts.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
tb = MyAccount.GetSupplierOutstanding(AccountID, dtrTo.Value, Program.AccountStatic.CompanyID);
MyCommon.LoadDatatoTableWithoutBind(dgvAccounts, tb, "Load Supplier Outstanding");
break;
default:
break;
}
}