public List <Mail.Mail> GetMail(Mail.SearchType type, string value) { List <Mail.Mail> list = new List <SagaDB.Mail.Mail>(); string sqlstr = ""; DataRowCollection result; switch (type) { case SagaDB.Mail.SearchType.MailID: sqlstr = "SELECT * FROM mail WHERE mailID =" + value + ";"; break; case SagaDB.Mail.SearchType.Receiver: sqlstr = "SELECT * FROM mail WHERE receiver ='" + value + "';"; break; case SagaDB.Mail.SearchType.Sender: sqlstr = "SELECT * FROM mail WHERE sender ='" + value + "';"; break; } try { result = db.GetDataTable(sqlstr).Rows; foreach (DataRow i in result) { Mail.Mail mail = new SagaDB.Mail.Mail(); mail.ID = (uint)(int)i["mailID"]; mail.item = (uint)(int)i["itemID"]; mail.read = (byte)i["read"]; mail.receiver = (string)i["receiver"]; mail.sender = (string)i["sender"]; mail.stack = (byte)i["stack"]; mail.topic = (string)i["topic"]; mail.valid = (byte)i["valid"]; mail.zeny = (uint)(int)i["zeny"]; mail.content = (string)i["content"]; mail.creator = (string)i["creator"]; mail.date = DateTime.Parse((string)i["date"]); mail.durability = (ushort)(short)i["durability"]; list.Add(mail); } } catch (Exception ex) { Logger.ShowError(ex); } return(list); }
public List <Mail.Mail> GetMail(Mail.SearchType type, string value) { return(null); }