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