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