//分页
int PageCount = timeQueryWe.PageCount;
int PageNum = timeQueryWe.PageNum;
int SkipCount = (PageNum - 1) * PageCount;
var list = _iRepository.GetAllIncluding(m => m.archive, m => m.archive.department, m => m.leaveType).Where(t=>t.ArchiveId ==timeQueryWe.archiveId);
if (timeQueryWe.dtYM != null)
{
DateTime sdt = new DateTime(timeQueryWe.dtYM.Value.Year, timeQueryWe.dtYM.Value.Month, timeQueryWe.dtYM.Value.Day);
DateTime edt = sdt.AddMonths(1);
list = list.Where(t => t.LeaveBegin >= sdt && t.LeaveBegin < edt);
}
if (timeQueryWe.approvalStatus != null)
{
list = list.Where(m => m.ApprovalStatus == timeQueryWe.approvalStatus);
}
List<LeaveDto> types = Mapper.Map<List<LeaveDto>>(list);
//分页处理
types = types.OrderByDescending(t => t.LeaveBegin).Skip(SkipCount).Take(PageCount).ToList();
List<DataDic> dictList = _dataDicRepository.GetAll().ToList();
types = GetFullListInfoForWe<LeaveDto>(types, dictList, "Leaves");
//生成txt文件
string path = AppDomain.CurrentDomain.BaseDirectory;// + @"System\Log\";
string fileFullPath = path + "log.txt";
if (!Directory.Exists(path))
Directory.CreateDirectory(path);
String str = DateTime.Now.ToString() + ":驶出原始数据:车牌号" + vno + "areaId:" + areaId + areaName + "userflag:" + userflag;
StreamWriter sw = System.IO.File.AppendText(fileFullPath);
sw.WriteLine(str);
sw.Flush();
sw.Close();
sw.Dispose();
/时间格式转换
#region 时间戳[10|13]转为C#格式时间
/// <summary>
/// 时间戳[10|13]转为C#格式时间
/// </summary>
public static DateTime StampToDateTime(string stamp)
{
if (stamp.Length != 10 || stamp.Length != 13) return DateTime.Now;
try
{
DateTime StartDateTime = TimeZoneInfo.ConvertTime(new DateTime(1970, 1, 1), TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
if (stamp.Length == 10) StartDateTime.AddSeconds(long.Parse(stamp));
return StartDateTime.AddMilliseconds(long.Parse(stamp));
}
catch (Exception)
{
return DateTime.Now;
}
}
#endregion
#region 获取时间戳
/// <summary>
/// 获取时间戳
/// </summary>
/// <returns></returns>
public static string DateTimeToStamp(System.DateTime time, int length = 13)
{
long ts = ConvertDateTimeTolong(time);
return ts.ToString().Substring(0, length);
}
#endregion
#region DateTime时间格式转换为Unix时间戳格式
/// <summary>
/// DateTime时间格式转换为Unix时间戳格式
/// </summary>
private static long ConvertDateTimeTolong(DateTime datetime)
{
try
{
return datetime.Ticks - TimeZoneInfo.ConvertTime(new DateTime(1970, 1, 1), TimeZoneInfo.FindSystemTimeZoneById("China Standard Time")).Ticks;
}
catch (Exception)
{
return 0;
}
}
#endregion
/// <summary>
/// 时间戳转为格式
/// </summary>
/// <param name="timeStamp"></param>
/// <returns></returns>
public DateTime StampToDateTime(string timeStamp)
{
DateTime dateTimeStart = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
long lTime = long.Parse(timeStamp + "0000000");
TimeSpan toNow = new TimeSpan(lTime);
return dateTimeStart.Add(toNow);
}
/// <summary>
/// 时间戳Timestamp
/// </summary>
/// <returns></returns>
private int GetCreatetime(DateTime timeStamp)
{
DateTime dateStart = new DateTime(1970, 1, 1, 8, 0, 0);
int ts = Convert.ToInt32((timeStamp - dateStart).TotalSeconds);
return ts;
}
//键盘钩子 win键 Alt+F4 等键失效 详情看【钩子.cs】
/经纬度转换WGS-84 详情看【GPS转换经纬度】
public string GPS(string lonlat) {
//转成WGS-84
GPS t = new GPS();
t.bLng = Convert.ToDouble(lonlat.Split(',')[0].ToString());
t.bLat = Convert.ToDouble(lonlat.Split(',')[1].ToString());
t.bd_decrypt();
t.gcj_decrypt();
//截取小数点后7位
String lng = t.lng.ToString().Substring(0, t.lng.ToString().IndexOf(".") + 8);
String lat = t.lat.ToString().Substring(0, t.lat.ToString().IndexOf(".") + 8);
String WGSLonLat = lng + "," + lat;
return WGSLonLat;
}
///控制器分页
this.Jsonp(new { data = alarmSetList.Skip((page - 1) * pageSize).Take(pageSize), total = alarmSetList.Count() })