private void btnSelect_Click(object sender, EventArgs e)
{
IList <Injector> injectorList = new List <Injector>();
IInjectorStorage injectorStorage = new InjectorStorage();
QueryInjector queryInjector = new QueryInjector();
queryInjector.InjectorName = textInjectorName.Text.Trim();
queryInjector.InjectorSex = textInjectorSex.Text.Trim();
queryInjector.InjectorPhone = textInjectorPhone.Text.Trim();
injectorList = injectorStorage.ListInjector(queryInjector);
dgvInjector.AutoGenerateColumns = true;
dgvInjector.DataSource = injectorList;
dgvInjector.Columns[0].Visible = false;
dgvInjector.Columns[1].Width = 130;
dgvInjector.Columns[2].Width = 130;
dgvInjector.Columns[3].Width = 125;
dgvInjector.Columns[4].Width = 130;
dgvInjector.Columns[5].Width = 130;
}
IList <Injector> IInjectorManager.GetInjectorList(
IInjectorStorage pStorage,
QueryInjector pQueryInjector)
{
IList <Injector> response = null;
try
{
#region Verify argument
Verify.ArgumentNotNull(pStorage, "pStorage");
Verify.ArgumentNotNull(pQueryInjector, "pQueryInjector");
#endregion
response =
pStorage.ListInjector(pQueryInjector);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
return(response);
}
IList <Injector> IInjectorStorage.ListInjector(QueryInjector pQueryInjector)
{
List <Injector> injectorList = null;
SqlConnection conn;
IDataReader reader;
try
{
Verify.ArgumentNotNull(pQueryInjector, "pQueryInjector");
conn = new SqlConnection(
ConfigurationManager
.ConnectionStrings["DEFAULT"].ToString());
conn.Open();
reader = InjectorSelectWrapper.ExecuteReader(
conn,
pQueryInjector);
if (reader != null)
{
injectorList = new List <Injector>();
while (reader.Read())
{
Injector myInjector = DAUtil.ReadInjector(
reader);
injectorList.Add(myInjector);
}
}
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(injectorList);
}
//数据源动态绑定
private void InjectionMessageForm_Load(object sender, EventArgs e)
{
IList <Injector> injectorList = new List <Injector>();
IInjectorStorage injectorStorage = new InjectorStorage();
QueryInjector queryInjector = new QueryInjector();
IList <Vaccine> vaccineList = new List <Vaccine>();
IVaccineStorage vaccineStorage = new VaccineStorage();
QueryVaccine queryVaccine = new QueryVaccine();
injectorList = injectorStorage.ListInjector(queryInjector);
vaccineList = vaccineStorage.ListVaccine(queryVaccine);
cmbInjectorName.DataSource = injectorList;
DataTable dtInjector = new DataTable();
cmbVaccineName.DataSource = vaccineList;
DataTable dtVaccine = new DataTable();
dtInjector.Columns.Add("InjectorID", typeof(System.Int32));
dtInjector.Columns.Add("InjectorName", typeof(System.String));
dtVaccine.Columns.Add("VaccineID", typeof(System.Int32));
dtVaccine.Columns.Add("VaccineName", typeof(System.String));
foreach (Injector pInjectorlist in injectorList)
{
dtInjector.Rows.Add(
pInjectorlist.InjectorID,
pInjectorlist.InjectorName
);
}
foreach (Vaccine pVaccinelist in vaccineList)
{
dtVaccine.Rows.Add(
pVaccinelist.VaccineID,
pVaccinelist.VaccineName
);
}
cmbInjectorName.DisplayMember = Convert.ToString(dtInjector.Columns[1]);
cmbInjectorName.ValueMember = Convert.ToString(dtInjector.Columns[0]);
cmbVaccineName.DisplayMember = Convert.ToString(dtVaccine.Columns[1]);
cmbVaccineName.ValueMember = Convert.ToString(dtVaccine.Columns[0]);
cmbInjectorName.Text = "";
cmbVaccineName.Text = "";
}
public void InjectorListSuccess()
{
List <Injector> injectorList = new List <Injector>();
IInjectorStorage injectorStorage = new InjectorStorage();
Injector myInjector = CreateInjectorForTest(
"李某某11",
"男11",
"17733441111",
"3",
"2013-10-09");
Injector createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
myInjector = CreateInjectorForTest(
"李某某12",
"男11",
"17733441111",
"3",
"2013-10-09");
createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
myInjector = CreateInjectorForTest(
"李某某12",
"男12",
"17733441111",
"3",
"2013-10-09");
createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
myInjector = CreateInjectorForTest(
"李某某12",
"男12",
"17733441112",
"3",
"2013-10-09");
createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
myInjector = CreateInjectorForTest(
"李某某12",
"男12",
"17733441112",
"2",
"2013-10-09");
createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
myInjector = CreateInjectorForTest(
"李某某12",
"男12",
"17733441112",
"2",
"2013-11-09");
createdInjector =
injectorStorage.CreateInjector(myInjector);
injectorList.Add(createdInjector);
QueryInjector queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = null;
queryInjector.InjectorSex = null;
queryInjector.InjectorPhone = null;
queryInjector.InjectorNumber = null;
queryInjector.InjectorTime = null;
IList <Injector> readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
injectorList.RemoveAt(0);
queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = "李某某12";
queryInjector.InjectorSex = null;
queryInjector.InjectorPhone = null;
queryInjector.InjectorNumber = null;
queryInjector.InjectorTime = null;
readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
injectorList.RemoveAt(0);
queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = null;
queryInjector.InjectorSex = "男12";
queryInjector.InjectorPhone = null;
queryInjector.InjectorNumber = null;
queryInjector.InjectorTime = null;
readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
injectorList.RemoveAt(0);
queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = null;
queryInjector.InjectorSex = null;
queryInjector.InjectorPhone = "17733441112";
queryInjector.InjectorNumber = null;
queryInjector.InjectorTime = null;
readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
injectorList.RemoveAt(0);
queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = null;
queryInjector.InjectorSex = null;
queryInjector.InjectorPhone = null;
queryInjector.InjectorNumber = Convert.ToInt32("2");
queryInjector.InjectorTime = null;
readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
injectorList.RemoveAt(0);
queryInjector = new QueryInjector();
queryInjector.InjectorID = null;
queryInjector.InjectorName = null;
queryInjector.InjectorSex = null;
queryInjector.InjectorPhone = null;
queryInjector.InjectorNumber = null;
queryInjector.InjectorTime = Convert.ToDateTime("2013-11-09");
readedInjectorList =
injectorStorage.ListInjector(queryInjector);
AssertInjectorListsEqual(injectorList, readedInjectorList);
}
public static SqlDataReader ExecuteReader(
SqlConnection connection,
QueryInjector pQueryInjector)
{
SqlDataReader reader;
SqlCommand cmd = null;
SqlParameter p;
try
{
cmd = new SqlCommand();
cmd.CommandText = "spInjectorSelect";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = connection;
//******* InjectorID *******
object val;
if (pQueryInjector.InjectorID == null)
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorID;
}
p = new SqlParameter("@pInjectorID", SqlDbType.Int);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* InjectorName *******
if (pQueryInjector.InjectorName == null ||
pQueryInjector.InjectorName == "")
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorName;
}
p = new SqlParameter("@pInjectorName", SqlDbType.VarChar, 50);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* InjectorSex *******
if (pQueryInjector.InjectorSex == null ||
pQueryInjector.InjectorSex == "")
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorSex;
}
p = new SqlParameter("@pInjectorSex", SqlDbType.VarChar, 20);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* InjectorPhone *******
if (pQueryInjector.InjectorPhone == null ||
pQueryInjector.InjectorPhone == "")
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorPhone;
}
p = new SqlParameter("@pInjectorPhone", SqlDbType.VarChar, 50);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* InjectorNumber *******
if (pQueryInjector.InjectorNumber == null)
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorNumber;
}
p = new SqlParameter("@pInjectorNumber", SqlDbType.Int);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
//******* InjectorTime *******
if (pQueryInjector.InjectorTime == null)
{
val = DBNull.Value;
}
else
{
val = pQueryInjector.InjectorTime;
}
p = new SqlParameter("@pInjectorTime", SqlDbType.DateTime);
p.Direction = ParameterDirection.Input;
p.Value = val;
cmd.Parameters.Add(p);
reader = cmd.ExecuteReader();
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
}
return(reader);
}
