public ActionResult Index(int?page)
{
DateTime dt = DateTime.Now;
DateTime endTime = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d")));
NameValueCollection q = new NameValueCollection();
q.Add("CreatedAtStart", endTime.AddDays(-1).ToString("yyyy/MM/dd 10:00"));
q.Add("CreatedAtEnd", DateTime.Now.AddHours(1).ToString("yyyy/MM/dd HH:00"));
InspectOriginQueryModel query = new InspectOriginQueryModel(q);
IPagedList <InspectOrigin> inspects = null;
using (var txn = new System.Transactions.TransactionScope(TransactionScopeOption.Required,
new TransactionOptions
{
IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted
}))
{
using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString))
{
int currentPageIndex = page.HasValue ? (page.Value <= 0 ? 0 : page.Value - 1) : 0;
IInspectOriginRep inspectOriginRep = new InspectOriginRep(unitOfWork);
inspects = inspectOriginRep.Queryable(query.CreatedAtStart, query.CreatedAtEnd).ToPagedList(currentPageIndex, int.Parse(Resources.PageSize));
}
}
ViewBag.Query = query;
return(View(inspects));
}
private IQueryable <InspectOrigin> GenerateQuery(IUnitOfWork unitOfWork, InspectOriginQueryModel query)
{
IInspectOriginRep inspectRep = new InspectOriginRep(unitOfWork);
return(inspectRep.Queryable().Where(item =>
//(string.IsNullOrEmpty(query.Text) ? true : item.Text.Contains(query.Text))&&
(query.ProcessResult.HasValue ? item.ProcessResult.Equals(query.ProcessResult) : true) &&
(query.CreatedAtStart.HasValue ? item.CreatedAt >= query.CreatedAtStart : true) &&
(query.CreatedAtEnd.HasValue ? item.CreatedAt <= query.CreatedAtEnd : true)
));
}
private List <InspectOrigin> ExportInspectOrigin(InspectOriginQueryModel query)
{
List <InspectOrigin> inspects = new List <InspectOrigin>();
using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString))
{
IInspectOriginRep inspectRep = new InspectOriginRep(unitOfWork);
inspects = GenerateQuery(unitOfWork, query).ToList <InspectOrigin>();
}
return(inspects);
}
private IPagedList <InspectOrigin> QueryInspectOrigin(InspectOriginQueryModel query, int?currentPageIndex, int?pageSize)
{
IPagedList <InspectOrigin> inspects;
using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString))
{
IInspectOriginRep inspectRep = new InspectOriginRep(unitOfWork);
inspects = GenerateQuery(unitOfWork, query).ToPagedList(currentPageIndex.Value, pageSize.Value);
}
return(inspects);
}
//
// GET: /Inspect/Details/5
public ActionResult Details(string id)
{
InspectOrigin inspect;
using (IUnitOfWork unitOfWork = new TskDataDataContext(DbUtil.ConnectionString))
{
IInspectOriginRep inspectRep = new InspectOriginRep(unitOfWork);
inspect = inspectRep.FindById(id);
}
return(View(inspect));
}
public ProcessMessage CreateInspect(string text)
{
ProcessMessage message = new ProcessMessage();
try
{
using (IUnitOfWork unitOfWork = new TskDataDataContext(MSSqlConfig.ConnectionString))
{
IInspectOriginRep inspectOriginRep = new InspectOriginRep(unitOfWork);
InspectOrigin inspectOrigin = new InspectOrigin()
{
Id = Guid.NewGuid(),
Text = text,
CreatedAt = DateTime.Now
};
if (text == null || text.Length == 0 || text.Split(TskConfig.DataSpliter).Length != TskConfig.DataCount)
{
message.Result = false;
message.Messages.Add("数据为空或数据格式不存在");
if (!string.IsNullOrEmpty(text))
{
message.Messages.Add("数据属性长度为：" + text.Split(TskConfig.DataSpliter).Length.ToString());
message.Messages.Add("分隔符为：" + TskConfig.DataSpliter.ToString());
}
LogUtil.Logger.Error(message.GetMessageContent());
}
else
{
IInspectRep inspectRep = new InspectRep(unitOfWork);
string[] data = text.Split(TskConfig.DataSpliter);
Inspect inspect = new Inspect()
{
Id = Guid.NewGuid(),
TskNo = data[0],
LeoniNo = data[1],
CusNo = data[2],
ClipScanNo = data[3],
// ClipScanTime1 = data[4],
// ClipScanTime2 = data[6],
TskScanNo = data[7],
// TskScanTime3 = data[8],
// Time3MinTime2 = data[9],
OkOrNot = data[10],
CreatedAt = DateTime.Now,
OriginId = inspectOrigin.Id
};
DateTime clipScanTime1 = DateTime.Now;
if (DateTime.TryParse(data[4], out clipScanTime1))
{
inspect.ClipScanTime1 = clipScanTime1;
}
DateTime clipScanTime2 = DateTime.Now;
if (DateTime.TryParse(data[6], out clipScanTime2))
{
inspect.ClipScanTime2 = clipScanTime2;
}
DateTime tskScanTime3 = DateTime.Now;
if (DateTime.TryParse(data[8], out tskScanTime3))
{
inspect.TskScanTime3 = tskScanTime3;
}
float time3MinTime2 = 0;
if (float.TryParse(data[9], out time3MinTime2))
{
inspect.Time3MinTime2 = time3MinTime2;
}
inspectRep.Create(inspect);
message.Messages.Add("数据处理成功");
message.Result = true;
}
inspectOrigin.ProcessResult = message.Result;
inspectOrigin.ProcessMessage = message.GetMessageContent();
inspectOriginRep.Create(inspectOrigin);
unitOfWork.Submit();
}
return(message);
}
catch (Exception e)
{
LogUtil.Logger.Error(e.Message);
throw e;
}
}