/// <summary> /// 添加圣域城主历史记录数据 /// </summary> /// <param name="CityOwnerData"></param> public void InsertCityOwnerHistory(LangHunLingYuKingHist CityOwnerData) { try { string sql = string.Format("INSERT INTO t_lhly_hist(role_id, admire_count, time, data) VALUES({0}, {1}, '{2}', @content)", CityOwnerData.rid, CityOwnerData.AdmireCount, CityOwnerData.CompleteTime.ToString()); List <Tuple <string, byte[]> > imgList = new List <Tuple <string, byte[]> >(); imgList.Add(new Tuple <string, byte[]>("content", CityOwnerData.CityOwnerRoleData)); DbHelperMySQL.ExecuteSqlInsertImg(sql, imgList); } catch (System.Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } }
/// <summary> /// 加载历史圣域城主历史记录数据 /// </summary> /// <param name="CityOwnerHist"></param> /// <returns></returns> public bool LoadCityOwnerHistory(List <LangHunLingYuKingHist> LHLYCityOwnerList) { MySqlDataReader sdr = null; string strSql; try { strSql = string.Format("SELECT * FROM `t_lhly_hist`"); sdr = DbHelperMySQL.ExecuteReader(strSql); for (int index = 1; sdr.Read(); index++) { LangHunLingYuKingHist OwnerData = new LangHunLingYuKingHist(); OwnerData.rid = Convert.ToInt32(sdr["role_id"]); OwnerData.AdmireCount = Convert.ToInt32(sdr["admire_count"]); OwnerData.CompleteTime = DateTime.Parse(sdr["time"].ToString()); if (!sdr.IsDBNull(sdr.GetOrdinal("data"))) { OwnerData.CityOwnerRoleData = (byte[])(sdr["data"]); } LHLYCityOwnerList.Add(OwnerData); } return(true); } catch (System.Exception ex) { LogManager.WriteExceptionUseCache(ex.ToString()); } finally { if (null != sdr) { sdr.Close(); } } return(false); }