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