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