//显示用户余额
private string getBalance()
{
TM_BalceBiz balanceBiz = new TM_BalceBiz();
DataSet result = balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_CheckBalanceInfo] '" + GetUData.OpenId + "'");
string num = result.Tables[0].Rows[0]["AMneys"].ToString();
return(num = num.Substring(0, num.IndexOf(".")));
}
//显示用户余额
private void showBalance()
{
addUserBalanceInfo();
TM_BalceBiz balanceBiz = new TM_BalceBiz();
DataSet result = balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_CheckBalanceInfo] '" + GetUData.OpenId + "'");
ViewBag.balance = result.Tables[0].Rows[0]["AMneys"];
}
//添加用户余额到表
private void addUserBalanceInfo()
{
string openId = GetUData.OpenId;
TM_BalceBiz balanceBiz = new TM_BalceBiz();
DataSet result = balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_CheckBalanceInfo] '" + openId + "'");
if (result.Tables[0].Rows.Count == 0)
{
Guid baId = Guid.NewGuid();
DateTime now = DateTime.Now;
balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_AddUserBalanceInfo] '" + openId + "','" + now + "','" + now + "'");
}
}
//更新用户余额
private void updateUserBalance(int money)
{
TM_BalceBiz balanceBiz = new TM_BalceBiz();
DataSet result = balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_UpdateBalanceInfoByWeixinId] '"+ GetUData.OpenId + "'," + money + "");
}
