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(); } } } }
private void HandlerDataBind() { TSysUserVo objUser = new TSysUserVo(); objUser.IS_USE = "1"; objUser.IS_DEL = "0"; objUser.IS_HIDE = "0"; DataTable dt = new DataTable(); dt = new TSysUserLogic().SelectByTable(objUser); HandlerList.DataSource = dt; HandlerList.DataTextField = "REAL_NAME"; HandlerList.DataValueField = "ID"; HandlerList.DataBind(); //有直接上级就默认选择直接上级 if (HandlerList.Items.Count > 0) { string strLocalUserID = base.LogInfo.UserInfo.ID; DataTable dtDeptAdmin = new TSysUserPostLogic().SelectDeptAdmin_byTable(strLocalUserID); if (dtDeptAdmin.Rows.Count > 0) { string strDeptAdminId = dtDeptAdmin.Rows[0]["user_id"].ToString(); for (int i = 0; i < HandlerList.Items.Count; i++) { if (HandlerList.Items[i].Value == strDeptAdminId) { HandlerList.SelectedIndex = i; } } } } }
public static string SaveData(string strID, string strUSER_NAME, string strREAL_NAME, string strORDER_ID, string strBIRTHDAY, string strSEX, string strPHONE_OFFICE, string strPHONE_MOBILE, string strPHONE_HOME, string strEMAIL, string strADDRESS, string strPOSTCODE, string strIS_USE, string strIOS_MAC, string strIF_IOS, string strANDROID_MAC, string strIF_ANDROID, string strREMARK1, string strUSER_PWD) { bool isSuccess = true; TSysUserVo objVo = new TSysUserVo(); objVo.ID = strID.Length > 0 ? strID : GetSerialNumber("user_info_id"); objVo.IS_DEL = "0"; objVo.IS_HIDE = "0"; objVo.USER_NAME = strUSER_NAME; objVo.REAL_NAME = strREAL_NAME; objVo.ORDER_ID = strORDER_ID; objVo.BIRTHDAY = strBIRTHDAY; objVo.SEX = strSEX; objVo.PHONE_OFFICE = strPHONE_OFFICE; objVo.PHONE_MOBILE = strPHONE_MOBILE; objVo.PHONE_HOME = strPHONE_HOME; objVo.EMAIL = strEMAIL; objVo.ADDRESS = strADDRESS; objVo.POSTCODE = strPOSTCODE; objVo.IS_USE = strIS_USE.Length > 0 ? strIS_USE : "1"; objVo.USER_PWD = strUSER_PWD; objVo.IOS_MAC = strIOS_MAC; objVo.IF_IOS = strIF_IOS.Length > 0 ? strIF_IOS : "0"; objVo.ANDROID_MAC = strANDROID_MAC; objVo.IF_ANDROID = strIF_ANDROID.Length > 0 ? strIF_ANDROID : "0"; i3.View.PageBase objP = new i3.View.PageBase(); if (string.IsNullOrEmpty(objVo.USER_PWD)) { objVo.USER_PWD = objP.ToMD5("1"); } else { objVo.USER_PWD = objP.ToMD5(objVo.USER_PWD); } objVo.CREATE_ID = objP.LogInfo.UserInfo.ID; objVo.CREATE_TIME = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (strID.Length > 0) { isSuccess = new TSysUserLogic().Edit(objVo); if (isSuccess) { new PageBase().WriteLog("编辑用户", "", new UserLogInfo().UserInfo.USER_NAME + "编辑用户" + objVo.ID); } } else { isSuccess = new TSysUserLogic().Create(objVo); if (isSuccess) { new PageBase().WriteLog("添加用户", "", new UserLogInfo().UserInfo.USER_NAME + "添加用户" + objVo.ID); } } TSysUserPostLogic logicUp = new TSysUserPostLogic(); if (strID.Length > 0) { TSysUserPostVo objUserPostDel = new TSysUserPostVo(); objUserPostDel.USER_ID = strID; logicUp.Delete(objUserPostDel); } string strPostId = strREMARK1.Split('|')[0]; string[] arrPostId = strPostId.Split(','); for (int i = 0; i < arrPostId.Length; i++) { TSysUserPostVo objUserPost = new TSysUserPostVo(); objUserPost.USER_ID = objVo.ID; objUserPost.POST_ID = arrPostId[i]; objUserPost.ID = GetSerialNumber("user_post_infor"); isSuccess = new TSysUserPostLogic().Create(objUserPost); if (isSuccess) { new PageBase().WriteLog("添加职位菜单", "", new UserLogInfo().UserInfo.USER_NAME + "添加职位菜单" + objUserPost.ID); } } if (isSuccess) { return("1"); } else { return("0"); } }
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); }