Exemplo n.º 1
0
        public static bool Insert(Withdraw withdraw)
        {
            const string insert = "insert [tbWithdraw] (MemberId,WithdrawDate,WithdrawAmt,WithdrawId,Status,ApprovedBy) values (@MemberId,@WithdrawDate,@WithdrawAmt,@WithdrawId,@Status,@ApprovedBy) ";
            SqlCommand   ret    = new SqlCommand(insert);

            ret.Parameters.Add(new SqlParameter("WithdrawId", withdraw.WithdrawId));
            ret.Parameters.Add(new SqlParameter("MemberId", withdraw.MemberId));
            ret.Parameters.Add(new SqlParameter("WithdrawDate", withdraw.WithdrawDate));
            ret.Parameters.Add(new SqlParameter("WithdrawAmt", withdraw.WithdrawAmt));
            ret.Parameters.Add(new SqlParameter("Status", withdraw.Status));
            ret.Parameters.Add(new SqlParameter("ApprovedBy", withdraw.ApprovedBy));
            return(SqlManager.ExecuteNonQuery(ret));
        }