Exemple #1
0
 public UsersOR selectARowDateByGuid(string m_id)
 {
     string sql = string.Format("select * from T_SYS_USERS where GUID='{0}'", m_id);
     DataTable dt = null;
     try
     {
         dt = db.ExecuteQueryDataSet(sql).Tables[0];
     }
     catch (Exception ex)
     {
         throw ex;
     }
     if (dt == null)
         return null;
     if (dt.Rows.Count == 0)
         return null;
     DataRow dr = dt.Rows[0];
     UsersOR m_User = new UsersOR(dr);
     return m_User;
 }
Exemple #2
0
 public UsersOR sp_UserLogin(string userID, string UsrPwd)
 {
     string sql = string.Format("select * from T_SYS_USERS where  LOGON_NAME='{0}' and USER_PWD='{1}'", userID, UsrPwd);
     DataTable dt = null;
     try
     {
         dt = db.ExecuteQueryDataSet(sql).Tables[0];
     }
     catch (Exception ex)
     {
         throw ex;
     }
     if (dt == null)
         return null;
     if (dt.Rows.Count == 0)
     {
         UsersOR user = this.selectARowDate(userID);
         if (user != null)
             throw new Exception("密码错误!");
         else
             throw new Exception("用户名或密码错误!");
     }
     DataRow dr = dt.Rows[0];
     UsersOR m_User = new UsersOR(dr);
     OrganizationsOR org = new OrganizationsDA().selectARowDate(m_User.ParentGuid);
     if (org != null)
     {
         m_User.DepartmentName = org.DisplayName;
     }
     return m_User;
 }
 public void updateUsers(UsersOR obj, string m_id)
 {
     updateUser(obj, m_id);
 }
 /// <summary>
 /// ����T_SYS_USERS
 /// </summary>
 public bool updateUser(UsersOR T_SY, string m_id)
 {
     string sql = string.Format(@" update T_SYS_USERS set DISPLAY_NAME='{0}',ALL_PATH_NAME='{1}',RANK_NAME='{2}',DESCRIPTION='{3}',START_TIME='{4}',END_TIME='{5}',LOGON_NAME='{6}',IC_CARD='{7}',PWD_TYPE_GUID='{8}',USER_PWD='{9}',RANK_CODE='{10}',E_MAIL='{11}',POSTURAL={12},MODIFY_TIME=getdate(),AD_COUNT={13},PERSON_ID='{14}' where GUID='{15}'"
      , T_SY.DisplayName, T_SY.AllPathName, T_SY.RankName, T_SY.Description, T_SY.StartTime.ToString(), T_SY.EndTime.ToString(), T_SY.LogonName, T_SY.IcCard, T_SY.PwdTypeGuid, T_SY.UserPwd, T_SY.RankCode, T_SY.EMail, T_SY.Postural, T_SY.AdCount, T_SY.PersonId, m_id);
     try
     {
         db.ExecuteNoQuery(sql);
     }
     catch (Exception ex)
     {
         throw ex;
     }
     return true;
 }
 public UsersOR selectSingleUserByID(string m_ID)
 {
     string sql = string.Format("select * from T_SYS_USERS where GUID='{0}'", m_ID);
     DataTable dt = null;
     try
     {
         dt = db.ExecuteQuery(sql);
     }
     catch (Exception ex)
     {
         throw ex;
     }
     if (dt == null)
         return null;
     if (dt.Rows.Count == 0)
         return null;
     DataRow dr = dt.Rows[0];
     UsersOR m_User = new UsersOR(dr);
     return m_User;
 }
        public void insertUser(UsersOR obj)
        {
            OrganizationsOR orgparent = selectSingleOrganization(obj.ParentGuid);
            DataTable dtUser = GetUsersByParentID(obj.ParentGuid);

            int counter = (dtUser == null ? 0 : dtUser.Rows.Count);

            bool sortIsExis = true;
            while (sortIsExis)
            {

                obj.InnerSort = getOrgSort(++counter);//�����ڲ������
                sortIsExis = OrgSortIsExis(obj.InnerSort, obj.ParentGuid);
            }
            obj.OriginalSort = orgparent.OriginalSort + obj.InnerSort;//��ϵͳ�е�ȫ��ַ�����������򣬽�����־���ڲ��ŵ�·����ϵ��
            insertU(obj);
        }
 /// ����T_SYS_USERS
 /// </summary>
 public bool insertU(UsersOR T_SY)
 {
     string sql = string.Format(@" insert into T_SYS_USERS (GUID,PARENT_GUID,DISPLAY_NAME,INNER_SORT,ORIGINAL_SORT,ALL_PATH_NAME,STATUS,RANK_NAME,DESCRIPTION,START_TIME,END_TIME,LOGON_NAME,IC_CARD,PWD_TYPE_GUID,USER_PWD,RANK_CODE,E_MAIL,POSTURAL,CREATE_TIME,MODIFY_TIME,AD_COUNT,PERSON_ID)
      values(newid(),'{0}','{1}','{2}','{3}','{4}',1,'{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}',getdate(),getdate(),'{16}','{17}')"
       , T_SY.ParentGuid, T_SY.DisplayName, T_SY.InnerSort, T_SY.OriginalSort, T_SY.AllPathName, T_SY.RankName, T_SY.Description, T_SY.StartTime.ToString(), T_SY.EndTime.ToString(), T_SY.LogonName, T_SY.IcCard, T_SY.PwdTypeGuid, T_SY.UserPwd, T_SY.RankCode, T_SY.EMail, T_SY.Postural, T_SY.AdCount, T_SY.PersonId);
     try
     {
         db.ExecuteNoQuery(sql);
     }
     catch (Exception ex)
     {
         throw ex;
     }
     return true;
 }
