/// <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)); }