/// <summary> /// 获取部门 /// </summary> /// <param name="deptId">部门编号</param> /// <returns>部门对象</returns> public virtual TSDept Get(string deptId) { TSDept tsDept = null; try { string strSQL = "select * from TSDept where deptId=@deptId"; Param param = new Param(); param.Clear(); param.Add("@deptId", deptId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tsDept = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(tsDept); }
/// <summary> /// 读取部门信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>部门对象</returns> protected virtual TSDept ReadData(ComDataReader dr) { TSDept tsDept = new TSDept(); tsDept.deptId = dr["deptId"].ToString(); //部门编号 tsDept.status = dr["status"].ToString(); //使用状态 tsDept.deptName = dr["deptName"].ToString(); //部门名称 tsDept.telephone = dr["telephone"].ToString(); //联系电话 return(tsDept); }
/// <summary> /// 修改部门 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tsDept">部门</param> public virtual void Edit(DataAccess data, TSDept tsDept) { string strSQL = "update TSDept set status=@status,deptName=@deptName,telephone=@telephone where deptId=@deptId"; Param param = new Param(); param.Clear(); param.Add("@status", tsDept.status); //使用状态 param.Add("@deptName", tsDept.deptName); //部门名称 param.Add("@telephone", tsDept.telephone); //联系电话 param.Add("@deptId", tsDept.deptId); //部门编号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 #region 代码生成器自动生成 /// <summary> /// 增加部门 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tsDept">部门</param> public virtual void Add(DataAccess data, TSDept tsDept) { string strSQL = "insert into TSDept (deptId,status,deptName,telephone) values (@deptId,@status,@deptName,@telephone)"; Param param = new Param(); param.Clear(); param.Add("@deptId", tsDept.deptId); //部门编号 param.Add("@status", tsDept.status); //使用状态 param.Add("@deptName", tsDept.deptName); //部门名称 param.Add("@telephone", tsDept.telephone); //联系电话 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 加载指定部门 /// <param name="deptId">部门编号</param> /// </summary> public void Load(string deptId) { try { TSDept tsDept = tsDeptDAO.Get(deptId); tsDept.status = "1".Equals(tsDept.status) ? "on" : "off"; WebJson.ToJson(context, tsDept); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 修改部门 /// <param name="tsDept">部门</param> /// </summary> public void Edit(TSDept tsDept) { try { tsDept.status = tsDept.status == null ? "0" : "1"; tsDeptDAO.Edit(tsDept); Message.success(context, "部门修改成功"); loginSession.Log(tsDept.deptName + "[" + tsDept.deptId + "]部门修改成功"); } catch (Exception e) { Message.error(context, "部门修改失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改部门 /// </summary> /// <param name="tsDept">部门</param> public virtual void Edit(TSDept tsDept) { try { db.Open(); Edit(db, tsDept); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 增加部门 /// <param name="tsDept">部门</param> /// </summary> public void Add(TSDept tsDept) { try { db.Open(); Add(db, tsDept); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 增加部门 /// <param name="tsDept">部门</param> /// </summary> public void Add(TSDept tsDept) { try { tsDept.deptId = commonDao.GetMaxNo("TSDept", "", 6); tsDept.status = tsDept.status == null ? "0" : "1"; tsDeptDAO.Add(tsDept); Message.success(context, "部门增加成功"); loginSession.Log(tsDept.deptName + "部门增加成功"); } catch (Exception e) { Message.error(context, "部门增加失败"); loginSession.Log(e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "Dept"); if (!loginUser.Pass)//权限验证 { return; } //加载DataGrid if (context.Request["action"] == "gridLoad") { DeptBLL bll = new DeptBLL(context, loginUser); int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); bll.LoadGrid(page, rows); return; } //加载信息 if (context.Request["action"] == "load") { DeptBLL bll = new DeptBLL(context, loginUser); string deptId = context.Request["deptId"];//部门编号 bll.Load(deptId); return; } //增加 if (context.Request["action"] == "add") { DeptBLL bll = new DeptBLL(context, loginUser); TSDept tsDept = new TSDept(); //tsDept.deptId= context.Request["deptId"];//部门编号 tsDept.status = context.Request["status"]; //使用状态 tsDept.deptName = context.Request["deptName"]; //部门名称 tsDept.telephone = context.Request["telephone"]; //联系电话 bll.Add(tsDept); return; } //修改 if (context.Request["action"] == "edit") { DeptBLL bll = new DeptBLL(context, loginUser); TSDept tsDept = new TSDept(); tsDept.deptId = context.Request["deptId"]; //部门编号 tsDept.status = context.Request["status"]; //使用状态 tsDept.deptName = context.Request["deptName"]; //部门名称 tsDept.telephone = context.Request["telephone"]; //联系电话 bll.Edit(tsDept); return; } //删除 if (context.Request["action"] == "delete") { DeptBLL bll = new DeptBLL(context, loginUser); string deptId = context.Request["deptId"];//部门编号 bll.Delete(deptId); return; } } catch (Exception e) { Message.error(context, e.Message); } }