/// <summary>
/// 支出表增加
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public int ExpenditureInsert(ExpenditureTable et)
{
StringBuilder sql = new StringBuilder("INSERT INTO [ExpenditureTable]([SpendingTime],[ExpenditureAmount],[ExpenditureReasons]) VALUES (@SpendingTime,@ExpenditureAmount,@ExpenditureReasons)");
SqlParameter[] sp =
{
new SqlParameter("@SpendingTime", et.SpendingTime),
new SqlParameter("@ExpenditureAmount", et.ExpenditureAmount),
new SqlParameter("@ExpenditureReasons", et.ExpenditureReasons)
};
return(db.ExecuteNonQuery(sql.ToString(), sp));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button1_Click(object sender, EventArgs e)
{
if (PanDuan())
{
ExpenditureTable et = new ExpenditureTable()
{
ExpenditureAmount = Double.Parse(txtJinE.Text),
ExpenditureReasons = txtYuan.Text
};
if (etm.ExpenditureInsert(et) > 0)
{
MessageBox.Show("操作成功");
rt.UserRechargeTable();
this.Close();
}
}
}
/// <summary>
/// 增加支出表
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public int ExpenditureInsert(ExpenditureTable et)
{
return(ets.ExpenditureInsert(et));
}
