public Dialog_AddPost(SinoPost _post)
{
InitializeComponent();
this.textEdit1.EditValue = _post.PostName;
this.textEdit2.EditValue = _post.PostDescript;
this.textEdit3.EditValue = _post.SecretLevel;
}
/// <summary>
/// 取用户的岗位列表
/// </summary>
/// <param name="yhid"></param>
/// <returns></returns>
public static List <SinoPost> Get_PostsByYHID(string yhid)
{
List <SinoPost> _ret = new List <SinoPost>();
SqlParameter[] _param =
{
new SqlParameter(":YHID", SqlDbType.Decimal),
new SqlParameter(":SSDWID", SqlDbType.Decimal)
};
_param[0].Value = decimal.Parse(yhid);
_param[1].Value = decimal.Parse(ConfigFile.SystemID);
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text, SQL_Get_PostsByYHID, _param);
while (dr.Read())
{
SinoPost _sp = new SinoPost(dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetDecimal(1).ToString(),
dr.IsDBNull(2) ? "" : dr.GetDecimal(2).ToString(),
dr.IsDBNull(3) ? "" : dr.GetString(3),
dr.IsDBNull(4) ? "" : dr.GetString(4),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(7) ? (int)0 : Convert.ToInt32(dr.GetDecimal(7)),
dr.IsDBNull(6) ? false : (((decimal)dr.GetDouble(6) == 1) ? true : false));
_sp.Roles = Get_RolesOfGW(_sp.PostID);
_ret.Add(_sp);
}
dr.Close();
return(_ret);
}
/// <summary>
/// 获取超级管理员信息
/// </summary>
/// <returns></returns>
public static SinoUser GetAdminInfo()
{
SinoUser _su = new SinoUser();
_su.LoginName = "administrator";
_su.Dwdm = "";
_su.DwID = "";
_su.DwName = "";
_su.UserID = "0";
_su.UserName = "******";
_su.SecretLevel = 1000;
_su.QxszJB = "直属海关级";
_su.Posts = new List <SinoPost>();
SinoPost _adminPost = new SinoPost();
_adminPost.PostID = "0";
_adminPost.PostName = "超级管理员";
_adminPost.PostDwID = ConfigFile.SytemDWRootID;
_adminPost.Rights = new Dictionary <string, UserRightItem>();
StringBuilder _sb = new StringBuilder();
_sb.Append("SELECT dbo.GETDWDM_hgjs(@DWID) dwdm,dbo.GETDWMC(@DWID2) DWMC ");
//_sb.Append("FROM DUAL ");
SqlParameter[] _param =
{
new SqlParameter("@DWID", SqlDbType.Decimal),
new SqlParameter("@DWID2", SqlDbType.Decimal),
};
_param[0].Value = decimal.Parse(_adminPost.PostDwID);
_param[1].Value = decimal.Parse(_adminPost.PostDwID);
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text,
_sb.ToString(), _param);
while (dr.Read())
{
_adminPost.PostDWDM = dr.IsDBNull(0) ? "" : dr.GetString(0);
_adminPost.PostDWMC = dr.IsDBNull(1) ? "" : dr.GetString(1);
}
dr.Close();
//取权限
DataTable _dt = GetUserRightsByYHID(_su.UserID, "");
foreach (DataRow _row in _dt.Rows)
{
UserRightItem _rightItem = RightFunctions.CreateUserRightItem(_row);
_adminPost.Rights.Add(_rightItem.Right.RightID, _rightItem);
}
_adminPost.SecretLevel = 1000;
_su.Posts.Add(_adminPost);
_su.DefaultPost = _adminPost;
_su.CurrentPost = _adminPost;
return(_su);
}
public static SinoUser GetNoRegisterUserByUserID(decimal _yhid)
{
SinoUser _su = new SinoUser();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
try
{
StringBuilder _sb = new StringBuilder();
_sb.Append(" select yh.YHM,yh.YHID,yh.XM,jg.ZZJGID DWID,jg.ZZJGDM DWDM ,jg.JGQC DWMC from yw_qd_hbryxx hb ");
_sb.Append(" join QX2_HGJG jg on hb.PARENT_GUID= jg.DWGUID ");
_sb.Append(" join qx2_hgyh yh on hb.GUID=yh.YHGUID ");
_sb.Append(" where yh.YHID=:YHID and ROWNUM=1 ");
SqlCommand _cmd = new SqlCommand(_sb.ToString(), cn);
_cmd.Parameters.Add(":YHID", _yhid);
SqlDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
_su.LoginName = dr.IsDBNull(0) ? "" : dr.GetString(0);
_su.IsSignOn = true;
_su.Dwdm = dr.IsDBNull(4) ? "" : dr.GetString(4);
_su.DwID = dr.IsDBNull(3) ? "" : dr.GetDecimal(3).ToString();
_su.DwName = dr.IsDBNull(5) ? "" : dr.GetString(5);
_su.UserID = dr.IsDBNull(1) ? "" : dr.GetDecimal(1).ToString();
_su.UserName = dr.IsDBNull(2) ? "" : dr.GetString(2);
_su.SecretLevel = 0;
_su.QxszJB = ""; //级别限定已经无用，现在处理时是按照岗位所在的级别。
}
}
catch (Exception ex)
{
SystemLogWriter.WriteLog(string.Format("通用YHID取非注册用户信息失败！YHID={0} 错误信息：{1}", _yhid, ex.Message), EventLogEntryType.Error);
throw;
}
try
{
//取岗位信息
_su.Posts = new List <SinoPost>();
SinoPost _sp = new SinoPost("未注册用户岗位", "-1", _su.DwID, _su.DwName, _su.Dwdm, "未注册用户岗位", 0, true);
_su.Posts.Add(_sp);
_sp.Rights = C_GetGWInfo.GetRightsOfPost("-1", "");
_su.DefaultPost = _sp;
_su.CurrentPost = _sp;
}
catch (Exception ex)
{
SystemLogWriter.WriteLog(string.Format("通用YHID取非注册用户岗位信息失败！YHID={0} 错误信息：{1}", _yhid, ex.Message), EventLogEntryType.Error);
throw;
}
cn.Close();
}
return(_su);
}
private void barCurrentPost_EditValueChanged(object sender, EventArgs e)
{
PostListItem _pItem = this.barCurrentPost.EditValue as PostListItem;
SinoPost _selectPost = _pItem.Post;
RemotingUserCTX.SetCurUser(SessionClass.CurrentSinoUser);
SessionClass.CurrentSinoUser.CurrentPost = _selectPost;
this.barCurrentOrg.EditValue = _selectPost.PostDWMC;
InitMenu();
}
/// <summary>
/// 显示岗位下的所有角色列表
/// </summary>
private void ShowPostRoles()
{
if (this.postRoleList1.HaveDataChanged)
{
this.postRoleList1.Close();
}
SinoPost _post = this.postList1.SelectedPost;
this.postRoleList1.Post = _post;
this.postUserList1.Post = _post;
}
public static SinoUser GetNoRegisterUserByUserName(string _name)
{
SinoUser _su = new SinoUser();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
StringBuilder _sb = new StringBuilder();
_sb.Append(" select yh.YHM,yh.YHID,yh.XM,jg.ZZJGID DWID,jg.ZZJGDM DWDM ,jg.JGQC DWMC from yw_qd_hbryxx hb ");
_sb.Append(" join QX2_HGJG jg on hb.PARENT_GUID= jg.DWGUID ");
_sb.Append(" join qx2_hgyh yh on hb.GUID=yh.YHGUID ");
_sb.Append(" where hb.YHM=:LOGONNAME and ROWNUM=1 ");
SqlCommand _cmd = new SqlCommand(_sb.ToString(), cn);
_cmd.Parameters.Add(":LOGONNAME", _name);
SqlDataReader dr = _cmd.ExecuteReader();
while (dr.Read())
{
_su.LoginName = _name;
_su.IsSignOn = true;
_su.Dwdm = dr.IsDBNull(4) ? "" : dr.GetString(4);
_su.DwID = dr.IsDBNull(3) ? "" : dr.GetDecimal(3).ToString();
_su.DwName = dr.IsDBNull(5) ? "" : dr.GetString(5);
_su.UserID = dr.IsDBNull(1) ? "" : dr.GetDecimal(1).ToString();
_su.UserName = dr.IsDBNull(2) ? "" : dr.GetString(2);
_su.SecretLevel = 0;
_su.QxszJB = ""; //级别限定已经无用，现在处理时是按照岗位所在的级别。
}
//取岗位信息
_su.Posts = new List <SinoPost>();
SinoPost _sp = new SinoPost("未注册用户岗位", "0", _su.DwID, _su.DwName, _su.Dwdm, "未注册用户岗位", 0, true);
_su.Posts.Add(_sp);
_sp.Rights = C_GetGWInfo.GetRightsOfPost("-1", "");
_su.DefaultPost = _sp;
_su.CurrentPost = _sp;
cn.Close();
}
return(_su);
}
public static SinoUser GetNoRegisterUserByUserName(string _name)
{
SinoUser _su = new SinoUser();
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlCommand _cmd = new SqlCommand(SQL_GetNoRegisterUserByUserName, cn);
_cmd.Parameters.Add(":LOGONNAME", _name);
using (SqlDataReader dr = _cmd.ExecuteReader())
{
while (dr.Read())
{
_su.LoginName = _name;
_su.IsSignOn = true;
_su.Dwdm = dr.IsDBNull(4) ? "" : dr.GetString(4);
_su.DwID = dr.IsDBNull(3) ? "" : dr.GetDecimal(3).ToString();
_su.DwName = dr.IsDBNull(5) ? "" : dr.GetString(5);
_su.UserID = dr.IsDBNull(1) ? "" : dr.GetDecimal(1).ToString();
_su.UserName = dr.IsDBNull(2) ? "" : dr.GetString(2);
_su.SecretLevel = 0;
_su.QxszJB = ""; //级别限定已经无用，现在处理时是按照岗位所在的级别。
}
//取岗位信息
_su.Posts = new List <SinoPost>();
SinoPost _sp = new SinoPost("未注册用户岗位", "0", _su.DwID, _su.DwName, _su.Dwdm, "未注册用户岗位", 0, true);
_su.Posts.Add(_sp);
_sp.Rights = C_GetGWInfo.GetRightsOfPost("-1", "");
_su.DefaultPost = _sp;
_su.CurrentPost = _sp;
}
cn.Close();
}
return(_su);
}
public PostListItem(SinoPost _sp)
{
post = _sp;
}
public Dialog_ShowPostRight(SinoPost _post)
{
InitializeComponent();
CurrentPost = _post;
InitForm();
}
public UserPostInfo(SinoPost _post)
{
UserPost = _post;
}
