public void GetDinningTableTest()
{
string tableNumber = string.Empty; // TODO: 初始化为适当的值
DinningTable expected = new DinningTable(); // TODO: 初始化为适当的值
expected.Id = "003";
expected.GuestAmount = 5;
expected.ArrivedTime = DateTime.Parse("2010-6-5 20:05:57");
expected.Note = string.Empty;
DinningTable actual;
actual = TableDao.GetDinningTable("003");
Assert.AreEqual(expected.Id, actual.Id);
Assert.AreEqual(expected.GuestAmount, actual.GuestAmount);
Assert.AreEqual(expected.ArrivedTime.ToString(), actual.ArrivedTime.ToString());
Assert.AreEqual(expected.Note, actual.Note);
}
private static DinningTable covertToDinningTable(string id, int guestAmount, DateTime arrivedTime, string note)
{
DinningTable table = new DinningTable();
table.Id = id.Trim();
table.GuestAmount = guestAmount;
table.ArrivedTime = arrivedTime;
table.Note = note.Trim();
return table;
}
public static void InsertDinningTable(string tableId, DinningTable dinning)
{
List<SqlCommand> commands = new List<SqlCommand>();
SqlCommand comm = new SqlCommand(@"insert into DinningTable(Id, TableId, GuestAmount, ArrivedTime, Note)
values(@Id, @TableId, @GuestAmount, @ArrivedTime, @Note)");
comm.Parameters.Add("@Id", SqlDbType.Char, 10);
comm.Parameters.Add("@TableId", SqlDbType.Char, 10);
comm.Parameters.Add("@GuestAmount", SqlDbType.Int);
comm.Parameters.Add("@ArrivedTime", SqlDbType.DateTime);
comm.Parameters.Add("@Note", SqlDbType.Text);
comm.Parameters["@Id"].Value = dinning.Id;
comm.Parameters["@TableId"].Value = tableId;
comm.Parameters["@GuestAmount"].Value = dinning.GuestAmount;
comm.Parameters["@ArrivedTime"].Value = dinning.ArrivedTime;
comm.Parameters["@Note"].Value = dinning.Note;
commands.Add(comm);
try
{
using (SqlConnection conn = Utilities.GetConnection())
{
Utilities.TransactionExecuteNonQuery(conn, commands);
}
}
catch (SqlException ex)
{
if (ex.Number >= 50000)
{
throw new HCSMSException(ex.Message);
}
else
{
throw new HCSMSException("Transaction Errors !", ex);
}
}
}
