private List <RestDate> GetRestDateListByUserId(string pBeginDate, int pUserId)
{
NetRestDate _net = new NetRestDate();
DataSet _ds = _net.GetRestDateDataSet(pBeginDate, string.Empty, string.Empty, pUserId);
if (_ds.Tables == null || _ds.Tables.Count == 0)
{
return(null);
}
int _count = _ds.Tables[0].Rows.Count;
List <RestDate> _restDateList = new List <RestDate>();
for (int i = 0; i < _count; i++)
{
RestDate _rest = new RestDate();
_rest.Rest_Date = Convert.ToDateTime(_ds.Tables[0].Rows[i]["RestDate"]);
_rest.RestDetail = _ds.Tables[0].Rows[i]["RestDetail"].ToString();
_restDateList.Add(_rest);
}
return(_restDateList);
}
/// <summary>
/// 根据开始和结束日期,用户Id，计算未写日志的日期列表
/// </summary>
/// <param name="pBeginTime"></param>
/// <param name="pEndTime"></param>
/// <param name="pUserId"></param>
/// <returns></returns>
public List <DateTime> GetNoWriteDateList(string pBeginTime, string pEndTime, int pUserId)
{
NetRestDate _netRestDate = new NetRestDate();
DataSet _restDateList = _netRestDate.GetRestDateDataSet(pBeginTime, pEndTime, pUserId, true);
NetUserJournal _netJournal = new NetUserJournal();
DataSet _journalDateList = _netJournal.GetNoWriteJournal(pBeginTime, pEndTime, pUserId);
//DataTable _tableRestDate = null;
//DataTable _tableJournal = null;
//if (_restDateList!=null && _restDateList.Tables[0]!=null )
//{
// _tableRestDate = _restDateList.Tables[0];
//}
//if (_journalDateList!=null && _journalDateList.Tables[0]!=null)
//{
// _tableJournal = _journalDateList.Tables[0];
//}
DateTime _begin = Convert.ToDateTime(pBeginTime).Date;
DateTime _end = Convert.ToDateTime(pEndTime).Date.AddDays(1);
List <DateTime> _noWriteDateList = new List <DateTime>();
while (_begin < _end)
{
if (this.IsInJournalDateList(_begin, _journalDateList) || this.IsRestDateList(_begin, _restDateList))
{
_begin = _begin.AddDays(1);
continue;
}
else
{
_noWriteDateList.Add(_begin);
_begin = _begin.AddDays(1);
}
}
return(_noWriteDateList);
}
/// <summary>
/// 根据开始日期和结束日期，用户Id，查询期间的所有日志日期，里面只有一个属性是writetime
/// </summary>
/// <param name="pBeginTime"></param>
/// <param name="pEndTime"></param>
/// <param name="pUserid"></param>
/// <returns></returns>
public DataSet GetNoWriteJournal(string pBeginTime, string pEndTime, int pUserid)
{
DataSet _ds = new DataSet("Result");
string _sqlstr = string.Empty;
OleDbParameter[] _param = new OleDbParameter[] {
new OleDbParameter(Parm_BeginTime, OleDbType.VarChar, 50),
new OleDbParameter(Parm_EndTime, OleDbType.VarChar, 50),
new OleDbParameter(Parm_UserId, OleDbType.Integer)
};
_param[0].Value = NetRestDate.GetFullDateString(pBeginTime);
_param[1].Value = NetRestDate.GetFullDateString(pEndTime);
_param[2].Value = pUserid;
try
{
_sqlstr = SQL_Select_SingleJournalByUserId;
_ds = AccessHelper.ExcuteDataSet(AccessHelper.CONN_STRING, CommandType.Text, _sqlstr, _param);
}
catch (Exception ex)
{
}
return(_ds);
}
public List <string> GetNoWriteList(ref string beginTime)
{
DateTime _begin = Convert.ToDateTime(beginTime);
int i = 30;
NetRestDate _netRestDate = new NetRestDate();
while (i > 0)
{
i--;
int _dateCount = _netRestDate.GetRestDateCount(_begin.ToShortDateString());
if (_dateCount > 0)
{
_begin = _begin.AddDays(-1);
}
else
{
break;
}
}
beginTime = _begin.ToString("yyyy-MM-dd");
DataSet objDs = new DataSet("reslut");
List <string> _nameList = new List <string>();
try
{
OleDbParameter[] parms = new OleDbParameter[] {
new OleDbParameter(Parm_WriteTime, OleDbType.VarChar)
};
parms[0].Value = _begin.ToString("yyyy-MM-dd");
objDs = AccessHelper.ExcuteDataSet(AccessHelper.CONN_STRING, CommandType.Text, SQL_Select_JournalIsWC, parms);
}
catch (Exception ex)
{
}
if (objDs == null || objDs.Tables.Count == 0)
{
return(null);
}
int _count = objDs.Tables[0].Rows.Count;
if (_count > 0)
{
//NetRestDate _netRestDate = new NetRestDate();
DataSet _nameDS = _netRestDate.GetUserIdDataSetByRestDate(_begin.ToString("yyyy-MM-dd"));
for (int j = 0; j < _count; j++)
{
string _userId = objDs.Tables[0].Rows[j]["userid"].ToString();
if (!this.IsNameInRestNameList(_userId, _nameDS))
{
_nameList.Add(objDs.Tables[0].Rows[j]["realName"].ToString());
}
}
}
return(_nameList);
}
/// <summary>
/// 将一个日期字符串，如果月份或日期小于10 ，将前面补一个0
/// </summary>
/// <param name="pDate"></param>
/// <returns></returns>
public static string GetFullDateString(string pDate)
{
NetRestDate _net = new NetRestDate();
return(_net.GetFullDate(pDate));
}
