public ActionResult _AjaxRecDetList(GridCommand command, ReceiptMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return(PartialView(new GridModel(new List <ReceiptDetail>()))); } #region old // o.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and o.ReceiptNo=d.ReceiptNo // string whereStatement = " and exists (select 1 from ReceiptMaster as r where r.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and r.RecNo=d.RecNo) "; //string whereStatement = " where i.Type = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + ""; // ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); // return PartialView(GetAjaxPageDataProcedure<ReceiptDetail>(procedureSearchStatementModel, command)); #endregion string whereStatement = " and exists (select 1 from ReceiptMaster as r where r.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and r.RecNo=d.RecNo) "; if (!string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement += " and d.OrderNo='" + searchModel.OrderNo + "' "; } IList <ReceiptDetail> receiptDetailList = new List <ReceiptDetail>(); ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); procedureSearchStatementModel.SelectProcedure = "USP_Search_PrintRecDet"; GridModel <object[]> gridModel = GetAjaxPageDataProcedure <object[]>(procedureSearchStatementModel, command); if (gridModel.Data != null && gridModel.Data.Count() > 0) { #region receiptDetailList = (from tak in gridModel.Data select new ReceiptDetail { Id = (int)tak[0], ReceiptNo = (string)tak[1], OrderNo = (string)tak[2], IpNo = (string)tak[3], Flow = (string)tak[4], ExternalOrderNo = (string)tak[5], ExternalSequence = (string)tak[6], Item = (string)tak[7], ReferenceItemCode = (string)tak[8], ItemDescription = (string)tak[9], Uom = (string)tak[10], LocationFrom = (string)tak[11], LocationTo = (string)tak[12], ReceivedQty = (decimal)tak[13], MastPartyFrom = (string)tak[14], MastPartyTo = (string)tak[15], MastType = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderType, int.Parse((tak[16]).ToString())), MastStatus = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderStatus, int.Parse((tak[17]).ToString())), MastCreateDate = (DateTime)tak[18], SAPLocation = (string)tak[19], }).ToList(); #endregion } procedureSearchStatementModel.PageParameters[2].Parameter = gridModel.Total; TempData["ReceiptDetailPrintSearchModel"] = procedureSearchStatementModel; GridModel <ReceiptDetail> gridModelOrderDet = new GridModel <ReceiptDetail>(); gridModelOrderDet.Total = gridModel.Total; gridModelOrderDet.Data = receiptDetailList; return(PartialView(gridModelOrderDet)); }
public ActionResult _AjaxList(GridCommand command, ReceiptMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return(PartialView(new GridModel(new List <ReceiptMaster>()))); } string whereStatement = string.Empty; if (!string.IsNullOrWhiteSpace(searchModel.Item) && !string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement += " and exists(select 1 from RecDetail as d where d.RecNo = r.RecNo and d.Item = '" + searchModel.Item + "' and d.OrderNo='" + searchModel.OrderNo + "')"; } else if (!string.IsNullOrWhiteSpace(searchModel.Item) && string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement += " and exists(select 1 from RecDetail as d where d.RecNo = r.RecNo and d.Item = '" + searchModel.Item + "')"; } else if (string.IsNullOrWhiteSpace(searchModel.Item) && !string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement += " and exists(select 1 from RecDetail as d where d.RecNo = r.RecNo and d.OrderNo='" + searchModel.OrderNo + "')"; } whereStatement += " and r.OrderSubType=" + (int)com.Sconit.CodeMaster.OrderSubType.Normal; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); return(PartialView(GetAjaxPageDataProcedure <ReceiptMaster>(procedureSearchStatementModel, command))); }
public ActionResult _AjaxRecDetList(GridCommand command, ReceiptMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return(PartialView(new GridModel(new List <ReceiptDetail>()))); } string whereStatement = " and exists (select 1 from ReceiptMaster as r where r.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Return + " and r.RecNo=d.RecNo) "; ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); return(PartialView(GetAjaxPageDataProcedure <ReceiptDetail>(procedureSearchStatementModel, command))); }
public ActionResult _AjaxList(GridCommand command, ReceiptMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return(PartialView(new GridModel(new List <ReceiptMaster>()))); } string whereStatement = " and r.OrderSubType=" + (int)com.Sconit.CodeMaster.OrderSubType.Return; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); return(PartialView(GetAjaxPageDataProcedure <ReceiptMaster>(procedureSearchStatementModel, command))); }
public ActionResult _AjaxShipOrderList(GridCommand command, OrderMasterSearchModel searchModel) { if (string.IsNullOrWhiteSpace(searchModel.OrderNo) && string.IsNullOrWhiteSpace(searchModel.Flow) && (string.IsNullOrWhiteSpace(searchModel.PartyFrom) || string.IsNullOrWhiteSpace(searchModel.PartyTo)) && string.IsNullOrEmpty(searchModel.Dock)) { return(PartialView(new GridModel(new List <OrderMaster>()))); } else { ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchStatement_1(command, searchModel); //SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); return(PartialView(GetAjaxPageDataProcedure <OrderMaster>(procedureSearchStatementModel, command))); } }
public void SaveRecDetailViewToClient() { ProcedureSearchStatementModel procedureSearchStatementModel = TempData["ReceiptDetailPrintSearchModel"] as ProcedureSearchStatementModel; TempData["ReceiptDetailPrintSearchModel"] = procedureSearchStatementModel; GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = (int)procedureSearchStatementModel.PageParameters[2].Parameter; procedureSearchStatementModel.PageParameters[3].Parameter = 1; GridModel <object[]> gridModel = GetAjaxPageDataProcedure <object[]>(procedureSearchStatementModel, command); IList <ReceiptDetail> receiptDetailList = new List <ReceiptDetail>(); if (gridModel.Data != null && gridModel.Data.Count() > 0) { #region receiptDetailList = (from tak in gridModel.Data select new ReceiptDetail { Id = (int)tak[0], ReceiptNo = (string)tak[1], OrderNo = (string)tak[2], IpNo = (string)tak[3], Flow = (string)tak[4], ExternalOrderNo = (string)tak[5], ExternalSequence = (string)tak[6], Item = (string)tak[7], ReferenceItemCode = (string)tak[8], ItemDescription = (string)tak[9], Uom = (string)tak[10], LocationFrom = (string)tak[11], LocationTo = (string)tak[12], ReceivedQty = (decimal)tak[13], MastPartyFrom = (string)tak[14], MastPartyTo = (string)tak[15], MastType = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderType, int.Parse((tak[16]).ToString())), MastStatus = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderStatus, int.Parse((tak[17]).ToString())), MastCreateDate = (DateTime)tak[18], SAPLocation = (string)tak[19], }).ToList(); #endregion } IList <object> data = new List <object>(); data.Add(receiptDetailList); reportGen.WriteToClient("ReceiptDetView.xls", data, "ReceiptDetView.xls"); }
private ProcedureSearchStatementModel PrepareSearchDetailStatement(GridCommand command, ReceiptMasterSearchModel searchModel, string whereStatement) { List <ProcedureParameter> paraList = new List <ProcedureParameter>(); List <ProcedureParameter> pageParaList = new List <ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.ReceiptNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine, Type = NHibernate.NHibernateUtil.String // + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WMSNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = true, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) {//RecNo,ItemDesc,RecQty,LocTo if (command.SortDescriptors[0].Member == "StatusDescription") { command.SortDescriptors[0].Member = "Status"; } if (command.SortDescriptors[0].Member == "ReceiptNo") { command.SortDescriptors[0].Member = "RecNo"; } if (command.SortDescriptors[0].Member == "ItemDescription") { command.SortDescriptors[0].Member = "ItemDesc"; } if (command.SortDescriptors[0].Member == "ReceivedQty") { command.SortDescriptors[0].Member = "RecQty"; } if (command.SortDescriptors[0].Member == "LocationTo") { command.SortDescriptors[0].Member = "LocTo"; } if (command.SortDescriptors[0].Member == "MastType") { command.SortDescriptors[0].Member = "MastOrderType"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_RecDetCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_RecDet"; return(procedureSearchStatementModel); }
private ProcedureSearchStatementModel PrepareSearchStatement_1(GridCommand command, OrderMasterSearchModel searchModel) { string whereStatement = string.Format(" and o.IsShipScanHu = 0 and o.Status in ('{0}','{1}') and o.SubType='{2}' and exists (select 1 from OrderDetail as d where d.ShipQty < d.OrderQty and d.OrderNo = o.OrderNo) ", (int)com.Sconit.CodeMaster.OrderStatus.Submit, (int)com.Sconit.CodeMaster.OrderStatus.InProcess, (int)com.Sconit.CodeMaster.OrderSubType.Normal); List <ProcedureParameter> paraList = new List <ProcedureParameter>(); List <ProcedureParameter> pageParaList = new List <ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.SubType, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Priority, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ExternalOrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ReferenceOrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.TraceCode, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.CreateUserName, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.DateFrom, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.DateTo, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartTime, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndTime, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WindowTimeFrom, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WindowTimeTo, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Sequence, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = false, Type = NHibernate.NHibernateUtil.Boolean }); paraList.Add(new ProcedureParameter { Parameter = true, Type = NHibernate.NHibernateUtil.Boolean }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "Type"; } else if (command.SortDescriptors[0].Member == "OrderPriorityDescription") { command.SortDescriptors[0].Member = "Priority"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_ProcurementOrderCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_ProcurementOrder"; return(procedureSearchStatementModel); }