public int UpdateYearBudGet(t_EE_YearBudget model)
{
int n = 0;
try
{
n = _dbFactory.yearBudget.UpdateYearBudGet(model);
}
catch (Exception ex)
{
throw ex;
}
return(n);
}
public int UpdateYearBudGet(t_EE_YearBudget model)
{
string sql = $"update t_EE_YearBudget set Year={model.Year},GeneralBudget={model.GeneralBudget},BudgetBalance={model.BudgetBalance},UID={model.UID} WHERE UID={model.UID} AND Year={model.Year}";
return(ExecuteSqlCommand(sql));
}
public int AddYearBudGet(t_EE_YearBudget model)
{
string sql = $"insert into t_EE_YearBudget(Year,GeneralBudget,BudgetBalance,UID) values({model.Year},{model.GeneralBudget},{model.BudgetBalance},{model.UID}) ";
return(ExecuteSqlCommand(sql));
}