public frmDespesaControlar(Usuario user) { InitializeComponent(); this.user = user; desp = new Despesa(); util = new Utils(); cbbSituação.Text = "Todas"; chkPeriodo.Checked = true; dtpInicio.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); dtpFim.Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 30); dtDesp = desp.consulta(dtpInicio.Value.ToShortDateString(), dtpFim.Value.ToShortDateString(), cbbSituação.Text, ttbDesc.Text, false); dtgvDesp.DataSource = dtDesp; getInfos(); }
public bool atualizar(Despesa desp) { sql = "UPDATE despesa SET desp_desc='@1', desp_valor='@2', desp_dtpg=@3, desp_dtvenc='@4', " + "desp_valorpg=@5 WHERE desp_id = @6"; if (desp.DtPgmto == "") { sql = sql.Replace("@3", "null"); sql = sql.Replace("@5", "null"); } else { sql = sql.Replace("@3", "'"+desp.DtPgmto+"'"); sql = sql.Replace("@5", "'"+desp.ValorPg+"'"); } sql = sql.Replace("@1", desp.Desc); sql = sql.Replace("@2", desp.Valor); sql = sql.Replace("@4", desp.DtVcmto); sql = sql.Replace("@6", desp.Id); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); return result; }
public Despesa getById() { Despesa desp = new Despesa(); DataTable aux = despBD.getById(id); if (aux.Rows.Count > 0) { desp.Id = aux.Rows[0]["desp_id"].ToString(); desp.Desc = aux.Rows[0]["desp_desc"].ToString(); desp.DtPgmto = aux.Rows[0]["desp_dtpg"].ToString(); desp.DtVcmto = aux.Rows[0]["desp_dtvenc"].ToString(); desp.Valor = aux.Rows[0]["desp_valor"].ToString(); desp.ValorPg = aux.Rows[0]["desp_valorpg"].ToString(); } return desp; }
public bool nova(Despesa desp) { String sql2 = ""; String paramAdd = ""; if (desp.DtPgmto != "") { sql2 = ", desp_dtpg, desp_valorpg"; paramAdd = ", '@4', '@5'"; } sql = "INSERT INTO despesa(desp_desc, desp_valor, desp_dtvenc " + sql2 + ") " + "VALUES ('@1', '@2', '@3'" + paramAdd + ")"; sql = sql.Replace("@1", desp.Desc); sql = sql.Replace("@2", desp.Valor); sql = sql.Replace("@3", desp.DtVcmto); sql = sql.Replace("@4", desp.DtPgmto); sql = sql.Replace("@5", desp.ValorPg); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); return result; }
public frmDespesaNova(Usuario user, String despId) { InitializeComponent(); this.user = user; desp = new Despesa(); util = new Utils(); util.moneyMaskFormata(ttbValorPgmto); util.moneyMaskFormata(ttbValor); if (despId != "") { this.Text = "Alterar Despesa"; desp.Id = despId; desp = desp.getById(); ttbDesc.Text = desp.Desc; ttbValor.Text = desp.Valor; if (desp.DtPgmto != "") { rbPaga.Checked = true; gpbPagamento.Enabled = true; ttbValorPgmto.Text = desp.ValorPg; dtpPagamento.Value = DateTime.Parse(desp.DtPgmto); } else rbApagar.Checked = true; dtpVcmto.Value = DateTime.Parse(desp.DtVcmto); } else rbApagar.Checked = true; util.setCamposObrigatorios(Controls); }