private void DBGrid_DoubleClick(object sender, EventArgs e)
{
if (DBGrid.CurrentRow == null)
{
return;
}
string statuslist = "9";
if (chkNotAudit.Checked)
{
statuslist += ",0";
}
if (chkAudited.Checked)
{
statuslist += ",1";
}
modAccExpenseSummary mod = (modAccExpenseSummary)DBGrid.CurrentRow.DataBoundItem;
BindingCollection <modAccExpenseForm> list = _dal.GetIList(statuslist, string.Empty, mod.ExpenseId, mod.ExpenseMan, dtpFrom.Text, dtpTo.Text, out Util.emsg);
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Account Expense Form"), list);
frm.ShowDialog();
}
}
/// <summary>
/// get all accexpensesummary
/// <summary>
/// <param name=validonly>status is valid</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all accexpenseform</returns>
public BindingCollection <modAccExpenseSummary> GetExpenseSummary(string statuslist, string idlist, string expenseidlist, string expensemanlist, string fromdate, string todate, out string emsg)
{
try
{
BindingCollection <modAccExpenseSummary> modellist = new BindingCollection <modAccExpenseSummary>();
//Execute a query to read the categories
string statuswhere = string.Empty;
if (!string.IsNullOrEmpty(statuslist) && statuslist.CompareTo("ALL") != 0)
{
statuswhere = "and a.status in ('" + statuslist.Replace(",", "','") + "') ";
}
string idwhere = string.Empty;
if (!string.IsNullOrEmpty(idlist) && idlist.CompareTo("ALL") != 0)
{
idwhere = "and a.id in ('" + idlist.Replace(",", "','") + "') ";
}
string expenseidwhere = string.Empty;
if (!string.IsNullOrEmpty(expenseidlist) && expenseidlist.CompareTo("ALL") != 0)
{
expenseidwhere = "and a.expense_id in ('" + expenseidlist.Replace(",", "','") + "') ";
}
string expensemanwhere = string.Empty;
if (!string.IsNullOrEmpty(expensemanlist) && expensemanlist.CompareTo("ALL") != 0)
{
expensemanwhere = "and a.expense_man in ('" + expensemanlist.Replace(",", "','") + "') ";
}
string formdatewhere = string.Empty;
if (!string.IsNullOrEmpty(fromdate))
{
formdatewhere = "and a.form_date >= '" + Convert.ToDateTime(fromdate) + "' ";
}
if (!string.IsNullOrEmpty(todate))
{
formdatewhere += "and a.form_date <= '" + Convert.ToDateTime(todate) + "' ";
}
string sql = "select a.expense_id,a.expense_name,a.expense_man,sum(a.exchange_rate*a.expense_mny) expense_mny from acc_expense_form a inner join acc_subject_list b on a.subject_id=b.subject_id "
+ "where 1=1 " + statuswhere + idwhere + expenseidwhere + expensemanwhere + formdatewhere + " group by a.expense_id,a.expense_name,a.expense_man order by a.expense_man,a.expense_id";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modAccExpenseSummary model = new modAccExpenseSummary();
model.ExpenseType = GetExpenseType(rdr["expense_id"].ToString());
model.ExpenseId = dalUtility.ConvertToString(rdr["expense_id"]);
model.ExpenseName = dalUtility.ConvertToString(rdr["expense_name"]);
model.ExpenseMan = dalUtility.ConvertToString(rdr["expense_man"]);
model.ExpenseMny = dalUtility.ConvertToDecimal(rdr["expense_mny"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void SetChartData()
{
try
{
this.Cursor = Cursors.WaitCursor;
chart1.Text = clsTranslate.TranslateString("Expense Man");
chart1.Series.Clear();
chart2.Text = clsTranslate.TranslateString("Expense Name");
chart2.Series.Clear();
if (DBGrid.RowCount == 0)
{
return;
}
ArrayList arrMan = new ArrayList();
ArrayList arrName = new ArrayList();
for (int i = 0; i < DBGrid.RowCount; i++)
{
modAccExpenseSummary mod = (modAccExpenseSummary)DBGrid.Rows[i].DataBoundItem;
if (i == 0)
{
arrMan.Add(mod.ExpenseMan);
arrName.Add(mod.ExpenseName);
}
else
{
bool exists = false;
for (int j = 0; j < arrMan.Count; j++)
{
if (mod.ExpenseMan == arrMan[j].ToString())
{
exists = true;
break;
}
}
if (!exists)
{
arrMan.Add(mod.ExpenseMan);
}
////////////////////////////////////////////////////////
exists = false;
for (int j = 0; j < arrName.Count; j++)
{
if (mod.ExpenseName == arrName[j].ToString())
{
exists = true;
break;
}
}
if (!exists)
{
arrName.Add(mod.ExpenseName);
}
}
}
Series ser1 = new Series();
for (int k = 0; k < arrMan.Count; k++)
{
decimal summan = 0;
for (int i = 0; i < DBGrid.RowCount; i++)
{
modAccExpenseSummary mod = (modAccExpenseSummary)DBGrid.Rows[i].DataBoundItem;
if (mod.ExpenseMan == arrMan[k].ToString())
{
summan += mod.ExpenseMny;
}
}
ser1.Points.AddXY(arrMan[k], summan);
}
ser1.ChartType = SeriesChartType.Pie;
ser1.BorderColor = Color.Transparent;
ser1.LabelAngle = 60;
chart1.Series.Add(ser1);
chart1.ChartAreas[0].AxisX.IsMarginVisible = true;
chart1.Legends[0].BackColor = Color.Transparent;
//////////////////////////////////////////////////////////////////////////
Series ser2 = new Series();
ser2 = new Series();
for (int k = 0; k < arrName.Count; k++)
{
decimal sumname = 0;
for (int i = 0; i < DBGrid.RowCount; i++)
{
modAccExpenseSummary mod = (modAccExpenseSummary)DBGrid.Rows[i].DataBoundItem;
if (mod.ExpenseName == arrName[k].ToString())
{
sumname += mod.ExpenseMny;
}
}
ser2.Points.AddXY(arrName[k], sumname);
}
ser2.ChartType = SeriesChartType.Pie;
ser2.BorderColor = Color.Transparent;
ser2.LabelAngle = 60;
chart2.Series.Add(ser2);
chart2.ChartAreas[0].AxisX.IsMarginVisible = true;
chart2.Legends[0].BackColor = Color.Transparent;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
