//绑定Dropdownlist public void DropDownList_Bind() { EFModel.Database1Entities context = new EFModel.Database1Entities(); DropDownList_Search.Items.Clear(); DropDownList_Search.Items.Add(new ListItem("请选择您要搜素的科室名称", "0")); var query = from t in context.Office orderby t.科室ID where t.所属部门ID == departmentId select t.科室名称; int y = 1; foreach (var q in query) { DropDownList_Search.Items.Add(new ListItem(q.ToString(), y.ToString())); y++; } }
protected void SubmitButton_Click(object sender, EventArgs e) { /* if (string.IsNullOrEmpty(username.Text)) { Label1.Text = "请输入用户名!"; return; } if (string.IsNullOrEmpty(password.Text)) { Label1.Text = "请输入密码"; return; } * */ Label1.Text = "正在验证……"; EFModel.Database1Entities context = new EFModel.Database1Entities(); var q = from t in context.LoginInfo where t.用户名 == Username.Text select t; if (q.Count() == 0) { Label1.Text = "用户名不存在!"; } else { if (Password.Text == q.First().密码) { Label1.Text = "登录成功!即将为您跳转……"; Session["UserFlag"] = true; Session["UserName"] = Username.Text; Session["UserType"] = q.First().用户类型; //Response.Redirect(string.Format("WebForm1.aspx?userName={0}", Server.UrlEncode(q.First().用户名))); if (q.First().用户类型 == "超级管理员") { Response.Redirect("../Admin/AdminWebForm.aspx"); } else if (q.First().用户类型 == "部门") { Response.Redirect("../Department/DepartmentWebForm.aspx"); } else { Response.Redirect("../Tourist/TouristWebForm.aspx"); } } else { Label1.Text = "密码不正确!"; } } }
protected void Button1_Click(object sender, EventArgs e) { string password = string.Empty; string str = this.yanZhengMa.Text.ToString(); string ss = str[0].ToString() + str[1].ToString() + str[2].ToString().ToUpper() + str[3].ToString(); if (Session["validate"].Equals(ss)) { string name = Session["UserName"].ToString(); EFModel.Database1Entities context = new EFModel.Database1Entities(); var query = from t in context.LoginInfo where t.用户名 == name select t.密码; foreach (var q in query) { password = q; } if (password.Equals(this.oldPassword.Text.ToString())) { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); string sql = "update LoginInfo set 密码='" + NewPassword.Text + "' where 用户名='" + name + "'"; SqlCommand cmd = new SqlCommand(sql, conn); try { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); Js_ShowMessage("恭喜您,密码修改成功!请重新登录!"); Session["UserFlag"] = false; Js_Redirect("../Index.aspx"); Response.End(); } catch (Exception) { Js_ShowMessage("对不起,密码修改失败!"); Js_Redirect("AdminAccount.aspx"); Response.End(); throw; } } else { Response.Write("<script>alert('对不起,您输入的原始密码错误!');</script>"); Js_Redirect("AdminAccount.aspx"); } } else { Response.Write("<script>alert('验证码错误!');</script>"); Js_Redirect("AdminAccount.aspx"); } }
/// <summary> /// 添加部门 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddDepartment_Click(object sender, EventArgs e) { if (this.txtDepartmentName.Text.Equals("")) { Js_ShowMessage("部门名称不能为空!"); } else { EFModel.Database1Entities context = new EFModel.Database1Entities(); var q = from t in context.Department select t.部门名称; foreach (var i in q) { if (i.Equals(this.txtDepartmentName.Text)) { Js_ShowMessage("该部门已经存在了!"); this.txtDepartmentName.Text = ""; return; } } string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(strConn); try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert into Department(部门名称,部门地点) values('" + txtDepartmentName.Text + "','" + txtDepartmentPlace.Text + "');insert into LoginInfo values('" + txtDepartmentName.Text + "','0123456789','部门')"; cmd.ExecuteNonQuery(); conn.Close(); Js_ShowMessage("添加成功!"); this.txtDepartmentName.Text = ""; GridViewDepartment.DataBind(); this.DropDownList_Search.DataBind(); GridViewDepartment.PageIndex = GridViewDepartment.PageCount - 1; // 将当前显示页的索引转到最后一页 GridViewDepartment.DataBind(); //重新绑定数据,这是十分重要,这样才能到达最后一页 int lastSize = GridViewDepartment.Rows.Count; this.GridViewDepartment.Rows[lastSize - 1].BackColor = Color.Red; } catch (Exception) { Js_ShowMessage("对不起,添加失败!"); throw; } } }
//绑定Dropdownlist public void DropDownList_Bind() { EFModel.Database1Entities context = new EFModel.Database1Entities(); DropDownList_Search.Items.Clear(); DropDownList_Search.Items.Add(new ListItem("请选择您要搜素的事项名称", "0")); var query = from t in context.MatterRelatedDepartment orderby t.事项ID where t.部门ID == departmentId select t.事项名称; int y = 1; foreach (var q1 in query) { DropDownList_Search.Items.Add(new ListItem(q1.ToString(),y.ToString())); y++; } DropDownList_office.Items.Clear(); DropDownList_office.Items.Add(new ListItem("请选择科室名称", "0")); var query1 = from t1 in context.Office where t1.所属部门ID == departmentId select t1.科室名称; int x = 1; foreach (var q1 in query1) { DropDownList_office.Items.Add(new ListItem(q1.ToString(), x.ToString())); x++; } }
//代码绑定gridview public void Bind() { EFModel.Database1Entities context = new EFModel.Database1Entities(); string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(strConn); name = HttpContext.Current.Session["UserName"].ToString(); var q = from t in context.Department where t.部门名称 == name select t.部门ID; foreach (var v in q) { departmentId = v; } conn.Open(); string sqlStr = "select 步骤号,事项名称 from MatterRelatedDepartment where 部门ID='" + departmentId + "'"; SqlDataAdapter myda = new SqlDataAdapter(sqlStr, conn); DataSet myds = new DataSet(); myda.Fill(myds, name); GridView1.DataSource = myds; GridView1.DataBind(); conn.Close(); //MatterRelatedThis.DepartmentId = departmentId; //ClientScript.RegisterStartupScript(ClientScript.GetType(), "sclo", "<script>DropDownList_Bind();</script>"); }
protected void btnSave_Click(object sender, EventArgs e) { string officeName = ""; if (this.DropDownList_office.SelectedIndex == 0) { officeId = 0; } else { officeName = this.DropDownList_office.SelectedItem.Text; EFModel.Database1Entities context = new EFModel.Database1Entities(); var query = from t in context.Office where t.科室名称 == officeName select t.科室ID; foreach (var q in query) { officeId = q; } } string stepDescript = officeName + "." + this.address.Text + "." + this.person.Text + "." + this.remark.Text; string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(strConn); try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); if (officeId == 0) { cmd.CommandText = "update MatterRelatedDepartment set 科室ID=null,步骤描述='" + stepDescript + "' where 步骤号='" + a + "' AND 事项名称='" + strName + "'"; } else { cmd.CommandText = "update MatterRelatedDepartment set 科室ID='" + officeId + "',步骤描述='" + stepDescript + "' where 步骤号='" + a + "' AND 事项名称='" + strName + "'"; } cmd.ExecuteNonQuery(); conn.Close(); Js_ShowMessage("保存成功!"); this.DropDownList_office.Enabled = false; this.address.Enabled = false; this.person.Enabled = false; this.remark.Enabled = false; this.btnSave.Enabled = false; this.btnEdit.Enabled = true; } catch (Exception) { Js_ShowMessage("对不起,保存失败了!"); throw; } }
//事项详情 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "detailed") { this.address.Text = ""; this.person.Text = ""; this.remark.Text = ""; this.DropDownList_office.SelectedIndex = 0; this.btnEdit.Enabled = true; this.btnSave.Enabled = false; this.DropDownList_office.Enabled = false; this.address.Enabled = false; this.person.Enabled = false; this.remark.Enabled = false; //this.btnEdit.Enabled = true; //Button btn = (Button)e.CommandSource; //GridViewRow row = (GridViewRow)btn.Parent.Parent; //a = int.Parse(row.Cells[0].Text); //strName = row.Cells[1].Text; //Label1.Text = strName + "第" + a + "步>>步骤描述"; //div1.Visible = true; //EFModel.Database1Entities context = new EFModel.Database1Entities(); //var q = from t in context.MatterRelatedDepartment where t.步骤号 == a where t.事项名称 == strName select t.步骤描述; //foreach (var x in q) //{ // this.TextArea1.Value = x; //} //if (this.TextArea1.InnerText == "") //{ // this.TextArea1.Value = "尚无描述,请您描述该步骤的要求!"; //} //this.TextArea1.Disabled = true; Button btn = (Button)e.CommandSource; GridViewRow row = (GridViewRow)btn.Parent.Parent; a = int.Parse(row.Cells[0].Text); strName = row.Cells[1].Text; HiddenField1.Value = strName; Label1.Text = strName + "第" + a + "步>>步骤描述"; EFModel.Database1Entities context = new EFModel.Database1Entities(); var query = from t in context.MatterRelatedDepartment where t.步骤号 == a where t.事项名称 == strName select t.步骤描述; foreach (var q in query) { if (q == null) { return; } else { s = q.ToString(); } } string[] ss = new string[] { }; ss = s.Split('.'); for (int i = 0; i < this.DropDownList_office.Items.Count; ++i) { if (this.DropDownList_office.Items[i].Text == ss[0]) { //this.DropDownList_office.Items[i].Selected = true; this.DropDownList_office.SelectedIndex = i; } //else //{ // this.DropDownList_office.Items[i].Selected = false; //} } this.address.Text = ss[1]; this.person.Text = ss[2]; this.remark.Text = ss[3]; } }
protected void Page_Load(object sender, EventArgs e) { //判断是否登录,减少异常 if (Session.IsNewSession) { Session["UserFlag"] = false; Response.Redirect("../Account/LoginWebForm.aspx"); return; } if (Session["UserFlag"].ToString() == "false") { Response.Redirect("../Account/LoginWebForm.aspx"); return; } if (Session["UserType"].ToString() != "部门") { Response.Redirect("../Index.aspx"); return; } string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); string sql = "SELECT * FROM ReplyInfo WHERE 回复对象='" + Session["UserName"] + "' AND isRead='否' ORDER BY 回复时间 DESC"; SqlDataAdapter adpter = new SqlDataAdapter(sql, conn); DataTable table_UnRead = new DataTable(); adpter.Fill(table_UnRead); string strHtml = string.Empty; EFModel.Database1Entities entity = new EFModel.Database1Entities(); for (int i = 0; i < table_UnRead.Rows.Count; i++) { DataRow row = table_UnRead.Rows[i]; strHtml += "<div class=\"info_item\">"; strHtml += row[1] + ":" + row[4] + " " + row[5]; strHtml += "<span class=\"reply_span\">回复</span>"; strHtml += "<div class=\"reply_div\">"; strHtml += "<textarea style=\"height:20px;width:400px;\">请在此输入回复内容</textarea>" + "<input class=\"replyButton\" type=\"button\" value=\"发表\" data-messageid=\"" + row[2] + "\" data-replyuser=\"" + Session["UserName"] + "\" data-replyobject=\"" + row[1] + "\" data-objectid=\"" + row[0] + "\"/>"; strHtml += "</div><br/>"; var q = from t in entity.LeaveMessagesInfo where t.留言ID == (int)row[2] select t; var message = q.First(); strHtml += "<div class=\"message_content\">" + message.留言用户 + "向" + message.留言部门ID + "留言:" + message.留言内容 + " " + message.留言时间 + "</div>"; if ((int)row[7] != -1) { var q2 = from t in entity.ReplyInfo where t.回复ID == (int)row[7] select t; var reply = q2.First(); strHtml += "<div class=\"reply_content\">" + reply.回复用户 + "回复" + reply.回复对象 + ":" + reply.回复内容 + " " + reply.回复时间 + "</div>"; } strHtml += "</div>"; //将“否”改为“是” string sql2 = "UPDATE ReplyInfo SET isRead='是' WHERE 回复ID='" + row[0] + "'"; SqlCommand cmd = new SqlCommand(sql2, conn); try { conn.Open(); cmd.ExecuteNonQuery(); } catch { } finally { conn.Close(); } } if (strHtml == string.Empty) { strHtml += "您没有最新动态!"; } content_right_message.InnerHtml = strHtml; Label1.Text = "第1页/共1页"; }