public Models.ReportOrderHistoryResultDo GetReportOrderHistory(Models.ReportOrderCriteriaDo criteria) { Models.ReportOrderHistoryResultDo result = new Models.ReportOrderHistoryResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_ReportOrderHistory]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "FrontEndID", criteria.FrontEndID); command.AddParameter(typeof(int), "BranchID", criteria.BranchID); command.AddParameter(typeof(int), "OrderID", criteria.OrderID); result.Rows = command.ToList <Models.ReportOrderHistoryDo>(); result.TotalRecords = result.Rows.Count; })); return(result); }
public Models.ReportOrderDo GetReportOrder(Models.ReportOrderCriteriaDo criteria) { Models.ReportOrderDo result = null; db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[dbo].[sp_Get_ReportOrder]"; command.AddParameter(typeof(string), "FrontEndID", criteria.FrontEndID); command.AddParameter(typeof(int), "BranchID", criteria.BranchID); command.AddParameter(typeof(int), "OrderID", criteria.OrderID); System.Collections.IList[] dbls = command.ToList( typeof(Models.ReportOrderDo), typeof(Models.OrderTableDo)); if (dbls != null) { List <Models.ReportOrderDo> dbos = dbls[0] as List <Models.ReportOrderDo>; List <Models.OrderTableDo> dbots = dbls[1] as List <Models.OrderTableDo>; if (dbos != null) { if (dbos.Count > 0) { if (dbots != null) { dbos[0].Tables = dbots; } result = dbos[0]; } } } })); return(result); }
public Models.ReportOrderItemResultDo GetReportOrderItem(Models.ReportOrderCriteriaDo criteria) { Models.ReportOrderItemResultDo result = new Models.ReportOrderItemResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_ReportOrderItem]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "FrontEndID", criteria.FrontEndID); command.AddParameter(typeof(int), "BranchID", criteria.BranchID); command.AddParameter(typeof(int), "OrderID", criteria.OrderID); result.Rows = new List <Models.ReportOrderItemGroupDo>(); List <Models.ReportOrderItemDo> items = command.ToList <Models.ReportOrderItemDo>(); if (items != null) { foreach (Models.ReportOrderItemDo item in items) { if (item.ItemType == "ITEM" || item.ItemType == "SPCL") { Models.ReportOrderItemGroupDo gitem = result.Rows.Find(x => x.ItemID == item.ItemID); if (gitem == null) { gitem = new Models.ReportOrderItemGroupDo() { ItemID = item.ItemID }; result.Rows.Add(gitem); } gitem.Item = item; } else { Models.ReportOrderItemGroupDo gitem = result.Rows.Find(x => x.ItemID == item.ParentID); if (gitem != null) { if (item.ItemType == "COMT") { if (gitem.Comments == null) { gitem.Comments = new List <Models.ReportOrderItemDo>(); } gitem.Comments.Add(item); } else if (item.ItemType == "DISC") { gitem.DiscountItem = item; } else if (item.ItemType == "VOID") { gitem.VoidItem = item; } } } } } result.TotalRecords = result.Rows.Count; })); return(result); }