protected void btnAddYearIncome_Click(object sender, EventArgs e) { this.MVContainer.ActiveViewIndex = 1; YearGridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString(); YearGridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode; MonthGridView.DataBind(); }
protected void AddYearPlan_Click(object sender, EventArgs e) { foreach (GridViewRow gvRow in YearGridView.Rows) { IncomeBugetFacade facade = new IncomeBugetFacade(); IncomeBugetModel model = null; TextBox tbcMoney = (TextBox)(gvRow.FindControl("tbxMoney")); Label lblMonth = (Label)(gvRow.FindControl("lblMonth")); if (!string.IsNullOrEmpty(tbcMoney.Text)) { if (int.Parse(tbcMoney.Text) > 0) { model = new IncomeBugetModel(); model.Year = Year; model.Month = int.Parse(lblMonth.Text); model.ProjectCode = ProjectCode; model.Money = decimal.Parse(tbcMoney.Text); facade.Insert(model); } } } GridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString(); GridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode; MonthGridView.DataBind(); this.MVContainer.ActiveViewIndex = 0; }
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e) { Year = int.Parse(ddlYear.SelectedValue); GridViewObjectDataSource.SelectParameters["year"].DefaultValue = Year.ToString(); GridViewObjectDataSource.SelectParameters["projectCode"].DefaultValue = ProjectCode; MonthGridView.DataBind(); btnAddYearIncome.Enabled = CanEdit; }
public void Select(int year, string projectCode) { string sql = "SELECT * FROM RPTFININ WHERE IYEAR={0} AND PROJECTCODE='{1}' ORDER BY IMONTH ASC "; QueryAgent qa = new QueryAgent(); EntityData entity = qa.FillEntityData("RptFinIn", string.Format(sql, year, projectCode)); qa.Dispose(); this.MonthGridView.DataSource = entity.CurrentTable; MonthGridView.DataBind(); }