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