internal static bool Update(ExtractMoney item) { string commandText = @"UPDATE ExtractMoney SET SellerId = ?SellerId, CardNumber = ?CardNumber, Bank = ?Bank, Balance = ?Balance, Money = ?Money, AccountName = ?AccountName, CreateTime = ?CreateTime, Status = ?Status, Fee = ?Fee, SendTime = ?SendTime WHERE Id = ?Id"; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?Id", item.Id)); parameters.Add(new MySqlParameter("?SellerId", item.SellerId)); parameters.Add(new MySqlParameter("?CardNumber", item.CardNumber)); parameters.Add(new MySqlParameter("?Bank", item.Bank)); parameters.Add(new MySqlParameter("?Balance", item.Balance)); parameters.Add(new MySqlParameter("?Money", item.Money)); parameters.Add(new MySqlParameter("?CreateTime", item.CreateTime)); parameters.Add(new MySqlParameter("?AccountName", item.AccountName)); parameters.Add(new MySqlParameter("?Status", item.Status)); parameters.Add(new MySqlParameter("?Fee", item.Fee)); parameters.Add(new MySqlParameter("?SendTime", item.SendTime)); return(MySqlHelper.ExecuteNonQuery(GlobalConfig.DbConn, CommandType.Text, commandText, parameters.ToArray()) > 0); }
public static void Create(ExtractMoney item) { string connectionString = GlobalConfig.DbConn; string commandText = @"INSERT INTO ExtractMoney ( SellerId, CardNumber, Bank, Balance, Money, CreateTime, AccountName, Status, Fee, UserAccount ) VALUES ( ?SellerId, ?CardNumber, ?Bank, ?Balance, ?Money, ?CreateTime, ?AccountName, ?Status, ?Fee, ?UserAccount )" ; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?SellerId", item.SellerId)); parameters.Add(new MySqlParameter("?CardNumber", item.CardNumber)); parameters.Add(new MySqlParameter("?Bank", item.Bank)); parameters.Add(new MySqlParameter("?Balance", item.Balance)); parameters.Add(new MySqlParameter("?Money", item.Money)); parameters.Add(new MySqlParameter("?CreateTime", item.CreateTime)); parameters.Add(new MySqlParameter("?AccountName", item.AccountName)); parameters.Add(new MySqlParameter("?Status", item.Status)); parameters.Add(new MySqlParameter("?Fee", item.Fee)); parameters.Add(new MySqlParameter("?UserAccount", item.UserAccount)); MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, commandText, parameters.ToArray()); }
public static ExtractMoney GetItem(int id) { ExtractMoney e = null; string commandText = @"select * from ExtractMoney where id = ?id"; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("?id", id)); try { using (var conn = Utility.ObtainConn(Utility._gameDbConn)) { MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray()); while (reader.Read()) { e = new ExtractMoney(); e.Id = reader.GetInt32(0); e.SellerId = (int)reader["SellerId"]; e.CardNumber = (long)reader["CardNumber"]; e.Bank = reader["Bank"].ToString(); e.Balance = (float)reader["Balance"]; e.CreateTime = (DateTime)reader["CreateTime"]; e.Money = (float)reader["Money"]; e.AccountName = reader["AccountName"].ToString(); e.Status = (int)reader["Status"]; e.Fee = (float)reader["Fee"]; e.UserAccount = reader["UserAccount"].ToString(); e.SendTime = (DateTime)reader["SendTime"]; } } } catch (System.Exception ex) { throw; } return(e); }
/// <summary> /// /// </summary> /// <param name="sellId"></param> /// <param name="type"></param> /// <param name="index"></param> /// <param name="size"></param> /// <param name="order">排序sql</param> /// <returns></returns> public static PagResults <ExtractMoney> GetPagings(int sellerId, int index, int size, string order = "", string sqlwhere = "") { var results = new PagResults <ExtractMoney>(); results.Results = new List <ExtractMoney>(); List <MySqlParameter> parameters = new List <MySqlParameter>(); if (order == "") { order = "order by CreateTime desc"; } string commandText = ""; if (sellerId != 0) { commandText = @"select * from ExtractMoney where sellerId = ?sellerId " + sqlwhere + order + " LIMIT ?index,?size"; parameters.Add(new MySqlParameter("?sellerId", sellerId)); } else { commandText = @"select * from ExtractMoney " + sqlwhere + order + " LIMIT ?index,?size"; } parameters.Add(new MySqlParameter("?index", index)); parameters.Add(new MySqlParameter("?size", size)); try { using (var conn = Utility.ObtainConn(Utility._gameDbConn)) { MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray()); while (reader.Read()) { ExtractMoney e = new ExtractMoney(); e.Id = reader.GetInt32(0); e.SellerId = (int)reader["SellerId"]; e.CardNumber = (long)reader["CardNumber"]; e.Bank = reader["Bank"].ToString(); e.Balance = (float)reader["Balance"]; e.CreateTime = (DateTime)reader["CreateTime"]; e.Money = (float)reader["Money"]; e.AccountName = reader["AccountName"].ToString(); e.Status = (int)reader["Status"]; e.Fee = (float)reader["Fee"]; e.UserAccount = reader["UserAccount"].ToString(); e.SendTime = (DateTime)reader["SendTime"]; results.Results.Add(e); } //一个函数有两次连接数据库 先把连接断开 然后重连 conn.Close(); conn.Dispose(); conn.Open(); commandText = "select count(*) from ExtractMoney where sellerId = ?sellerId"; parameters.Clear(); parameters.Add(new MySqlParameter("?sellerId", sellerId)); reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray()); if (reader.HasRows) { if (reader.Read()) { results.TotalCount = reader.GetInt32(0); } } } } catch (System.Exception ex) { throw; } return(results); }
private void Withdraw() { var item = new ExtractMoney(); item.SellerId = GetInt("sellerId"); item.Money = GetFloat("money"); item.Bank = GetString("bank"); item.CardNumber = GetLong("cardnumber"); item.AccountName = GetString("accountname"); item.CreateTime = DateTime.Now; var user = AccountHelper.GetUser(item.SellerId); if (user == null) { throw new ArgumentNullException("user为空:" + item.SellerId); } if (item.CardNumber <= 0 || item.Bank.Length < 1 || item.AccountName.Length < 1) { ReturnErrorMsg("提现失败,卡号、开户行、开户名等信息是必填项,请填写正确"); } //目前商户的用户信息分三张表存储 //提现确认打款后才扣钱 //user.Money -= item.Money; //AccountHelper.SaveAccount(user); //商家更新 var seller = MerchantHelper.GetMerchant(item.SellerId); seller.CardNumber = item.CardNumber; seller.Bank = item.Bank; seller.AccountName = item.AccountName; float fee = ParamHelper.PlatformCfgData.SignList.FirstOrDefault(s => s.Id == seller.Sid).Prec *item.Money / 100; item.Fee = fee; if (seller.Money < (item.Money + item.Fee)) { ReturnErrorMsg(string.Format("提现失败,没有这么多的资金可以提现,提现金额:{0},手续费:{1}", item.Money, item.Fee)); return; } seller.Money = seller.Money - item.Money - item.Fee; MerchantHelper.SaveMerchant(seller); //提现表更新 item.Balance = seller.Money; item.UserAccount = user.UserName;//存储商户账户 ExtractMoneyHelper.Create(item); ReturnCorrectMsg(string.Format("提现{0}申请成功,手续费:{1},请耐心等待后台人员处理", item.Money, item.Fee)); //发短信 if (Utility._msg_opensend == "1") //Utility.SendMsg(verificationCode.Code, verificationCode.Phone, Utility._modifyphone_message); { SendMsgClass4 jsobject = new SendMsgClass4(); jsobject.param1 = string.IsNullOrEmpty(seller.Name) ? "商户名称为空" : seller.Name; jsobject.param2 = item.Money.ToString(); jsobject.param3 = "3~5"; jsobject.param4 = Utility._3vurl; if (Utility.SendMsg(seller.Phone, MsgTempleId.MerchantWithdraw, jsobject) != "发送成功") { logger.InfoFormat("短信模板:{0},Phone:{3},发送失败merchantId:{1},Name:{2}", (int)MsgTempleId.MerchantWithdraw, seller.Id, seller.Name, seller.Phone); //ReturnErrorMsg("短信发送失败"); //return; } } ReturnCorrectMsg(string.Format("提现{0}申请成功,手续费:{1},请耐心等待后台人员处理", item.Money, item.Fee)); }