/// <summary> /// 增加一条数据 /// </summary> public void Add(Dianda.Model.USER_Groups model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into USER_Groups("); strSql.Append("ID,NAME,CONTENTS,ROLE,DELFLAG,ISMOREN,TAGS)"); strSql.Append(" values ("); strSql.Append("@ID,@NAME,@CONTENTS,@ROLE,@DELFLAG,@ISMOREN,@TAGS)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50), new SqlParameter("@NAME", SqlDbType.VarChar, 50), new SqlParameter("@CONTENTS", SqlDbType.Text), new SqlParameter("@ROLE", SqlDbType.Text), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@ISMOREN", SqlDbType.Int, 4), new SqlParameter("@TAGS", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.NAME; parameters[2].Value = model.CONTENTS; parameters[3].Value = model.ROLE; parameters[4].Value = model.DELFLAG; parameters[5].Value = model.ISMOREN; parameters[6].Value = model.TAGS; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Dianda.Model.USER_Groups model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update USER_Groups set "); strSql.Append("NAME=@NAME,"); strSql.Append("CONTENTS=@CONTENTS,"); strSql.Append("ROLE=@ROLE,"); strSql.Append("DELFLAG=@DELFLAG,"); strSql.Append("ISMOREN=@ISMOREN,"); strSql.Append("TAGS=@TAGS"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50), new SqlParameter("@NAME", SqlDbType.VarChar, 50), new SqlParameter("@CONTENTS", SqlDbType.Text), new SqlParameter("@ROLE", SqlDbType.Text), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@ISMOREN", SqlDbType.Int, 4), new SqlParameter("@TAGS", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.NAME; parameters[2].Value = model.CONTENTS; parameters[3].Value = model.ROLE; parameters[4].Value = model.DELFLAG; parameters[5].Value = model.ISMOREN; parameters[6].Value = model.TAGS; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 点击删除按钮触发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button_delete_onclick(object sender, EventArgs e) { int num = 0; int rows = GridView1.Rows.Count; if (rows > 0) { for (int i = 0; i < rows; i++) { CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox_choose"); if (cb.Checked) { num = num + 1; } } if (num == 0) { tag.Text = "删除时最少选择一条数据!"; } else { tag.Text = ""; for (int j = 0; j < rows; j++) { CheckBox cb1 = (CheckBox)GridView1.Rows[j].Cells[0].FindControl("CheckBox_choose"); HiddenField hid = (HiddenField)GridView1.Rows[j].Cells[0].FindControl("Hid_ID"); if (cb1.Checked) { //获取到当前部门或岗位的基本信息 userGroupModel = GroupsBll.GetModel(hid.Value.ToString()); //将删除标记设为1 userGroupModel.DELFLAG = 1; GroupsBll.Update(userGroupModel); //添加操作日志 Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt(); Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; bsyslog.addlogs(user_model.REALNAME + "(" + user_model.USERNAME + ")", "删除" + Request["tags"].ToString(), "删除" + userGroupModel.NAME + "成功"); //添加操作日志 } } //tag.Text = "操作成功!"; //string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功!现在进入列表页面\"); location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "&tags=" +Request["tags"]+ "\";</script>"; //Response.Write(coutws); ScriptManager.RegisterStartupScript(this, this.GetType(), "ok", "<script>alert('操作成功!现在进入我的列表页面');javascript:location='manage.aspx?pageindex=" + Request["pageindex"] + "&tags=" + Request["tags"] + "';</script>", false); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //部门或岗位标识 string tag = Request["tags"].ToString(); //部门或岗位ID string ID = Request["ID"].ToString(); LB_NAME1.Text = tag; LB_NAME2.Text = tag; //获取到当前部门或岗位的基本信息 userGroupModel = userGroups.GetModel(ID); NAME.Text = userGroupModel.NAME; CONTENT.Text = userGroupModel.CONTENTS; //设置模板页中的管理值 (Master.FindControl("Label_navigation") as Label).Text = "管理 > 人事管理 "; //设置模板页中的管理值 } }
/// <summary> /// 得到一个对象实体 /// </summary> public Dianda.Model.USER_Groups GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,NAME,CONTENTS,ROLE,DELFLAG,ISMOREN,TAGS from USER_Groups "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50) }; parameters[0].Value = ID; Dianda.Model.USER_Groups model = new Dianda.Model.USER_Groups(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ID = ds.Tables[0].Rows[0]["ID"].ToString(); model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString(); model.CONTENTS = ds.Tables[0].Rows[0]["CONTENTS"].ToString(); model.ROLE = ds.Tables[0].Rows[0]["ROLE"].ToString(); if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "") { model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString()); } if (ds.Tables[0].Rows[0]["ISMOREN"].ToString() != "") { model.ISMOREN = int.Parse(ds.Tables[0].Rows[0]["ISMOREN"].ToString()); } model.TAGS = ds.Tables[0].Rows[0]["TAGS"].ToString(); return(model); } else { return(null); } }