Beispiel #1
0
    protected string Getzhuan(string _id)
    {
        double     _title = 0;
        tbl_queren bll    = new tbl_queren();

        _title = Convert.ToDouble(bll.GetTitleSum("huiyuan_id='" + _id + "' and action_type='奖励积分转账'", "sum(queren_money)"));


        return(_title.ToString());
    }
Beispiel #2
0
    /// <summary>
    /// 写入财务流水账
    /// </summary>
    /// <param name="huiyuan_id">会员标识</param>
    /// <param name="huiyuan_bianhao">会员编号</param>
    /// <param name="action_type">记录账户类型</param>
    /// <param name="memo">详细说明</param>
    /// <param name="queren_money">改动金额</param>
    /// <param name="money_before">改动后金额</param>
    /// <returns></returns>
    public bool queren_insert(string huiyuan_id, string huiyuan_bianhao, string action_type, string memo, decimal queren_money, decimal money_before)
    {
        //写入日志
        tbl_queren mylog = new tbl_queren();

        mylog.huiyuan_id      = huiyuan_id;
        mylog.huiyuan_bianhao = huiyuan_bianhao;
        mylog.action_type     = action_type;
        mylog.queren_date     = DateTime.Now;
        mylog.memo            = memo;
        mylog.queren_money    = queren_money;
        mylog.money_before    = money_before;
        int newId = mylog.Add();

        if (newId > 0)
        {
            return(true);
        }

        return(false);
    }