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);
}