Exemple #8
0
        private UsersOR setValue()
        {
            UsersOR m_User = new UsersOR();
            if (Request.QueryString["GUID"] == null)
            {
                m_User.Guid = Guid.NewGuid().ToString();

            }
            else
            {
                string m_id = Request.QueryString["GUID"].ToString();
                m_User.Guid = m_id;
            }

            //if (Request.QueryString["opType"].ToString() == "alert")
            //    m_User.GUID = txtGuid.Text;//用户身份标志ID
            m_User.ParentGuid = Request.QueryString["parentGUID"].ToString();//所在部门的标志ID
            m_User.DisplayName = txtDisplayName.Text;//用户的显示名称
            //m_User.InnerSort = txtInnerSort.Text;//用户在部门中的排序
            //m_User.OriginalSort = txtOriginalSort.Text;//用户在系统中的全地址(不用于排序,仅仅标志所在部门的路径关系)
            m_User.AllPathName = txtAllPathName.Text;//用户在系统中的全程文字表述(例如:全国海关\海关总署\信息中心\应用开发二处\朱佳炜)
            m_User.Status = 1;// int.Parse(txtStatus.Text);//状态(1、正常使用;2、直接逻辑删除;4、机构级联逻辑删除;8、人员级联逻辑删除;)掩码方式实现
            m_User.RankName = txtRankName.Text;//用户在该部门中的职位
            m_User.Description = txtDescription.Text;//用户的附加描述信息
            m_User.StartTime = txtStartTime.Text;//关系启用时间
            m_User.EndTime = txtEndTime.Text;//关系结束时间
            m_User.LogonName = txtLogonName.Text;//用户的登录名称
            m_User.IcCard = txtIcCard.Text;//用户的IC卡号

            m_User.UserPwd = txtUserPwd.Text;//用户所使用的密码(加密存储)
            m_User.RankCode = dpdRankCode.Text;//行政级别信息数据
            m_User.EMail = txtEMail.Text;//用户默认使用的EMAIL
            //m_User.POSTURAL = int.Parse(txtPostural.Text);//用户的在系统中的状态(1、禁用状态;2、要求下次登录修改密码;4、正常使用;)掩码方式实现
            //m_User. = DateTime.Parse(txtCreateTime.Text);//创建时间
            //m_User.MODIFY_TIME = DateTime.Now;//.Parse(txtModifyTime.Text);//最近修改时间
            // m_User.AdCount = int.Parse(txtAdCount.Text);//是否在AD中建立对应的账号
            m_User.PersonId = txtPersonId.Text;//海关人员编码

            return m_User;
        }