public static void CreateFastlinks(Fastlinks fastlinks)
{
string connectionString = GlobalConfig.DbConn;
string commandText = @"INSERT INTO fastlinks
(
Title,
ImgUrl,
Url,
CreateTime
)
VALUES
(
?Title,
?ImgUrl,
?Url,
?CreateTime
)" ;
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?Title", fastlinks.Title));
parameters.Add(new MySqlParameter("?ImgUrl", fastlinks.ImgUrl));
parameters.Add(new MySqlParameter("?Url", fastlinks.Url));
parameters.Add(new MySqlParameter("?CreateTime", fastlinks.CreateTime));
MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, commandText, parameters.ToArray());
}
public static Fastlinks GetFastlinksItem(int id)
{
var f = new Fastlinks();
string commandText = @"select * from fastlinks where id = ?id";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?id", id));
try
{
using (var conn = new MySqlConnection(GlobalConfig.DbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
f.Id = reader.GetInt32(0);
f.Title = reader["Title"].ToString();
f.ImgUrl = reader["ImgUrl"].ToString();
f.Url = reader["Url"].ToString();
f.CreateTime = (DateTime)reader["CreateTime"];
}
}
}
catch (System.Exception ex)
{
throw;
}
return(f);
}
private void CreateFastlinks()
{
var item = new Fastlinks();
item.Title = GetString("title");
item.ImgUrl = GetString("imgurl");
item.Url = GetString("url");
item.CreateTime = DateTime.Now;
DevSystemHelper.CreateFastlinks(item);
}
public static PagResults <Fastlinks> GetPagFastlinks(int start, int limit)
{
var results = new PagResults <Fastlinks>();
string commandText; List <MySqlParameter> parameters = new List <MySqlParameter>();
if (limit == 0)
{
commandText = @"select * from fastlinks order by CreateTime desc";
}
else
{
commandText = @"select * from fastlinks order by CreateTime desc limit ?index,?size";
parameters.Add(new MySqlParameter("?index", start));
parameters.Add(new MySqlParameter("?size", limit));
}
try
{
using (var conn = Utility.ObtainConn(Utility._gameDbConn))
{
MySqlDataReader reader = MySqlHelper.ExecuteReader(conn, CommandType.Text, commandText, parameters.ToArray());
while (reader.Read())
{
Fastlinks f = new Fastlinks();
f.Id = reader.GetInt32(0);
f.Title = reader["Title"].ToString();
f.ImgUrl = reader["ImgUrl"].ToString();
f.Url = reader["Url"].ToString();
f.CreateTime = (DateTime)reader["CreateTime"];
results.Results.Add(f);
}
//一个函数有两次连接数据库 先把连接断开 然后重连
conn.Close();
conn.Dispose();
conn.Open();
commandText = @"select count(*) from fastlinks";
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);
}
public static void UpdateFasklinks(Fastlinks fastlinks)
{
string commandText = @"UPDATE fastlinks SET
Title = ?Title,
ImgUrl = ?ImgUrl,
Url = ?Url,
CreateTime = ?CreateTime
WHERE
Id = ?Id";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("?Id", fastlinks.Id));
parameters.Add(new MySqlParameter("?Title", fastlinks.Title));
parameters.Add(new MySqlParameter("?ImgUrl", fastlinks.ImgUrl));
parameters.Add(new MySqlParameter("?CreateTime", fastlinks.CreateTime));
parameters.Add(new MySqlParameter("?Url", fastlinks.Url));
MySqlHelper.ExecuteNonQuery(GlobalConfig.DbConn, CommandType.Text, commandText, parameters.ToArray());
}
