/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysPost_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysPost_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysPostVo tSysPost_UpdateSet, TSysPostVo tSysPost_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tSysPost_UpdateSet, TSysPostVo.T_SYS_POST_TABLE); strSQL += this.BuildWhereStatement(tSysPost_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysPost">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysPostVo tSysPost) { string strSQL = SqlHelper.BuildUpdateExpress(tSysPost, TSysPostVo.T_SYS_POST_TABLE); strSQL += string.Format(" where ID='{0}' ", tSysPost.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
private void GetPostStr(string strID, ref string strPostNames, ref string strPostIDs) { TSysUserPostVo objUserPost = new TSysUserPostVo(); objUserPost.USER_ID = strID; DataTable dtUserPost = new TSysUserPostLogic().SelectByTable(objUserPost); TSysPostVo objPost = new TSysPostVo(); objPost.IS_DEL = "0"; //objPost.IS_HIDE = "0"; DataTable dtPost = new TSysPostLogic().SelectByTable(objPost); for (int i = 0; i < dtUserPost.Rows.Count; i++) { for (int j = 0; j < dtPost.Rows.Count; j++) { if (dtPost.Rows[j]["ID"].ToString() == dtUserPost.Rows[i]["POST_ID"].ToString()) { strPostNames += (strPostNames.Length > 0 ? "," : "") + dtPost.Rows[j]["POST_NAME"].ToString(); strPostIDs += (strPostIDs.Length > 0 ? "," : "") + dtPost.Rows[j]["ID"].ToString(); } } } }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysPostVo tSysPost, int iIndex, int iCount) { string strSQL = " select * from T_SYS_POST {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tSysPost)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress <TSysPostVo>(tSysPost, strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysPostVo tSysPost) { string strSQL = "delete from T_SYS_POST "; strSQL += this.BuildWhereStatement(tSysPost); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 拖动树节点 /// </summary> /// <param name="strDragNodeID">被拖动的树节点id</param> /// <param name="strTargetNodeID">放置的父节点id</param> /// <returns>无返回</returns> private string DragTreeNode(string strDragNodeID, string strTargetNodeID) { TSysPostVo objPostVo = new TSysPostVo(); objPostVo.PARENT_POST_ID = strTargetNodeID; objPostVo.ID = strDragNodeID; new TSysPostLogic().Edit(objPostVo); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditUserPost, strDragNodeID, LogInfo.UserInfo.USER_NAME + "移动职位节点: " + strDragNodeID + " 及其子节点到" + strTargetNodeID + "之下成功!"); return(""); }
/// <summary> /// 绑定职位树,获取json数据 /// </summary> private void BindPostTree() { TSysPostVo objPostVo = new TSysPostVo(); objPostVo.IS_DEL = "0"; DataTable dt = new TSysPostLogic().SelectByTable(objPostVo); if (dt.Rows.Count < 1) { return; } BindTreeRoot(dt, "0", 1);// 绑定根节点,获取json数据 }
private string EditTreeNode(string strID, string strPOST_NAME, string strPOST_LEVEL_ID, string strPOST_DEPT_ID, string strROLE_NOTE) { TSysPostVo objPostVo = new TSysPostVo(); objPostVo.ID = strID; objPostVo.POST_NAME = strPOST_NAME; objPostVo.POST_LEVEL_ID = strPOST_LEVEL_ID; objPostVo.POST_DEPT_ID = strPOST_DEPT_ID; objPostVo.ROLE_NOTE = strROLE_NOTE; new TSysPostLogic().Edit(objPostVo); base.WriteLog(i3.ValueObject.ObjectBase.LogType.EditSysPost, strID, LogInfo.UserInfo.USER_NAME + "编辑职位: " + strID + " 成功!"); return(""); }
//获取职位 private void GetPost() { string strSortname = "NUM"; string strSortorder = Request.Params["sortorder"]; TSysPostVo objVo = new TSysPostVo(); objVo.IS_DEL = "0"; objVo.IS_HIDE = "0"; objVo.SORT_FIELD = strSortname; objVo.SORT_TYPE = strSortorder; DataTable dt = new TSysPostLogic().SelectByTable(objVo, 0, 0); int intTotalCount = new TSysPostLogic().GetSelectResultCount(objVo); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); Response.End(); }
private string AddTreeNode(string strParentID, string strPOST_NAME, string strPOST_LEVEL_ID, string strPOST_DEPT_ID, string strROLE_NOTE) { string strResult = ""; TSysPostVo objPostVo = new TSysPostVo(); objPostVo.ID = GetSerialNumber("t_sys_post_id"); objPostVo.PARENT_POST_ID = strParentID; objPostVo.POST_NAME = strPOST_NAME; objPostVo.POST_LEVEL_ID = strPOST_LEVEL_ID; objPostVo.POST_DEPT_ID = strPOST_DEPT_ID; objPostVo.ROLE_NOTE = strROLE_NOTE; objPostVo.IS_DEL = "0"; objPostVo.CREATE_ID = ""; objPostVo.CREATE_TIME = System.DateTime.Now.ToShortDateString(); new TSysPostLogic().Create(objPostVo); strResult = objPostVo.ID; base.WriteLog(i3.ValueObject.ObjectBase.LogType.AddSysPost, strResult, LogInfo.UserInfo.USER_NAME + "增加职位节点: " + strResult + " 到" + strParentID + "之下成功!"); return(strResult); }
//页面初始化 private void InitPage() { BindDataDictToControl("dept", this.PlanDept); TSysUserPostVo UserPostVo = new TSysUserPostVo(); UserPostVo.USER_ID = LogInfo.UserInfo.ID; TSysPostVo PostVo = new TSysPostVo(); PostVo = new TSysPostLogic().Details(((TSysUserPostVo) new TSysUserPostLogic().SelectByObject(UserPostVo, 0, 0)[0]).POST_ID); this.PlanDept.SelectedValue = PostVo.POST_DEPT_ID; this.hidUserID.Value = LogInfo.UserInfo.ID; this.PlanDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); this.PlanPerson.Value = LogInfo.UserInfo.REAL_NAME; if (!string.IsNullOrEmpty(this.hidId.Value)) { TOaPartBuyRequstVo objPartBuyRequst = new TOaPartBuyRequstLogic().Details(this.hidId.Value); this.PlanBt.Value = objPartBuyRequst.APPLY_TITLE; this.PlanDept.SelectedValue = objPartBuyRequst.APPLY_DEPT_ID; this.PlanPerson.Value = !string.IsNullOrEmpty(objPartBuyRequst.APPLY_USER_ID) ? new TSysUserLogic().Details(objPartBuyRequst.APPLY_USER_ID).REAL_NAME : ""; this.PlanDate.Value = !string.IsNullOrEmpty(objPartBuyRequst.APPLY_DATE) ? DateTime.Parse(objPartBuyRequst.APPLY_DATE).ToShortDateString() : ""; this.PlanContent.Value = objPartBuyRequst.APPLY_CONTENT; this.TestOption.Value = objPartBuyRequst.APP_DEPT_INFO; this.TestName.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_DEPT_ID) ? new TSysUserLogic().Details(objPartBuyRequst.APP_DEPT_ID).REAL_NAME : LogInfo.UserInfo.REAL_NAME; this.TestDate.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_DEPT_DATE) ? DateTime.Parse(objPartBuyRequst.APP_DEPT_DATE).ToShortDateString() : DateTime.Now.ToShortDateString(); this.OfficeOption.Value = objPartBuyRequst.APP_OFFER_INFO; this.OfficeName.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_OFFER_ID) ? new TSysUserLogic().Details(objPartBuyRequst.APP_OFFER_ID).REAL_NAME : LogInfo.UserInfo.REAL_NAME; this.OfficeDate.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_OFFER_TIME) ? DateTime.Parse(objPartBuyRequst.APP_OFFER_TIME).ToShortDateString() : DateTime.Now.ToShortDateString(); this.TechOption.Value = objPartBuyRequst.APP_MANAGER_INFO; this.TechName.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_MANAGER_ID) ? new TSysUserLogic().Details(objPartBuyRequst.APP_MANAGER_ID).REAL_NAME : LogInfo.UserInfo.REAL_NAME; this.TechDate.Value = !string.IsNullOrEmpty(objPartBuyRequst.APP_MANAGER_DATE) ? DateTime.Parse(objPartBuyRequst.APP_MANAGER_DATE).ToShortDateString() : DateTime.Now.ToShortDateString(); this.hidStatus.Value = objPartBuyRequst.STATUS; } //根据当前状态设置控件可不可用 DisableControls(); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysPostVo tSysPost) { return(access.Delete(tSysPost)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysPost_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysPost_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysPostVo tSysPost_UpdateSet, TSysPostVo tSysPost_UpdateWhere) { return(access.Edit(tSysPost_UpdateSet, tSysPost_UpdateWhere)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysPost">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysPostVo tSysPost) { return(access.Edit(tSysPost)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TSysPostVo tSysPost) { return(access.Create(tSysPost)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysPost">对象</param> /// <returns></returns> public TSysPostVo SelectByObject(TSysPostVo tSysPost) { return(access.SelectByObject(tSysPost)); }
private string GetUserId_InDept() { TSysUserVo tUserV = new TSysUserVo(); tUserV.IS_DEL = "0"; tUserV.IS_HIDE = "0"; tUserV.IS_USE = "1"; DataTable dtUser = new TSysUserLogic().SelectByTable(tUserV); TSysPostVo tPostV = new TSysPostVo(); tPostV.IS_DEL = "0"; tPostV.IS_HIDE = "0"; DataTable dtPost = new TSysPostLogic().SelectByTable(tPostV); DataTable dtUserPost = new TSysUserPostLogic().SelectByTable(new TSysUserPostVo()); string strLocalUserId = base.LogInfo.UserInfo.ID; string strReturnUserId = "'" + strLocalUserId + "'"; //用户的所有职位 DataRow[] drLocalUserPost = dtUserPost.Select("USER_ID='" + strLocalUserId + "'"); string strLocalPostIDs = ""; for (int i = 0; i < drLocalUserPost.Length; i++) { strLocalPostIDs += (strLocalPostIDs.Length > 0 ? "," : "") + "'" + drLocalUserPost[i]["POST_ID"].ToString() + "'"; } if (strLocalPostIDs.Length == 0) { return(strReturnUserId); } //用户的所有职位为部门主任或副主任的部门id DataRow[] drLocalPost = dtPost.Select("ID in (" + strLocalPostIDs + ") and POST_LEVEL_ID in ('Director','DirectorEx')"); string strLocalDeptIDs = ""; for (int i = 0; i < drLocalPost.Length; i++) { strLocalDeptIDs += (strLocalDeptIDs.Length > 0 ? "," : "") + "'" + drLocalPost[i]["POST_DEPT_ID"].ToString() + "'"; } if (strLocalDeptIDs.Length == 0) { return(strReturnUserId); } //用户的职位为部门主任或副主任,的部门的所有职位 DataRow[] drSrhPost = dtPost.Select("POST_DEPT_ID in (" + strLocalDeptIDs + ")"); string strSrhPostIDs = ""; for (int i = 0; i < drSrhPost.Length; i++) { strSrhPostIDs += (strSrhPostIDs.Length > 0 ? "," : "") + "'" + drSrhPost[i]["ID"].ToString() + "'"; } if (strSrhPostIDs.Length == 0) { return(strReturnUserId); } //用户的职位为部门主任或副主任,的部门的所有职位对应的用户 DataRow[] drSrhUserPost = dtUserPost.Select("POST_ID in (" + strSrhPostIDs + ")"); string strSrhUSerIDs = ""; for (int i = 0; i < drSrhUserPost.Length; i++) { strSrhUSerIDs += (strSrhUSerIDs.Length > 0 ? "," : "") + "'" + drSrhUserPost[i]["USER_ID"].ToString() + "'"; } if (strSrhUSerIDs.Length == 0) { return(strReturnUserId); } return(strSrhUSerIDs); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysPost">对象条件</param> /// <returns>对象</returns> public TSysPostVo Details(TSysPostVo tSysPost) { return(access.Details(tSysPost)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysPost"></param> /// <returns></returns> public DataTable SelectByTable(TSysPostVo tSysPost) { string strSQL = "select * from T_SYS_POST " + this.BuildWhereStatement(tSysPost); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysPostVo> SelectByObject(TSysPostVo tSysPost, int iIndex, int iCount) { string strSQL = String.Format("select * from T_SYS_POST " + this.BuildWhereStatement(tSysPost)); return(SqlHelper.ExecuteObjectList(tSysPost, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysPost">对象条件</param> /// <returns>对象</returns> public TSysPostVo Details(TSysPostVo tSysPost) { string strSQL = String.Format("select * from T_SYS_POST " + this.BuildWhereStatement(tSysPost)); return(SqlHelper.ExecuteObject(new TSysPostVo(), strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysPost">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysPostVo tSysPost) { string strSQL = "select Count(*) from T_SYS_POST " + this.BuildWhereStatement(tSysPost); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tSysPost"></param> /// <returns></returns> public string BuildWhereStatement(TSysPostVo tSysPost) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tSysPost) { //角色编号 if (!String.IsNullOrEmpty(tSysPost.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tSysPost.ID.ToString())); } //职位名 if (!String.IsNullOrEmpty(tSysPost.POST_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST_NAME = '{0}'", tSysPost.POST_NAME.ToString())); } //上级职位ID if (!String.IsNullOrEmpty(tSysPost.PARENT_POST_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PARENT_POST_ID = '{0}'", tSysPost.PARENT_POST_ID.ToString())); } //行政级别 if (!String.IsNullOrEmpty(tSysPost.POST_LEVEL_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST_LEVEL_ID = '{0}'", tSysPost.POST_LEVEL_ID.ToString())); } //所属部门 if (!String.IsNullOrEmpty(tSysPost.POST_DEPT_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST_DEPT_ID = '{0}'", tSysPost.POST_DEPT_ID.ToString())); } //角色说明 if (!String.IsNullOrEmpty(tSysPost.ROLE_NOTE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ROLE_NOTE = '{0}'", tSysPost.ROLE_NOTE.ToString())); } //树深度编号 if (!String.IsNullOrEmpty(tSysPost.TREE_LEVEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TREE_LEVEL = '{0}'", tSysPost.TREE_LEVEL.ToString())); } //排序 if (!String.IsNullOrEmpty(tSysPost.NUM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND NUM = '{0}'", tSysPost.NUM.ToString())); } //删除标记,1为删除 if (!String.IsNullOrEmpty(tSysPost.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tSysPost.IS_DEL.ToString())); } //创建人ID if (!String.IsNullOrEmpty(tSysPost.CREATE_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CREATE_ID = '{0}'", tSysPost.CREATE_ID.ToString())); } //创建时间 if (!String.IsNullOrEmpty(tSysPost.CREATE_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CREATE_TIME = '{0}'", tSysPost.CREATE_TIME.ToString())); } //隐藏标记,对用户屏蔽 if (!String.IsNullOrEmpty(tSysPost.IS_HIDE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_HIDE = '{0}'", tSysPost.IS_HIDE.ToString())); } //备注 if (!String.IsNullOrEmpty(tSysPost.REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tSysPost.REMARK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tSysPost.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tSysPost.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tSysPost.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tSysPost.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tSysPost.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tSysPost.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tSysPost.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tSysPost.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tSysPost.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tSysPost.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
public TSysPostLogic(TSysPostVo _tSysPost) { tSysPost = _tSysPost; access = new TSysPostAccess(); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysPost">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysPostVo tSysPost) { return(access.GetSelectResultCount(tSysPost)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysPostVo tSysPost, int iIndex, int iCount) { return(access.SelectByTable(tSysPost, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysPost">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysPostVo> SelectByObject(TSysPostVo tSysPost, int iIndex, int iCount) { return(access.SelectByObject(tSysPost, iIndex, iCount)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tSysPost">对象</param> /// <returns>是否成功</returns> public bool Create(TSysPostVo tSysPost) { string strSQL = SqlHelper.BuildInsertExpress(tSysPost, TSysPostVo.T_SYS_POST_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysPost"></param> /// <returns></returns> public DataTable SelectByTable(TSysPostVo tSysPost) { return(access.SelectByTable(tSysPost)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysPost">对象</param> /// <returns></returns> public TSysPostVo SelectByObject(TSysPostVo tSysPost) { string strSQL = "select * from T_SYS_POST " + this.BuildWhereStatement(tSysPost); return(SqlHelper.ExecuteObject(new TSysPostVo(), strSQL)); }