protected void Button1_Click(object sender, EventArgs e)
{
string keyword = TextBox1.Text;
StringBuilder sb = new StringBuilder();
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m.EquipmentName == keyword
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无信息!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string keywordstr = TextBox1.Text;
StringBuilder sb = new StringBuilder();
if (DropDownList1.SelectedValue == "设备编号")
{
int keyword = Convert.ToInt32(keywordstr);
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m.EquipmentId == keyword
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else if (DropDownList1.SelectedValue == "设备名称")
{
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m.EquipmentName == keywordstr
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else if (DropDownList1.SelectedValue == "购买日期")
{
int keyword = Convert.ToInt32(keywordstr);
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m.DatePurchase.Value.Year == keyword
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else if (DropDownList1.SelectedValue == "存放位置")
{
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m.StorageLocation == keywordstr
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else if (DropDownList1.SelectedValue == "设备负责人")
{
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m1.EmployeeName == keywordstr
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else
{
MessageEntities db = new MessageEntities();
var result = from m in db.Equipment
join m1 in db.Employee on m.EquipmentManager equals m1.EmployeeId
join m2 in db.Department on m1.EmployeeBelongDep equals m2.DepartmentId
where m2.DepartmentName == keywordstr
select new
{
设备编号 = m.EquipmentId,
设备名称 = m.EquipmentName,
购买日期 = m.DatePurchase,
存放位置 = m.StorageLocation,
设备负责人 = m1.EmployeeName,
所属部门 = m2.DepartmentName
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无产品!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string keywordstr = TextBox1.Text;
StringBuilder sb = new StringBuilder();
if (DropDownList1.SelectedValue == "部门编号")
{
int keyword = Convert.ToInt32(keywordstr);
MessageEntities db = new MessageEntities();
var result = from m in db.Department
where m.DepartmentId == keyword
select new
{
部门编号 = m.DepartmentId,
部门名称 = m.DepartmentName,
部门主管 = m.DepartmentManager
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无信息!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else if (DropDownList1.SelectedValue == "部门名称")
{
MessageEntities db = new MessageEntities();
var result = from m in db.Department
where m.DepartmentName == keywordstr
select new
{
部门编号 = m.DepartmentId,
部门名称 = m.DepartmentName,
部门主管 = m.DepartmentManager
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无信息!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
else
{
int keyword = Convert.ToInt32(keywordstr);
MessageEntities db = new MessageEntities();
var result = from m in db.Department
where m.DepartmentManager == keyword
select new
{
部门编号 = m.DepartmentId,
部门名称 = m.DepartmentName,
部门主管 = m.DepartmentManager
};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
if (result.Count() == 0)
{
sb.Append("查无信息!");
Label1.Text = sb.ToString();
}
else
{
sb.Append("");
Label1.Text = sb.ToString();
}
}
}