void GetAll()
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
string sql = string.Format("select distinct eq.eqptId,eq.eqptName," +
"eq.specifications,eq.picture,eq.price,eq.PurchaseDate,eq.location," +
"eq.num,em.name from employee em, equipment eq " +
"where eq.mgrId = em.empId");
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EqptEntity eqptEntity = new EqptEntity();
for (int i = 0; i < dr.FieldCount; i++)
{
eqptEntity.EqptId = int.Parse(dr[0].ToString());
eqptEntity.EqptName = dr[1].ToString();
eqptEntity.Specifications = dr[2].ToString();
eqptEntity.Picture = dr[3].ToString();
eqptEntity.Price = dr[4].ToString();
eqptEntity.PurchaseDate = Convert.ToDateTime(dr[5]).Year.ToString();
eqptEntity.Location = dr[6].ToString();
eqptEntity.Mgr = dr[8].ToString();
eqptEntity.Num = int.Parse(dr[7].ToString());
}
eqptlist.Add(eqptEntity);
}
}
}
void GetAll(string accord, string key)
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
string sql = string.Format("select distinct eq.eqptId,eq.eqptName,eq.specifications,eq.picture," +
"eq.price,eq.PurchaseDate,eq.location,eq.num,em.name " +
"from department d, employee em, equipment eq where " +
"eq.mgrId = em.empId and em.deptId = d.deptId " +
"and {0} like N'%{1}%';", accord, key);
Label2.Text = sql;
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
EqptEntity eqptEntity = new EqptEntity();
for (int i = 0; i < dr.FieldCount; i++)
{
eqptEntity.EqptId = int.Parse(dr[0].ToString());
eqptEntity.EqptName = dr[1].ToString();
eqptEntity.Specifications = dr[2].ToString();
eqptEntity.Picture = dr[3].ToString();
eqptEntity.Price = dr[4].ToString();
eqptEntity.PurchaseDate = Convert.ToDateTime(dr[5]).Year.ToString();
eqptEntity.Location = dr[6].ToString();
eqptEntity.Mgr = dr[8].ToString();
eqptEntity.Num = int.Parse(dr[7].ToString());
}
eqptlist.Add(eqptEntity);
}
}
else
{
result.Visible = false;
Label1.Text = "查询“" + key + "”的结果为空！";
}
}
}
