public void updateList(T_PaymentIndecreaseList item) { Database db = Dao.GetDatabase(); string sql = @"UPDATE [dbo].[payment_Indecrease_list] SET [amount] = @amount ,[name] = @NAME ,[type] = @TYPE ,[apply_date] = @apply_date ,[note] = @note WHERE [bill_no] = @bill_no AND [g_no] = @g_no " ; using (DbConnection cn = db.CreateConnection()) { try { DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@amount", DbType.Decimal, item.Amount); db.AddInParameter(cmd, "@NAME", DbType.String, item.Name); db.AddInParameter(cmd, "@TYPE", DbType.String, item.Type); db.AddInParameter(cmd, "@apply_date", DbType.DateTime, item.ApplyDate); db.AddInParameter(cmd, "@note", DbType.String, item.Note); db.AddInParameter(cmd, "@bill_no", DbType.String, item.BillNo); db.AddInParameter(cmd, "@g_no", DbType.Int32, item.GNo); db.ExecuteNonQuery(cmd); } catch { throw new Exception("更新增减单表体数据失败,请检查人品"); } } }
public void updateList(T_PaymentIndecreaseList item) { Manager.updateList(item); }