关于网站会员注册积分兑换问题

Question

用C#开发数据库字段Integral存的用户积分  十个积分换取一张1元充值卡   充值卡价格分为1元 5元 10元 30元 怎么换取
谢谢各位大侠

Answer 1

/10，剩下的留着，用transaction之类的机制保证兑换，扣积分必须要么都成功，要么都失败。

Answer 2

写个存储过程,输入一个INT数,返回1元 5元 10元 30元 各多少张

Answer 3

protected int cardNum = 0;
    protected int cardNum1 = 0;
    protected int cardNum2 = 0;
    protected int cardNum3 = 0;
if(Integral>=300)
            {
                cardNum = Convert.ToInt16(Integral/300);
                pCard.Visible = true;
            }            if (Integral>= 100)
            {
                cardNum1 = Convert.ToInt16(Integral / 100);
                pCard.Visible = true;            }
            if (Integral>= 5)
            {
                cardNum2 = Convert.ToInt16(Integral / 50);
                pCard.Visible = true;
            }
            if (cardPrices >= 1)
            {
                cardNum3 = Convert.ToInt16(Integral / 10);
                pCard.Visible = true;
<table width="97%" border="0" align="center" cellpadding="0" cellspacing="0" class="font_black">
                                                                    
                                                                    
                                                                    <tr>
                                                                        <td height="24" valign="middle">
                                                                            <div class="font9">
                                                                                <span class="eqo9">兑换数量30元的为：</span></div>
                                                                        </td>
                                                                        <td valign="middle">
                                                                            <div class="eqo9">                                                                       
                                                                                <%#cardNum%>张 
                                                                              
                                                                            </div>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td height="24" valign="middle">
                                                                            <div class="font9">
                                                                                <span class="eqo9">兑换数量10元的为：</span></div>
                                                                        </td>
                                                                        <td valign="middle">
                                                                            <div class="eqo9">                                                                       
                                                                                <%#cardNum1%>张 
                                                                              
                                                                            </div>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td height="24" valign="middle">
                                                                            <div class="font9">
                                                                                <span class="eqo9">兑换数量5元的为：</span></div>
                                                                        </td>
                                                                        <td valign="middle">
                                                                            <div class="eqo9">                                                                       
                                                                                <%#cardNum2%>张 
                                                                              
                                                                            </div>
                                                                        </td>
                                                                    </tr>
                                                                    <tr>
                                                                        <td height="24" valign="middle">
                                                                            <div class="font9">
                                                                                <span class="eqo9">兑换数量1元的为：</span></div>
                                                                        </td>
                                                                        <td valign="middle">
                                                                            <div class="eqo9">                                                                       
                                                                                <%#cardNum3%>张 
                                                                              
                                                                            </div>
                                                                        </td>
                                                                    </tr>
                                                                </table>
            }
比如说积分为3000的话  怎么去计算