//添加用户余额到表 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 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 updateUserBalance(int money) { TM_BalceBiz balanceBiz = new TM_BalceBiz(); DataSet result = balanceBiz.ExecuteSqlToDataSet("EXEC [TireMoneyDB].[dbo].[proc_UpdateBalanceInfoByWeixinId] '"+ GetUData.OpenId + "'," + money + ""); }