private static long MaxOfAllKey(string cachedKeys, params string[] otherKey) { var keys = new List <string> { cachedKeys }; keys.AddRange(otherKey); var max = keys.Max <object>(x => ZConvert.To <long>(x)); return(max); }
public dynamic GetSystemLog(RequestWrapper request) { var page = ZConvert.To <int>(request["page"], 1); var rows = ZConvert.To <int>(request["rows"], 0); var logDate = ZConvert.ToString(request["logdate"]); var list = new List <dynamic>(); var basepath = HttpContext.Current.Server.MapPath("/logs/"); var di = new DirectoryInfo(basepath); if (!di.Exists) { di.Create(); } string[] s = logDate.Split('到'); string s1 = "1990-01-01"; string s2 = DateTime.Now.Date.ToString(); switch (s.Length) { case 1: if (logDate.Length > 0) { s1 = s[0]; s2 = s1; } break; case 2: s1 = s[0]; s2 = s[1]; break; } int t1 = Convert.ToInt32(Convert.ToDateTime(s1).ToString("yyyyMMdd")); int t2 = Convert.ToInt32(Convert.ToDateTime(s2).ToString("yyyyMMdd")); foreach (var fi in di.GetFiles().Where(x => (Convert.ToInt32(x.FullName.Replace(basepath, "").Substring(3, 8)) >= t1 && Convert.ToInt32(x.FullName.Replace(basepath, "").Substring(3, 8)) <= t2))) { dynamic item = new ExpandoObject(); item.filename = fi.FullName.Replace(basepath, ""); item.size = (fi.Length / 1024).ToString() + " KB"; item.time = fi.CreationTime.ToString(); item.id = item.filename.Replace(".txt", ""); list.Add(item); } var result = list.OrderByDescending(x => x.filename).Skip((page - 1) * rows).Take(rows); return(new { rows = result, total = list.Count() }); }
public string GetNewMaterialCode(string ParentCode) { int index = 0; var MaxCode = db.Sql(@"select max(MaterialCode) from mms_material where MaterialType=@0", ParentCode).QuerySingle <string>() ?? string.Empty; if (MaxCode.Length < ParentCode.Length) { index = ZConvert.To <int>(MaxCode, 0); } else { index = ZConvert.To <int>(MaxCode.Substring(ParentCode.Length), 0); } return(ParentCode + (index + 1).ToString().PadLeft(2, '0')); }
public virtual void FillData(int x, int y, string field, object value) { var row = sheet.GetRow(y) ?? sheet.CreateRow(y); var cell = row.GetCell(x) ?? row.CreateCell(x); //if (!field.StartsWith("title_")) cell.CellStyle = GetDataStyle(); switch ((value ?? string.Empty).GetType().Name.ToLower()) { case "int32": case "int64": case "decimal": cell.CellStyle.Alignment = HorizontalAlignment.Right; cell.SetCellValue(ZConvert.To <double>(value, 0)); break; default: cell.SetCellValue(ZConvert.ToString(value)); break; } }
public static Stream ListToExcel(object list, Dictionary <string, string> titles, bool IsExportAllCol) { const int startIndex = 0; var fields = titles.Keys.ToList(); var workbook = new HSSFWorkbook(); var sheet = workbook.CreateSheet("sheet1"); sheet.DefaultRowHeight = 200 * 20; var row = sheet.CreateRow(startIndex); var headStyle = GetHeadStyle(workbook); EachHelper.EachListHeader(list, (i, name, type) => { if (!fields.Contains(name)) { if (IsExportAllCol) { fields.Add(name); } else { return; } } var cellIndex = fields.IndexOf(name) + startIndex; var cell = row.CreateCell(cellIndex); cell.SetCellValue(titles.ContainsKey(name)?titles[name]:name); cell.CellStyle = headStyle; sheet.AutoSizeColumn(cellIndex); }); EachHelper.EachListRow(list, (rowIndex, dataRow) => { row = sheet.CreateRow(rowIndex + 1); EachHelper.EachObjectProperty(dataRow, (i, name, value) => { if (!fields.Contains(name)) { if (IsExportAllCol) { fields.Add(name); } else { return; } } var cellIndex = fields.IndexOf(name) + startIndex; var dataStyle = GetDataStyle(workbook); var cell = row.CreateCell(cellIndex); cell.CellStyle = dataStyle; switch ((value ?? string.Empty).GetType().Name.ToLower()) { case "int32": case "int64": case "decimal": dataStyle.Alignment = HorizontalAlignment.RIGHT; cell.SetCellValue(ZConvert.To <double>(value, 0)); break; default: cell.CellStyle.Alignment = HorizontalAlignment.LEFT; cell.SetCellValue(ZConvert.ToString(value)); break; } }); }); var ms = new MemoryStream(); workbook.Write(ms); ms.Flush(); ms.Position = 0; workbook = null; sheet = null; row = null; return(ms); }