InjectionMessage IInjectionMessageManager.ReadInjectionMessage(
IInjectionMessageStorage pStorage,
int pInjectionMessageID)
{
InjectionMessage response = null;
try
{
#region Verify argument
Verify.ArgumentNotNull(pStorage, "pStorage");
Verify.ArgumentNotSpecified(
pInjectionMessageID <= 0,
"pInjectionMessageID");
#endregion
response =
pStorage.ReadInjectionMessage(pInjectionMessageID);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
return(response);
}
public void InjectionMessageCreateSuccess()
{
IInjectionMessageStorage pInjectionMessageStorage = new InjectionMessageStorage();
IInjectorStorage pInjectorStorage = new InjectorStorage();
IVaccineStorage pVaccineStorage = new VaccineStorage();
int pgetInjectorID = getInjectorID();
int pgetVaccineID = getVaccineID();
InjectionMessage myInjectionMessage = CreateInjectionMessageForTest(
pgetInjectorID,
pInjectorStorage.ReadInjector(pgetInjectorID).InjectorName,
pgetVaccineID,
pVaccineStorage.ReadVaccine(pgetVaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
"陈医生");
InjectionMessage createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
Assert.AreNotEqual(
0,
createdInjectionMessage.InjectionMessageID,
string.Format("Could not create InjectionMessage:{0}",
createdInjectionMessage.InjectionMessageID));
AssertInjectionMessageItemEqual(myInjectionMessage, createdInjectionMessage);
}
private static void AssertInjectionMessageItemEqual(
InjectionMessage pInjectionMessage,
InjectionMessage pCreatedInjectionMessage)
{
Assert.AreEqual(
pInjectionMessage.InjectionMessageID,
pCreatedInjectionMessage.InjectionMessageID,
string.Format("InjectionMessageID isn't equal!"));
Assert.AreEqual(
pInjectionMessage.InjectorID,
pCreatedInjectionMessage.InjectorID,
string.Format("InjectorID isn't equal!"));
Assert.AreEqual(
pInjectionMessage.VaccineID,
pCreatedInjectionMessage.VaccineID,
string.Format("VaccineID isn't equal!"));
Assert.AreEqual(
pInjectionMessage.InjectionMessageSite,
pCreatedInjectionMessage.InjectionMessageSite,
string.Format("InjectionMessageSite isn't equal!"));
Assert.AreEqual(
pInjectionMessage.InjectionMessageTime,
pCreatedInjectionMessage.InjectionMessageTime,
string.Format("InjectionMessageTime isn't equal!"));
Assert.AreEqual(
pInjectionMessage.InjectionMessageDoctor,
pCreatedInjectionMessage.InjectionMessageDoctor,
string.Format("InjectionMessageDoctor isn't equal!"));
}
private void btnAdd_Click(object sender, EventArgs e)
{
IInjectionMessageStorage injectionMessageStorage = new InjectionMessageStorage();
InjectionMessage injectionMessage = new InjectionMessage();
if (cmbInjectorName.Text.Trim() == "" || cmbVaccineName.Text.Trim() == "" ||
textInjectionMessageSite.Text.Trim() == "" || dtpInjectionMessageTime.Text.Trim() == "" ||
textInjectionMessageDoctor.Text.Trim() == "")
{
MessageBox.Show("请输入全部信息，不要有遗漏。");
}
else
{
injectionMessage.InjectorID = Convert.ToInt32(cmbInjectorName.SelectedValue.ToString());
injectionMessage.VaccineID = Convert.ToInt32(cmbVaccineName.SelectedValue.ToString());
injectionMessage.InjectionMessageSite = textInjectionMessageSite.Text.Trim();
injectionMessage.InjectionMessageTime = Convert.ToDateTime(dtpInjectionMessageTime.Text.Trim());
injectionMessage.InjectionMessageDoctor = textInjectionMessageDoctor.Text.Trim();
injectionMessageStorage.CreateInjectionMessage(injectionMessage);
MessageBox.Show("增加成功！");
cmbInjectorName.Text = "";
cmbVaccineName.Text = "";
textInjectionMessageSite.Text = "";
dtpInjectionMessageTime.Text = "";
textInjectionMessageDoctor.Text = "";
}
}
private void btnModfiy_Click(object sender, EventArgs e)
{
IInjectionMessageStorage injectionMessageStorage = new InjectionMessageStorage();
InjectionMessage injectionMessage = new InjectionMessage();
if (cmbInjectorName.Text.Trim() == "" || cmbVaccineName.Text.Trim() == "" ||
textInjectionMessageSite.Text.Trim() == "" || dtpInjectionMessageTime.Text.Trim() == "" ||
textInjectionMessageDoctor.Text.Trim() == "")
{
MessageBox.Show("请双击需要修改的记录！");
}
else
{
injectionMessage.InjectorID = Convert.ToInt32(cmbInjectorName.SelectedValue.ToString());
injectionMessage.VaccineID = Convert.ToInt32(cmbVaccineName.SelectedValue.ToString());
injectionMessage.InjectionMessageSite = textInjectionMessageSite.Text;
injectionMessage.InjectionMessageTime = Convert.ToDateTime(dtpInjectionMessageTime.Text.Trim());
injectionMessage.InjectionMessageDoctor = textInjectionMessageDoctor.Text;
injectionMessage.InjectionMessageID = Convert.ToInt32(dgvInjectionMessage[0, dgvInjectionMessage.CurrentCell.RowIndex].Value.ToString());
injectionMessageStorage.UpdateInjectionMessage(injectionMessage);
MessageBox.Show("更新成功！");
cmbInjectorName.Text = "";
cmbVaccineName.Text = "";
textInjectionMessageSite.Text = "";
dtpInjectionMessageTime.Text = "";
textInjectionMessageDoctor.Text = "";
}
}
InjectionMessage IInjectionMessageManager.CreateInjectionMessage(
IInjectionMessageStorage pStorage,
InjectionMessage pInjectionMessage)
{
InjectionMessage response = null;
try
{
#region Verify argument
Verify.ArgumentNotNull(pInjectionMessage, "pInjectionMessage");
Verify.ArgumentNotNull(
pInjectionMessage.InjectorID,
"pInjectionMessage.InjectorID");
Verify.ArgumentNotNull(
pInjectionMessage.VaccineID,
"pInjectionMessage.VaccineID");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageSite,
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageDoctor,
"pInjectionMessage.InjectionMessageDoctor");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectorID <= 0),
"pInjectionMessage.InjectorID");
Verify.ArgumentNotSpecified(
(pInjectionMessage.VaccineID <= 0),
"pInjectionMessage.VaccineID");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectionMessageSite.Length == 0),
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectionMessageDoctor.Length == 0),
"pInjectionMessage.InjectionMessageDoctor");
#endregion
response = pStorage.CreateInjectionMessage(pInjectionMessage);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
return(response);
}
void IInjectionMessageManager.ModifyInjectionMessage(
IInjectionMessageStorage pStorage,
InjectionMessage pInjectionMessage)
{
try
{
#region Verify argument
Verify.ArgumentNotNull(pInjectionMessage, "pInjectionMessage");
Verify.ArgumentNotNull(
pInjectionMessage.InjectorID,
"pInjectionMessage.InjectorID");
Verify.ArgumentNotNull(
pInjectionMessage.VaccineID,
"pInjectionMessage.VaccineID");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageSite,
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageDoctor,
"pInjectionMessage.InjectionMessageDoctor");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectorID <= 0),
"pInjectionMessage.InjectorID");
Verify.ArgumentNotSpecified(
(pInjectionMessage.VaccineID <= 0),
"pInjectionMessage.VaccineID");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectionMessageSite.Length == 0),
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotSpecified(
(pInjectionMessage.InjectionMessageDoctor.Length == 0),
"pInjectionMessage.InjectionMessageDoctor");
#endregion
pStorage.UpdateInjectionMessage(pInjectionMessage);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
}
IList <InjectionMessage> IInjectionMessageStorage.ListInjectionMessage(QueryInjectionMessage pQueryInjectionMessage)
{
List <InjectionMessage> injectionMessageList = null;
SqlConnection conn;
IDataReader reader;
try
{
Verify.ArgumentNotNull(pQueryInjectionMessage, "pQueryInjectionMessage");
conn = new SqlConnection(
ConfigurationManager
.ConnectionStrings["DEFAULT"].ToString());
conn.Open();
reader = InjectionMessageSelectWrapper.ExecuteReader(
conn,
pQueryInjectionMessage);
if (reader != null)
{
injectionMessageList = new List <InjectionMessage>();
while (reader.Read())
{
InjectionMessage myInjectionMessage = DAUtil.ReadInjectionMessage(
reader);
injectionMessageList.Add(myInjectionMessage);
}
}
conn.Close();
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
//switch (ex.GetType().FullName)
//{
// case "System.ArgumentNullException":
// {
// throw new ArgumentNullException(ex.Message);
// }
// case "System.ArgumentException":
// {
// throw new ArgumentException(ex.Message);
// }
// default:
// throw new Exception(ex.Message);
//}
}
return(injectionMessageList);
}
public static InjectionMessage ReadInjectionMessage(IDataReader reader)
{
InjectionMessage itm = new InjectionMessage();
itm.InjectionMessageID = ReadInt(reader, "InjectionMessageID");
itm.InjectorID = ReadInt(reader, "InjectorID");
itm.InjectorName = ReadValue <string>(reader, "InjectorName");
itm.VaccineID = ReadInt(reader, "VaccineID");
itm.VaccineName = ReadValue <string>(reader, "VaccineName");
itm.InjectionMessageSite = ReadValue <string>(reader, "InjectionMessageSite");
itm.InjectionMessageTime = ReadDateTime(reader, "InjectionMessageTime");
itm.InjectionMessageDoctor = ReadValue <string>(reader, "InjectionMessageDoctor");
return(itm);
}
public void InjectionMessageCreateFailureInjectionMessageDoctorArgumentNullException()
{
IInjectionMessageStorage injectionMessageStorage = new InjectionMessageStorage();
IInjectorStorage pInjectorStorage = new InjectorStorage();
IVaccineStorage pVaccineStorage = new VaccineStorage();
int pgetInjectorID = getInjectorID();
int pgetVaccineID = getVaccineID();
InjectionMessage myInjectionMessage = CreateInjectionMessageForTest(
pgetInjectorID,
pInjectorStorage.ReadInjector(pgetInjectorID).InjectorName,
pgetVaccineID,
pVaccineStorage.ReadVaccine(pgetVaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
null);
injectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
}
private static InjectionMessage CreateInjectionMessageForTest(
int pInjectorID,
string pInjectorName,
int pVaccineID,
string pVaccineName,
string pInjectionMessageSite,
string pInjectionMessageTime,
string pInjectionMessageDoctor)
{
InjectionMessage myInjectionMessage = new InjectionMessage();
myInjectionMessage.InjectorID = pInjectorID;
myInjectionMessage.InjectorName = pInjectorName;
myInjectionMessage.VaccineID = pVaccineID;
myInjectionMessage.VaccineName = pVaccineName;
myInjectionMessage.InjectionMessageSite = pInjectionMessageSite;
myInjectionMessage.InjectionMessageTime = Convert.ToDateTime(pInjectionMessageTime);
myInjectionMessage.InjectionMessageDoctor = pInjectionMessageDoctor;
return(myInjectionMessage);
}
public void InjectionMessageUpdateFailureInjectionMessageIdArgumentException()
{
IInjectionMessageStorage pInjectionMessageStorage = new InjectionMessageStorage();
IInjectorStorage pInjectorStorage = new InjectorStorage();
IVaccineStorage pVaccineStorage = new VaccineStorage();
int pgetInjectorID = getInjectorID();
int pgetVaccineID = getVaccineID();
InjectionMessage myInjectionMessage = CreateInjectionMessageForTest(
pgetInjectorID,
pInjectorStorage.ReadInjector(pgetInjectorID).InjectorName,
pgetVaccineID,
pVaccineStorage.ReadVaccine(pgetVaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
"陈医生");
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
myInjectionMessage.InjectionMessageID = int.MaxValue;
pInjectionMessageStorage.UpdateInjectionMessage(myInjectionMessage);
}
public void InjectionMessageListSuccess()
{
List <InjectionMessage> injectionMessageList = new List <InjectionMessage>();
IInjectionMessageStorage pInjectionMessageStorage = new InjectionMessageStorage();
IInjectorStorage pInjectorStorage = new InjectorStorage();
IVaccineStorage pVaccineStorage = new VaccineStorage();
int pgetInjectorID = getInjectorID();
int pgetVaccineID = getVaccineID();
InjectionMessage myInjectionMessage = CreateInjectionMessageForTest(
pgetInjectorID,
pInjectorStorage.ReadInjector(pgetInjectorID).InjectorName,
pgetVaccineID,
pVaccineStorage.ReadVaccine(pgetVaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
"陈医生");
InjectionMessage createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
pgetInjectorID = getInjectorID();
myInjectionMessage = CreateInjectionMessageForTest(
pgetInjectorID,
pInjectorStorage.ReadInjector(pgetInjectorID).InjectorName,
createdInjectionMessage.VaccineID,
pVaccineStorage.ReadVaccine(createdInjectionMessage.VaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
"陈医生");
createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
pgetVaccineID = getVaccineID();
myInjectionMessage = CreateInjectionMessageForTest(
createdInjectionMessage.InjectorID,
pInjectorStorage.ReadInjector(createdInjectionMessage.InjectorID).InjectorName,
pgetVaccineID,
pVaccineStorage.ReadVaccine(pgetVaccineID).VaccineName,
"某某人民医院",
"2016-03-30",
"陈医生");
createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
myInjectionMessage = CreateInjectionMessageForTest(
createdInjectionMessage.InjectorID,
pInjectorStorage.ReadInjector(createdInjectionMessage.InjectorID).InjectorName,
createdInjectionMessage.VaccineID,
pVaccineStorage.ReadVaccine(createdInjectionMessage.VaccineID).VaccineName,
"海口市中医院",
"2016-03-30",
"陈医生");
createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
myInjectionMessage = CreateInjectionMessageForTest(
createdInjectionMessage.InjectorID,
pInjectorStorage.ReadInjector(createdInjectionMessage.InjectorID).InjectorName,
createdInjectionMessage.VaccineID,
pVaccineStorage.ReadVaccine(createdInjectionMessage.VaccineID).VaccineName,
"海口市中医院",
"2016-04-25",
"陈医生");
createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
myInjectionMessage = CreateInjectionMessageForTest(
createdInjectionMessage.InjectorID,
pInjectorStorage.ReadInjector(createdInjectionMessage.InjectorID).InjectorName,
createdInjectionMessage.VaccineID,
pVaccineStorage.ReadVaccine(createdInjectionMessage.VaccineID).VaccineName,
"海口市中医院",
"2016-04-25",
"欧阳医生");
createdInjectionMessage =
pInjectionMessageStorage.CreateInjectionMessage(myInjectionMessage);
injectionMessageList.Add(createdInjectionMessage);
QueryInjectionMessage queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = null;
queryInjectionMessage.VaccineID = null;
queryInjectionMessage.InjectionMessageSite = null;
queryInjectionMessage.InjectionMessageTime = null;
queryInjectionMessage.InjectionMessageDoctor = null;
IList <InjectionMessage> readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
injectionMessageList.RemoveAt(0);
queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = createdInjectionMessage.InjectorID;
queryInjectionMessage.VaccineID = null;
queryInjectionMessage.InjectionMessageSite = null;
queryInjectionMessage.InjectionMessageTime = null;
queryInjectionMessage.InjectionMessageDoctor = null;
readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
injectionMessageList.RemoveAt(0);
queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = null;
queryInjectionMessage.VaccineID = createdInjectionMessage.VaccineID;
queryInjectionMessage.InjectionMessageSite = null;
queryInjectionMessage.InjectionMessageTime = null;
queryInjectionMessage.InjectionMessageDoctor = null;
readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
injectionMessageList.RemoveAt(0);
queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = null;
queryInjectionMessage.VaccineID = null;
queryInjectionMessage.InjectionMessageSite = "海口市中医院";
queryInjectionMessage.InjectionMessageTime = null;
queryInjectionMessage.InjectionMessageDoctor = null;
readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
injectionMessageList.RemoveAt(0);
queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = null;
queryInjectionMessage.VaccineID = null;
queryInjectionMessage.InjectionMessageSite = null;
queryInjectionMessage.InjectionMessageTime = Convert.ToDateTime("2016-04-25");
queryInjectionMessage.InjectionMessageDoctor = null;
readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
injectionMessageList.RemoveAt(0);
queryInjectionMessage = new QueryInjectionMessage();
queryInjectionMessage.InjectionMessageID = null;
queryInjectionMessage.InjectorID = null;
queryInjectionMessage.VaccineID = null;
queryInjectionMessage.InjectionMessageSite = null;
queryInjectionMessage.InjectionMessageTime = null;
queryInjectionMessage.InjectionMessageDoctor = "欧阳医生";
readedInjectionMessageList =
pInjectionMessageStorage.ListInjectionMessage(queryInjectionMessage);
AssertInjectionMessageListsEqual(injectionMessageList, readedInjectionMessageList);
}
void IInjectionMessageStorage.UpdateInjectionMessage(InjectionMessage pInjectionMessage)
{
SqlConnection conn = null;
try
{
Verify.ArgumentNotNull(pInjectionMessage, "pInjectionMessage");
Verify.ArgumentNotSpecified(
pInjectionMessage.InjectionMessageID <= 0,
"pInjectionMessage.InjectionMessageID");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageSite,
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotNull(
pInjectionMessage.InjectionMessageDoctor,
"pInjectionMessage.InjectionMessageDoctor");
Verify.ArgumentNotSpecified(
pInjectionMessage.InjectorID <= 0,
"pInjectionMessage.InjectorID");
Verify.ArgumentNotSpecified(
pInjectionMessage.VaccineID <= 0,
"pInjectionMessage.VaccineID");
Verify.ArgumentNotSpecified(
pInjectionMessage.InjectionMessageSite.Length == 0,
"pInjectionMessage.InjectionMessageSite");
Verify.ArgumentNotSpecified(
pInjectionMessage.InjectionMessageDoctor.Length == 0,
"pInjectionMessage.InjectionMessageDoctor");
conn = new SqlConnection(
ConfigurationManager
.ConnectionStrings["DEFAULT"].ToString());
conn.Open();
int recordsAffected = InjectionMessageByInjectionMessageIdUpdateWrapper
.ExecuteNonQuery(
conn,
pInjectionMessage.InjectionMessageID,
pInjectionMessage.InjectorID,
pInjectionMessage.VaccineID,
pInjectionMessage.InjectionMessageSite,
pInjectionMessage.InjectionMessageTime,
pInjectionMessage.InjectionMessageDoctor);
conn.Close();
if (recordsAffected == 0)
{
throw new Exception("InjectionMessage update failure!");
}
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
//switch (ex.GetType().FullName)
//{
// case "System.ArgumentNullException":
// {
// throw new ArgumentNullException(ex.Message);
// }
// case "System.ArgumentException":
// {
// throw new ArgumentException(ex.Message);
// }
// default:
// throw new Exception(ex.Message);
//}
}
#region Dispose
finally
{
if (conn != null)
{
conn.Dispose();
}
}
#endregion
}
InjectionMessage IInjectionMessageStorage.ReadInjectionMessage(int pInjectionMessageID)
{
InjectionMessage myInjectionMessage = null;
SqlConnection conn = null;
IDataReader reader = null;
try
{
Verify.ArgumentNotNull(pInjectionMessageID);
myInjectionMessage = new InjectionMessage();
conn = new SqlConnection(
ConfigurationManager
.ConnectionStrings["DEFAULT"].ToString());
conn.Open();
reader = InjectionMessageByInjectionMessageIdSelectWrapper.ExecuteReader(
conn,
pInjectionMessageID);
if (!reader.Read())
{
throw new Exception("InjectionMessage read failure!");
}
myInjectionMessage = DAUtil.ReadInjectionMessage(reader);
conn.Close();
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
//switch (ex.GetType().FullName)
//{
// case "System.ArgumentNullException":
// {
// throw new ArgumentNullException(ex.Message);
// }
// case "System.ArgumentException":
// {
// throw new ArgumentException(ex.Message);
// }
// default:
// throw new Exception(ex.Message);
//}
}
#region Dispose
finally
{
if (reader != null)
{
reader.Dispose();
}
if (conn != null)
{
conn.Dispose();
}
}
#endregion
return(myInjectionMessage);
}
