public DataTable GetData(string sqlwhere)
{
DataTable table = null;
try
{
string strSql = string.Format("select * from qqfriend.friend where Nickname = \'{0}\'", sqlwhere);
table = MySqlHelpDao.ExecuteDataSet(strSql.ToString()).Tables[0];
}
catch (Exception E)
{
}
return(table);
}
public DataTable GetTable()
{
DataTable table = null;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from friend");
table = MySqlHelpDao.ExecuteDataSet(strSql.ToString()).Tables[0];
}
catch (Exception E)
{
}
return(table);
}
public int Add(Friend friend)
{
object obj = null;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into friend(");
strSql.Append("Head,Nickname)");
strSql.Append(" value(");
strSql.Append("@Head,@Nickname)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Head", MySqlDbType.LongBlob),
new MySqlParameter("@Nickname", MySqlDbType.VarChar)
};
using (MemoryStream stream = new MemoryStream())
{
//BitmapSource 转换为字节流
BitmapEncoder bitmapEncoder = new BmpBitmapEncoder();
bitmapEncoder.Frames.Add(BitmapFrame.Create(friend.Head));
bitmapEncoder.Save(stream);
byte[] bt = stream.ToArray();
parameters[0].Value = bt;
parameters[1].Value = friend.Nickname;
}
obj = MySqlHelpDao.ExecuteNonQuery(strSql.ToString(), parameters);
}
catch (Exception e)
{
}
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}