/// <summary> /// 获取单个用户信息 /// </summary> /// <param name="teachId"></param> /// <returns></returns> public UserInfo GetNetUserInfo(string userid) { UserInfo info = null; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_UserId, OleDbType.VarChar) }; parms[0].Value = userid; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_UserInfoPrimaryKey, parms)) { while (sdr.Read()) { info = new UserInfo( int.Parse(sdr["userId"].ToString()), sdr["groupId"].ToString(), sdr["userName"].ToString(), sdr["realName"].ToString(), sdr["netPass"].ToString(), DateTime.Parse(sdr["userModTime"].ToString()), sdr["IsManager"].ToString(), int.Parse(sdr["userOrder"].ToString()) ); } } } catch (Exception ex) { throw ex; } return(info); }
/// <summary> /// 获取用户的单个日志信息 /// </summary> /// <param name="teachId"></param> /// <returns></returns> public UserJournal GetNetUserInfoByIds(string userId, string writetime) { UserJournal info = null; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_UserId, OleDbType.Integer), new OleDbParameter(Parm_WriteTime, OleDbType.VarChar, 50) }; parms[0].Value = userId; parms[1].Value = writetime; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_UserJournalPrimaryKey, parms)) { while (sdr.Read()) { info = new UserJournal( int.Parse(sdr["jourid"].ToString()), int.Parse(sdr["userid"].ToString()), sdr["username"].ToString(), sdr["jourDesc"].ToString(), DateTime.Parse(sdr["writetime"].ToString()), DateTime.Parse(sdr["modifytime"].ToString()), sdr["evalContent"].ToString() ); } } } catch (Exception ex) { throw ex; } return(info); }
/// <summary> /// 获取假日数量,判断假日是否存在 /// </summary> /// <param name="pRestDate">假日</param> /// <param name="pUserId">用户id</param> /// <returns></returns> public int GetRestDateCountByUserId(string pRestDate, int pUserId) { int resultNum = 0; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(parm_RestDate, OleDbType.VarChar, 50), new OleDbParameter(Parm_UserId, OleDbType.Integer), }; parms[0].Value = this.GetFullDate(pRestDate); parms[1].Value = pUserId; string sql = SQL_Select_RestDateCountByRestDateAndUserId; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, sql, parms)) { while (sdr.Read()) { resultNum = int.Parse(sdr["resultCount"].ToString()); //表示普通 } } } catch (Exception ex) { resultNum = 0; } return(resultNum); }
/// <summary> /// 获取任务信息 /// </summary> /// <param name="userid">用户编号</param> /// <param name="status">执行状态 0,待执行 1,执行中 2,执行结束</param> /// <param name="beginTime">查询开始日期</param> /// <param name="endTime">查询结束日期</param> /// <returns>返回总记录数</returns> public int GetMissionFYCount(string userid, string status, string beginTime, string endTime, string IsAsgin, bool IsSearch, string KeyWord, string typeMission) { int resultNum = 0; string tempSqlStr = ""; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_WriteDate, OleDbType.VarChar, 200), new OleDbParameter(Parm_EndDate, OleDbType.VarChar, 200) }; parms[0].Value = beginTime; parms[1].Value = endTime; if (IsAsgin == "1") //已经分配 { if (userid != "-1") { tempSqlStr += " and userid=" + userid + ""; } else { tempSqlStr += " and userid<>0"; } } else { tempSqlStr += " and userid=0"; } if (status != "-1") { tempSqlStr += " and ExecStatus='" + status + "'"; } if (IsSearch) { tempSqlStr += " and MissionDesc like '%" + KeyWord + "%'"; } if (typeMission != "-1") { tempSqlStr += " and MissionType='" + typeMission + "'"; } string sql = string.Format(SQL_Select_MissionCount, tempSqlStr); using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, sql, parms)) { while (sdr.Read()) { resultNum = int.Parse(sdr["resultCount"].ToString()); //表示普通 } } } catch (Exception ex) { resultNum = 0; } return(resultNum); }
/// <summary> /// 核对用户名和密码 0用户名或者密码错误 1 表示是管理员 2表示是普通人员 /// </summary> /// <param name="useName"></param> /// <param name="Pass"></param> /// <returns></returns> public static UserInfo CheckUserAndPass(string useName, string Pass) { UserInfo info = null; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_UserName, OleDbType.VarChar, 50), new OleDbParameter(Parm_NetPass, OleDbType.VarChar, 200) }; parms[0].Value = useName; parms[1].Value = Pass; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_CheckUser, parms)) { //while (sdr.Read()) //{ // if (sdr["IsManager"].ToString() == "0") //表示普通 // { // _resultStr = "1";//普通人员 // } // else // { // _resultStr = "2";//管理员 // } //} while (sdr.Read()) { info = new UserInfo( int.Parse(sdr["userId"].ToString()), sdr["groupId"].ToString(), sdr["userName"].ToString(), sdr["realName"].ToString(), sdr["netPass"].ToString(), DateTime.Parse(sdr["userModTime"].ToString()), sdr["IsManager"].ToString(), int.Parse(sdr["userOrder"].ToString()) ); } } } catch (Exception ex) { } return(info); }
/// <summary> /// 获取用户的单个日志信息 /// </summary> /// <param name="teachId"></param> /// <returns></returns> public UserMission GetNetMissionInfo(string mid) { UserMission info = null; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_MissionId, OleDbType.VarChar, 50) }; parms[0].Value = mid; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_MissionDetail, parms)) { while (sdr.Read()) { info = new UserMission(); info.MissionID = int.Parse(sdr["MissionId"].ToString()); info.UserID = int.Parse(sdr["userid"].ToString()); info.MissionDesc = commonFun.replaceStr(sdr["MissionDesc"].ToString()); info.MissionType = sdr["MissionType"].ToString(); info.FilePath = sdr["FilePath"].ToString(); if (sdr["WorkHour"] == null || sdr["WorkHour"].ToString() == string.Empty) { info.WorkHour = 0; } else { info.WorkHour = int.Parse(sdr["WorkHour"].ToString()); } string _realProcess = sdr["RealProcess"].ToString(); if (_realProcess != string.Empty) { _realProcess = _realProcess.Replace("%", ""); } info.RealProcess = _realProcess; } } } catch (Exception ex) { throw ex; } return(info); }
/// <summary> /// 获取用户的集合信息 /// </summary> /// <param name="keyword">关键字</param> /// <param name="inUse"></param> /// <returns></returns> public int GetUserFYCount(string keyword, string groupID) { int resultNum = 0; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_GroupId, OleDbType.VarChar, 200) }; parms[0].Value = groupID; using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_UserCount, parms)) { while (sdr.Read()) { resultNum = int.Parse(sdr["resultCount"].ToString()); //表示普通 } } } catch (Exception ex) { } return(resultNum); }
/// <summary> /// 获取分组信息 /// </summary> /// <returns></returns> public GroupInfo GetGroupInfo() { GroupInfo info = null; try { using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_GroupInfo, null)) { while (sdr.Read()) { info = new GroupInfo( int.Parse(sdr["GroupId"].ToString()), sdr["GroupName"].ToString() ); } } } catch (Exception ex) { throw ex; } return(info); }
/// <summary> /// 获取用户的集合信息 /// </summary> /// <param name="keyword">关键字</param> /// <param name="inUse"></param> /// <returns></returns> public int GetJournalFYCount(string keyword, string beginTime, string endTime) { if (keyword == "-1") { keyword = string.Empty; } int resultNum = 0; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_WriteTime, OleDbType.VarChar, 200), new OleDbParameter(Parm_EndTime, OleDbType.VarChar, 200) }; parms[0].Value = beginTime; parms[1].Value = endTime; if (!string.IsNullOrEmpty(keyword)) { keyword = "and userid=" + keyword + ""; } string sql = string.Format(SQL_Select_JournalCount, keyword); using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, sql, parms)) { while (sdr.Read()) { resultNum = int.Parse(sdr["resultCount"].ToString()); //表示普通 } } } catch (Exception ex) { } return(resultNum); }
/// <summary> /// 获取分页的总个数 /// </summary> /// <param name="DocType">文档类别</param> /// <param name="BeginTime">开始时间</param> /// <param name="EndTime">结束时间</param> /// <param name="KeyWord">标题关键字</param> /// <returns></returns> public int GetFileFYCount(string DocType, string BeginTime, string EndTime, string KeyWord) { int resultNum = 0; string tempSqlStr = ""; try { OleDbParameter[] parms = new OleDbParameter[] { new OleDbParameter(Parm_WriteDate, OleDbType.VarChar, 200), new OleDbParameter(Parm_EndTime, OleDbType.VarChar, 200) }; parms[0].Value = BeginTime; parms[1].Value = EndTime; tempSqlStr += " and FileTitle like '%" + KeyWord + "%'"; if (DocType != "全部") { tempSqlStr += " and FileType='" + DocType + "'"; } string sql = string.Format(SQL_Select_FileCount, tempSqlStr); using (OleDbDataReader sdr = AccessHelper.ExecuteReader(AccessHelper.CONN_STRING, CommandType.Text, sql, parms)) { while (sdr.Read()) { resultNum = int.Parse(sdr["resultCount"].ToString()); //表示普通 } } } catch (Exception ex) { } return(resultNum); }