protected void Page_Load(object sender, EventArgs e)
{
EMSdb1Entities db = new EMSdb1Entities();
if (Session["CurrentId"] != null)
{
string uid = Session["CurrentId"].ToString();
var result = from m in db.Emp
where m.Emp_id == uid
select m;
StringBuilder sb = new StringBuilder();
foreach (var s in result)
{
sb.Append(string.Format(s.Emp_name));
}
Label1.Text = sb.ToString();
}
if (!Page.IsPostBack)
{
ShowData();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
EMSdb1Entities db = new EMSdb1Entities();
try
{
string Uid = TextBox1.Text;
string Upass = TextBox2.Text;
var result1 = db.Emp.Where(m => m.Emp_id == Uid && m.Emp_pass == Upass);
if (result1.Count() != 0)
{
var result2 = from m in db.Emp
where m.Emp_id == TextBox1.Text
select m;
StringBuilder sb = new StringBuilder();
foreach (var s in result2)
{
sb.Append(s.Emp_manager);
}
Session["CurrentId"] = TextBox1.Text;
if (sb.ToString() == "True")
{
Response.Redirect("./Default.aspx");
}
else
{
Response.Redirect("./1.aspx");
}
}
else
{
Response.Write("<script>alert('编号或密码错误')</script>");
}
}
catch
{
Response.Write("<script>alert('登录异常')</script>");
}
}
//查询功能
protected void Button1_Click(object sender, EventArgs e)
{
string keyword = TextBox1.Text;
StringBuilder sb = new StringBuilder();
if (TextBox1.Text == "")
{
sb.Append("请输入设备信息");
Label2.Text = sb.ToString();
return;
}
else
{
EMSdb1Entities db = new EMSdb1Entities();
//使用LINQ方法
var result1 = db.Equ.Where(m => m.Equ_Id.Contains(keyword));
var result2 = db.Equ.Where(m => m.Equ_name.Contains(keyword));
var result3 = db.Equ.Where(m => m.Equ_date.ToString().Contains(keyword));
var result4 = db.Equ.Where(m => m.Equ_location.Contains(keyword));
var result5 = db.Equ.Where(m => m.Equ_resp.Contains(keyword));
if (result1.Count() != 0) //设备编号查询
{
foreach (var m in result1)
{
sb.Append(m.Equ_Id + " ");
sb.Append(m.Equ_name + " ");
sb.Append(m.Equ_standards + " ");
sb.Append(m.Equ_price + " ");
sb.Append(m.Equ_date + " ");
sb.Append(m.Equ_location + " ");
sb.Append(m.Equ_resp + " ");
sb.Append("<img src=\"" + m.Equ_img + "\">");
sb.Append("<hr/>");
}
Label2.Text = sb.ToString();
}
else if (result2.Count() != 0) //设备名称查询
{
foreach (var m in result2)
{
sb.Append(m.Equ_Id + " ");
sb.Append(m.Equ_name + " ");
sb.Append(m.Equ_standards + " ");
sb.Append(m.Equ_price + " ");
sb.Append(m.Equ_date + " ");
sb.Append(m.Equ_location + " ");
sb.Append(m.Equ_resp + " ");
sb.Append("<img src=\"" + m.Equ_img + "\">");
sb.Append("<hr/>");
}
Label2.Text = sb.ToString();
}
else if (result3.Count() != 0) //按照设备购入日期查询
{
foreach (var m in result3)
{
sb.Append(m.Equ_Id + " ");
sb.Append(m.Equ_name + " ");
sb.Append(m.Equ_standards + " ");
sb.Append(m.Equ_price + " ");
sb.Append(m.Equ_date + " ");
sb.Append(m.Equ_location + " ");
sb.Append(m.Equ_resp + " ");
sb.Append("<img src=\"" + m.Equ_img + "\">");
sb.Append("<hr/>");
}
Label2.Text = sb.ToString();
}
else if (result4.Count() != 0) //按照存放位置查询
{
foreach (var m in result4)
{
sb.Append(m.Equ_Id + " ");
sb.Append(m.Equ_name + " ");
sb.Append(m.Equ_standards + " ");
sb.Append(m.Equ_price + " ");
sb.Append(m.Equ_date + " ");
sb.Append(m.Equ_location + " ");
sb.Append(m.Equ_resp + " ");
sb.Append("<img src=\"" + m.Equ_img + "\">");
sb.Append("<hr/>");
}
Label2.Text = sb.ToString();
}
else if (result5.Count() != 0) //按照负责人编号查询
{
foreach (var m in result5)
{
sb.Append(m.Equ_Id + " ");
sb.Append(m.Equ_name + " ");
sb.Append(m.Equ_standards + " ");
sb.Append(m.Equ_price + " ");
sb.Append(m.Equ_date + " ");
sb.Append(m.Equ_location + " ");
sb.Append(m.Equ_resp + " ");
sb.Append("<img src=\"" + m.Equ_img + "\">");
sb.Append("<hr/>");
}
Label2.Text = sb.ToString();
}
else
{
sb.Append("查无设备!");
Label2.Text = sb.ToString();
return;
}
}
}
