void setGrid()
{
Pre_Month_DebtsCoinEntryCLS.year = dtpYearMonth.Value.Year;
Pre_Month_DebtsCoinEntryCLS.month = dtpYearMonth.Value.Month;
Pre_Month_DebtsCoinEntryCLS.routCode = cmbRoute.SelectedValue.ToString();
gdvList.DataSource = Pre_Month_DebtsCoinEntryCLS.getSupllierByRouteCode();
}
private void gdvList_CellLeave(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow dr = gdvList.Rows[e.RowIndex];
if (gdvList.Columns[e.ColumnIndex].Name.Equals("Coins") || gdvList.Columns[e.ColumnIndex].Name.Equals("Debts"))
{
Pre_Month_DebtsCoinEntryCLS.SCode = dr.Cells["SupCode"].Value.ToString();
Pre_Month_DebtsCoinEntryCLS.routCode = dr.Cells["RouteCode"].Value.ToString();
Pre_Month_DebtsCoinEntryCLS.coin = Convert.ToDouble(dr.Cells["Coins"].Value.ToString().Trim());
Pre_Month_DebtsCoinEntryCLS.debt = Convert.ToDouble(dr.Cells["Debts"].Value.ToString().Trim());
Pre_Month_DebtsCoinEntryCLS.InsertUpdateCoins();
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
Pre_Month_DebtsCoinEntryCLS.month = dtpYearMonth.Value.Year;
Pre_Month_DebtsCoinEntryCLS.month = dtpYearMonth.Value.Month;
Pre_Month_DebtsCoinEntryCLS.routCode = cmbRoute.SelectedValue.ToString();
DataSet ds = new DataSet();
DataTable dt = Pre_Month_DebtsCoinEntryCLS.getSupllierByRouteCode();
ds.Tables.Add(dt);
ds.WriteXml("myCOins.xml");
pre_coinsAndDebts myRpt = new pre_coinsAndDebts();
ReportViewer myReportViewer = new ReportViewer();
myRpt.SetDataSource(ds);
myRpt.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myRpt.SetParameterValue("Year", Pre_Month_DebtsCoinEntryCLS.year);
myRpt.SetParameterValue("Month", CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Pre_Month_DebtsCoinEntryCLS.month));
myReportViewer.crystalReportViewer1.ReportSource = myRpt;
myReportViewer.Show();
}
private void Pre_Month_DebtsCoinsEntry_Load(object sender, EventArgs e)
{
cmbRoute.DataSource = Pre_Month_DebtsCoinEntryCLS.getAllRouteCode();
cmbRoute.DisplayMember = "RouteName";
cmbRoute.ValueMember = "RouteCode";
}
