/// <summary> /// Excel数据导入数据库 /// </summary> /// <param name="path"></param> /// <param name="tableName"></param> /// <returns></returns> public static bool ExcelToData(string path, string filename, DateTime uptime, ref int isexistcount) { DataTable excelData = InputExcel(path, filename); foreach (DataRow row in excelData.Rows) { Model.PTgame info = new Model.PTgame(); info.Login = row[0].ToString().ToLower(); info.Gamecode = "801"; info.Gameid = "801"; info.Status = 1; info.Startdate = uptime; info.Enddate = uptime; info.Hold = -Convert.ToDecimal(row[5]); info.Bet_amount = Convert.ToDecimal(row[3]); info.Payout_amount = Convert.ToDecimal(row[4]); if (info.Login.IndexOf("total cny") == -1) { //判断数据是否重复插入 if (!DAL.PTgame.IsExistData(info.Login, uptime, info.Hold, info.Bet_amount)) { //插入数据 DAL.PTgame.InsertData(info); } else { isexistcount++; } } } return(true); }
public static bool UpdateGameinfoReport_ea(Model.PTgame info) { string sql = "update gameinforeport_ea set hold=hold+@hold,handle=handle+@handle,bet_amount=bet_amount+@bet_amount,payout_amount=payout_amount+@payout_amount where login=@login and enddate=@enddate"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("@login", info.Login), new MySqlParameter("@enddate", info.Enddate), new MySqlParameter("@hold", info.Hold), new MySqlParameter("@handle", info.Handle), new MySqlParameter("@bet_amount", info.Bet_amount), new MySqlParameter("@payout_amount", info.Payout_amount) }; return(MySqlHelper.ExecuteNonQuery(sql, param) > 0); }
public static bool AddGameinfoReport_ea(Model.PTgame info) { string sql = "insert into gameinforeport_ea(login,status,enddate,hold,handle,bet_amount,payout_amount) values(@login,@status,@enddate,@hold,@handle,@bet_amount,@payout_amount)"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("@login", info.Login), new MySqlParameter("@status", "1"), new MySqlParameter("@enddate", info.Enddate), new MySqlParameter("@hold", info.Hold), new MySqlParameter("@handle", info.Handle), new MySqlParameter("@bet_amount", info.Bet_amount), new MySqlParameter("@payout_amount", info.Payout_amount) }; return(MySqlHelper.ExecuteNonQuery(sql, param) > 0); }
/// <summary> /// 插入数据 /// </summary> /// <param name="gameinfo"></param> /// <returns></returns> public static bool InsertData(Model.PTgame gameinfo) { string sql = "insert into pt_gameinfo(gameid,login,gamecode,status,startdate,enddate,hold,handle,bet_amount,payout_amount) values(@gameid,@login,@gamecode,@status,@startdate,@enddate,@hold,@handle,@bet_amount,@payout_amount)"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("@gameid", gameinfo.Gameid), new MySqlParameter("@login", gameinfo.Login), new MySqlParameter("@gamecode", gameinfo.Gamecode), new MySqlParameter("@status", gameinfo.Status), new MySqlParameter("@startdate", gameinfo.Startdate), new MySqlParameter("@enddate", gameinfo.Enddate), new MySqlParameter("@hold", gameinfo.Hold), new MySqlParameter("@handle", gameinfo.Handle), new MySqlParameter("@bet_amount", gameinfo.Bet_amount), new MySqlParameter("@payout_amount", gameinfo.Payout_amount) }; return(MySqlHelper.ExecuteNonQuery(sql, param) > 0); }