62,046
社区成员
发帖
与我相关
我的任务
分享
private static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString =EncrypString.Decryp(ConfigurationManager.ConnectionStrings["MCConnectionString"].ConnectionString);
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}
public static IList<Message> GetMessagesBySql(string safeSql)
{
List<Message> list = new List<Message>();
try
{
DataTable table = DBHelper.GetDataSet(safeSql);
foreach (DataRow row in table.Rows)
{
Message message = new Message();
message.Mid = (int)row["Mid"];
message.Title = (string)row["Title"];
message.Mcontent = (string)row["Mcontent"];
message.Author = (string)row["Author"];
message.Mdate = (DateTime)row["Mdate"];
message.Files = (string)row["Files"];
list.Add(message);
}
return list;
}
catch (Exception e)
{
throw e;
}
}
public static DataTable GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand(safeSql, Connection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds.Tables[0];
}