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