/// <summary> /// VInOutGen Search Data /// </summary> /// <param name="adClientID"></param> /// <param name="mWarehouseIDs"></param> /// <param name="cBPartnerIDs"></param> /// <param name="cOrderIDSearchs"></param> /// <returns></returns> public JsonResult ExecuteQueryVinoutgen(int adClientID, string mWarehouseIDs, string cBPartnerIDs, string cOrderIDSearchs) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var value = obj.ExecuteQueryVinoutgen(ctx, adClientID, mWarehouseIDs, cBPartnerIDs, cOrderIDSearchs); return(Json(JsonConvert.SerializeObject(value), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Get Invoice Data /// </summary> /// <param name="displays"></param> /// <param name="cBPartnerId"></param> /// <param name="isReturnTrxs"></param> /// <returns></returns> public JsonResult GetInvoicesVCreate(string displays, int cBPartnerId, bool isReturnTrxs, bool IsDrops) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var stValue = obj.GetInvoicesVCreate(ctx, displays, cBPartnerId, isReturnTrxs, IsDrops); return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Unused Function /// </summary> /// <param name="MInOutIDs"></param> /// <param name="isBaseLanguageUmos"></param> /// <returns></returns> public JsonResult GetShipmentDatas(string MInOutIDs, string isBaseLanguageUmos) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var stValue = obj.GetShipmentDatas(ctx, MInOutIDs, isBaseLanguageUmos); return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet)); }
/// <summary> /// Get Shipment data /// </summary> /// <param name="displays"></param> /// <param name="CBPartnerIDs"></param> /// <returns></returns> public JsonResult GetShipments(string displays, int CBPartnerIDs, bool IsDrop, bool IsSOTrx) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var stValue = obj.GetShipments(ctx, displays, CBPartnerIDs, IsDrop, IsSOTrx); return(Json(JsonConvert.SerializeObject(stValue), JsonRequestBehavior.AllowGet)); }
/// <summary> /// get Orders /// </summary> /// <param name="displays">Display Columns</param> /// <param name="columns">Column Name</param> /// <param name="C_BPartner_IDs">Business Partner</param> /// <param name="isReturnTrxs">Return Transaction</param> /// <param name="OrgIds">Organization</param> /// <param name="IsDrop">Drop Shipment</param> /// <param name="IsSOTrx">Sales Transaction</param> /// <param name="forInvoices">For Invoice</param> /// <returns>List of Orders in Json Format</returns> public JsonResult VCreateGetOrders(string displays, string columns, int C_BPartner_IDs, bool isReturnTrxs, int OrgIds, bool IsDrop, bool IsSOTrx, bool forInvoices) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var value = obj.VCreateGetOrders(ctx, displays, columns, C_BPartner_IDs, isReturnTrxs, OrgIds, IsDrop, IsSOTrx, forInvoices); return(Json(new { result = value }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Get match data for Order, Invoice and Ship/Receipt on Matching PO - invoice form. /// </summary> /// <param name="displayMATCH_INVOICEs"></param> /// <param name="chkIsReturnTrxProps"></param> /// <param name="displayMATCH_ORDERs"></param> /// <param name="matchToTypeMATCH_SHIPMENTs"></param> /// <param name="matchedsss"></param> /// <param name="chkSameBPartnerss"></param> /// <param name="chkSameProductss"></param> /// <param name="chkSameQtyss"></param> /// <param name="from_ss"></param> /// <param name="fromIfs"></param> /// <param name="to_Dats"></param> /// <param name="matchToTypes"></param> /// <param name="MATCH_SHIPMENTs"></param> /// <param name="MATCH_ORDERs"></param> /// <param name="onlyProduct_ss"></param> /// <param name="onlyVendor_ss"></param> /// <param name="MatchToID"></param> /// <returns></returns> public JsonResult GetTableLoadVmatch(string displayMATCH_INVOICEs, bool chkIsReturnTrxProps, string displayMATCH_ORDERs, string matchToTypeMATCH_SHIPMENTs, bool matchedsss, string chkSameBPartnerss, string chkSameProductss, string chkSameQtyss, string from_ss, string fromIfs, string to_Dats, string matchToTypes, string MATCH_SHIPMENTs, string MATCH_ORDERs, string onlyProduct_ss, string onlyVendor_ss, string MatchToID) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var res = obj.GetTableLoadVmatch(ctx, displayMATCH_INVOICEs, chkIsReturnTrxProps, displayMATCH_ORDERs, matchToTypeMATCH_SHIPMENTs, matchedsss, chkSameBPartnerss, chkSameProductss, chkSameQtyss, from_ss, fromIfs, to_Dats, matchToTypes, MATCH_SHIPMENTs, MATCH_ORDERs, onlyProduct_ss, onlyVendor_ss, MatchToID); return(Json(JsonConvert.SerializeObject(res), JsonRequestBehavior.AllowGet)); }
/// <summary> /// VInOutGen get data from c_order /// </summary> /// <param name="adClientID"></param> /// <param name="adOrgIDs"></param> /// <param name="cBPartnerIDs"></param> /// <param name="ordShipmentids"></param> /// <returns></returns> public JsonResult ExecuteQueryVInvoiceGen(int adClientID, string adOrgIDs, string cBPartnerIDs, string ordShipmentids) { var ctx = Session["ctx"] as Ctx; VCreateFromModel obj = new VCreateFromModel(); var value = obj.ExecuteQueryVInvoiceGen(ctx, adClientID, adOrgIDs, cBPartnerIDs, ordShipmentids); // return Json(new { result = value }, JsonRequestBehavior.AllowGet); return(Json(JsonConvert.SerializeObject(value), JsonRequestBehavior.AllowGet)); }