private void btnSelect_Click(object sender, EventArgs e)
{
IList <Manufacturers> manufacturersList = new List <Manufacturers>();
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
QueryManufacturers queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersName = textManufacturersName.Text.Trim();
queryManufacturers.ManufacturersSite = textManufacturersSite.Text.Trim();
queryManufacturers.ManufacturersPhone = textManufacturersPhone.Text.Trim();
manufacturersList = manufacturersStorage.ListManufacturers(queryManufacturers);
dgvManufacturers.AutoGenerateColumns = true;
dgvManufacturers.DataSource = manufacturersList;
dgvManufacturers.Columns[0].Visible = false;
dgvManufacturers.Columns[1].Width = 130;
dgvManufacturers.Columns[2].Width = 130;
dgvManufacturers.Columns[3].Width = 125;
dgvManufacturers.Columns[4].Width = 130;
dgvManufacturers.Columns[5].Width = 130;
}
public void ManufacturersUpdateSuccessFive()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商4",
"浙江温州4",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
Assert.AreNotEqual(
0,
createdManufacturers.ManufacturersID,
string.Format("Could not create Manufacturers:{0}",
createdManufacturers.ManufacturersID));
myManufacturers.ManufacturersDoe = Convert.ToDateTime("2016-06-30");
manufacturersStorage.UpdateManufacturers(myManufacturers);
Manufacturers updatedManufacturers = manufacturersStorage.ReadManufacturers(
createdManufacturers.ManufacturersID);
AssertManufacturersItemEqual(myManufacturers, updatedManufacturers);
}
private void btnAdd_Click(object sender, EventArgs e)
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers manufacturers = new Manufacturers();
if (textManufacturersName.Text.Trim() == "" || textManufacturersSite.Text.Trim() == "" ||
textManufacturersPhone.Text.Trim() == "" || dtpManufacturersDom.Text.Trim() == "" ||
dtpManufacturersDoe.Text.Trim() == "")
{
MessageBox.Show("请输入全部信息，不要有遗漏。");
}
else
{
manufacturers.ManufacturersName = textManufacturersName.Text.Trim();
manufacturers.ManufacturersSite = textManufacturersSite.Text.Trim();
manufacturers.ManufacturersPhone = textManufacturersPhone.Text.Trim();
manufacturers.ManufacturersDom = Convert.ToDateTime(dtpManufacturersDom.Text.Trim());
manufacturers.ManufacturersDoe = Convert.ToDateTime(dtpManufacturersDoe.Text.Trim());
manufacturersStorage.CreateManufacturers(manufacturers);
MessageBox.Show("增加成功！");
textManufacturersName.Text = "";
textManufacturersSite.Text = "";
textManufacturersPhone.Text = "";
dtpManufacturersDom.Text = "";
dtpManufacturersDoe.Text = "";
}
}
private void btnModfiy_Click(object sender, EventArgs e)
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers manufacturers = new Manufacturers();
if (textManufacturersName.Text.Trim() == "" || textManufacturersSite.Text.Trim() == "" ||
textManufacturersPhone.Text.Trim() == "" || dtpManufacturersDom.Text.Trim() == "" ||
dtpManufacturersDoe.Text.Trim() == "")
{
MessageBox.Show("请双击需要修改的记录！");
}
else
{
manufacturers.ManufacturersName = textManufacturersName.Text;
manufacturers.ManufacturersSite = textManufacturersSite.Text;
manufacturers.ManufacturersPhone = textManufacturersPhone.Text;
manufacturers.ManufacturersDom = Convert.ToDateTime(dtpManufacturersDom.Text);
manufacturers.ManufacturersDoe = Convert.ToDateTime(dtpManufacturersDoe.Text);
manufacturers.ManufacturersID = Convert.ToInt32(dgvManufacturers[0, dgvManufacturers.CurrentCell.RowIndex].Value.ToString());
manufacturersStorage.UpdateManufacturers(manufacturers);
MessageBox.Show("更新成功！");
textManufacturersName.Text = "";
textManufacturersSite.Text = "";
textManufacturersPhone.Text = "";
dtpManufacturersDom.Text = "";
dtpManufacturersDoe.Text = "";
}
}
public static int getVaccineID()
{
IManufacturersStorage pManufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商",
"浙江温州",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
pManufacturersStorage.CreateManufacturers(myManufacturers);
IVaccineStorage pVaccineStorage = new VaccineStorage();
Vaccine myVaccine = CreateVaccineForTest(
"狂犬疫苗",
"处方",
createdManufacturers.ManufacturersID,
"68.00",
"45");
Vaccine createdVaccine =
pVaccineStorage.CreateVaccine(myVaccine);
return(createdVaccine.VaccineID);
}
public void ManufacturersCreateFailureManufacturersNameArgumentNullException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
null,
"浙江温州2",
"17733117779",
"2013-06-30",
"2016-06-30");
manufacturersStorage.CreateManufacturers(myManufacturers);
}
public void ManufacturersCreateFailureManufacturersSiteArgumentException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商1",
"",
"17733117779",
"2013-06-30",
"2016-06-30");
manufacturersStorage.CreateManufacturers(myManufacturers);
}
public void ManufacturersReadFailureManufacturersIdArgumentException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
// Manufacturers myManufacturers = CreateManufacturersForTest(
// "供应商3",
// "浙江温州3",
// "17733117779",
// "2013-06-30",
// "2016-06-30");
// Manufacturers createdManufacturers =
// manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersStorage.ReadManufacturers(-1);
}
private static int getManufacturersIDtwo()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商21",
"浙江温州21",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
return(createdManufacturers.ManufacturersID);
}
public void ManufacturersUpdateFailureManufacturersIdArgumentException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商4",
"浙江温州4",
"17733117779",
"2013-06-30",
"2016-06-30");
manufacturersStorage.CreateManufacturers(myManufacturers);
myManufacturers.ManufacturersID = int.MaxValue;
manufacturersStorage.UpdateManufacturers(myManufacturers);
}
private void btnSelect_Click(object sender, EventArgs e)
{
IList <Vaccine> vaccineList = new List <Vaccine>();
IVaccineStorage vaccineStorage = new VaccineStorage();
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
QueryVaccine queryVaccine = new QueryVaccine();
if (cmbManufacturersName.Text.Trim() == "")
{
queryVaccine.VaccineName = textVaccineName.Text.Trim();
queryVaccine.VaccineSort = textVaccineSort.Text.Trim();
}
else
{
queryVaccine.VaccineName = textVaccineName.Text.Trim();
queryVaccine.VaccineSort = textVaccineSort.Text.Trim();
queryVaccine.ManufacturersID = Convert.ToInt32(cmbManufacturersName.SelectedValue.ToString());
}
vaccineList = vaccineStorage.ListVaccine(queryVaccine);
foreach (Vaccine vaccine in vaccineList) //对vaccineList数组遍历
{
vaccine.ManufacturersName = (manufacturersStorage.ReadManufacturers(vaccine.ManufacturersID)).ManufacturersName;
}
dgvVaccine.AutoGenerateColumns = true;
dgvVaccine.DataSource = vaccineList;
dgvVaccine.Columns[0].Visible = false;
dgvVaccine.Columns[3].Visible = false;
dgvVaccine.Columns[1].Width = 130;
dgvVaccine.Columns[2].Width = 130;
dgvVaccine.Columns[4].Width = 130;
dgvVaccine.Columns[5].Width = 130;
dgvVaccine.Columns[6].Width = 130;
}
public void ManufacturersCreateSuccess()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商",
"浙江温州",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
Assert.AreNotEqual(
0,
createdManufacturers.ManufacturersID,
string.Format("Could not create Manufacturers:{0}",
createdManufacturers.ManufacturersID));
AssertManufacturersItemEqual(myManufacturers, createdManufacturers);
}
//这个属性其实非常有用处，它表明这个函数会抛出一个预期的异常。
public void ManufacturersCreateFailureManufacturersArgumentNullException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
manufacturersStorage.CreateManufacturers(null);
}
public void ManufacturersListFailureManufacturersArgumentNullException()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
manufacturersStorage.ListManufacturers(null);
}
public void ManufacturersListSuccess()
{
List <Manufacturers> manufacturersList = new List <Manufacturers>();
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商11",
"浙江温州11",
"17733117711",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
myManufacturers = CreateManufacturersForTest(
"供应商12",
"浙江温州11",
"17733117711",
"2013-06-30",
"2016-06-30");
createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
myManufacturers = CreateManufacturersForTest(
"供应商12",
"浙江温州12",
"17733117711",
"2013-06-30",
"2016-06-30");
createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
myManufacturers = CreateManufacturersForTest(
"供应商12",
"浙江温州12",
"17733117712",
"2013-06-30",
"2016-06-30");
createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
myManufacturers = CreateManufacturersForTest(
"供应商12",
"浙江温州12",
"17733117712",
"2013-06-29",
"2016-06-30");
createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
myManufacturers = CreateManufacturersForTest(
"供应商12",
"浙江温州12",
"17733117712",
"2013-06-29",
"2016-06-29");
createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
manufacturersList.Add(createdManufacturers);
QueryManufacturers queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = null;
queryManufacturers.ManufacturersSite = null;
queryManufacturers.ManufacturersPhone = null;
queryManufacturers.ManufacturersDom = null;
queryManufacturers.ManufacturersDoe = null;
IList <Manufacturers> readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
manufacturersList.RemoveAt(0);
queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = "供应商12";
queryManufacturers.ManufacturersSite = null;
queryManufacturers.ManufacturersPhone = null;
queryManufacturers.ManufacturersDom = null;
queryManufacturers.ManufacturersDoe = null;
readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
manufacturersList.RemoveAt(0);
queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = null;
queryManufacturers.ManufacturersSite = "浙江温州12";
queryManufacturers.ManufacturersPhone = null;
queryManufacturers.ManufacturersDom = null;
queryManufacturers.ManufacturersDoe = null;
readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
manufacturersList.RemoveAt(0);
queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = null;
queryManufacturers.ManufacturersSite = null;
queryManufacturers.ManufacturersPhone = "17733117712";
queryManufacturers.ManufacturersDom = null;
queryManufacturers.ManufacturersDoe = null;
readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
manufacturersList.RemoveAt(0);
queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = null;
queryManufacturers.ManufacturersSite = null;
queryManufacturers.ManufacturersPhone = null;
queryManufacturers.ManufacturersDom = Convert.ToDateTime("2013-06-29");
queryManufacturers.ManufacturersDoe = null;
readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
manufacturersList.RemoveAt(0);
queryManufacturers = new QueryManufacturers();
queryManufacturers.ManufacturersID = null;
queryManufacturers.ManufacturersName = null;
queryManufacturers.ManufacturersSite = null;
queryManufacturers.ManufacturersPhone = null;
queryManufacturers.ManufacturersDom = null;
queryManufacturers.ManufacturersDoe = Convert.ToDateTime("2016-06-29");
readedManufacturersList =
manufacturersStorage.ListManufacturers(queryManufacturers);
AssertManufacturersListsEqual(manufacturersList, readedManufacturersList);
}