/// <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);
}
