Beispiel #1
0
        public ActionResult FindItemReturnList(string ProductID, string type)
        {
            var list   = SalesOrderDAL.FindItemReturnList(ProductID, type);
            var result = new { rows = list };

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Beispiel #2
0
        public ActionResult GetOcHead(string OcID)
        {
            var list   = SalesOrderDAL.GetOcHeadByID(OcID);
            var result = new { rows = list };

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Beispiel #3
0
        //查詢GEO採購數據
        public ActionResult ImportOrderReturnList(PurchaseInfo model)
        {
            var list   = SalesOrderDAL.ImportOrderFromGeo(model);
            var result = new { rows = list };

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Beispiel #4
0
        public ActionResult GetOcHeadReturnList(Order_Head model)
        {
            var list = SalesOrderDAL.GetOcHeadReturnList(model);

            //var result = new { rows = list };
            //return Json(result, JsonRequestBehavior.AllowGet);
            return(Json(list, JsonRequestBehavior.AllowGet));
        }
Beispiel #5
0
        public ActionResult DeleteListSalesBom(string OcID, int Ver, string UpperSeq, string Seq)
        {
            string result = SalesOrderDAL.DeleteSalesBomByID(OcID, Ver, UpperSeq, Seq);

            if (result == "")
            {
                return(Json("OK"));
            }
            else
            {
                return(Json("Error"));
            }
        }
Beispiel #6
0
        ////Print
        //public ActionResult Report(string ID)
        //{
        //    //ReportViewerMVC方式
        //    var list = SalesOrderDAL.GetReportReturnList("ECO210413003");
        //    ReportViewer rpv = new ReportViewer();//建立ReportViewer物建
        //    rpv.ProcessingMode = ProcessingMode.Local; //設定處理模式
        //    rpv.SizeToReportContent = true;
        //    //rpv.ZoomMode = FullPage;//rpv.AsyncRendering = false//rpvZoomMode = FullPage
        //    //設定RDLC實體位置
        //    rpv.LocalReport.ReportPath = $"{Request.MapPath(Request.ApplicationPath)}Areas\\Sales\\RDLCReports\\So.rdlc";
        //    //設定報表資料來源
        //    rpv.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSource1", list));
        //    return View(rpv);
        //}

        public ActionResult Print(string ID)
        {
            WebReport webReport = new WebReport();
            //string report_path = AppDomain.CurrentDomain.BaseDirectory;
            //webReport.ReportFile = this.Server.MapPath("~/App_Data/so.frx"); //从文件中加载报表
            string report_path = $"{Request.MapPath(Request.ApplicationPath)}Reports\\so.frx";
            var    list        = SalesOrderDAL.GetReportReturnList(ID);

            webReport.Report.RegisterData(list, "SoData"); //注冊數據
            webReport.Report.Load(report_path);            //調用報表模板
            webReport.Width             = 1024;
            webReport.Height            = 800;
            webReport.ToolbarIconsStyle = ToolbarIconsStyle.Black;
            ViewBag.WebReport           = webReport;
            return(View());
        }
Beispiel #7
0
        public ActionResult AddSalesBom(SalesBom model)
        {
            //listOrderInfo.Add(model);
            //var result = new { total = 100, rows = listOrderInfo };
            //return Json(result, JsonRequestBehavior.AllowGet);
            //string OcID = Request["OcID"] == null ? "" : Request["OcID"].ToString();
            //model.OcID = OcID;
            string result = SalesOrderDAL.UpdateSalesBom(model);

            if (result == "")
            {
                return(Json("OK"));
            }
            else
            {
                return(Json("Error"));
            }
        }
Beispiel #8
0
        //返回BOM資料
        public JsonResult SalesBom(string OcID, int Ver)
        {
            ////构造成Json的格式传递
            //if (!string.IsNullOrEmpty(OcID))
            //{
            //    var list = SalesOrderDAL.GetSalesBomByID(OcID,Ver);
            //    var result = new { total = list.Count, rows = list };
            //    return Json(result, JsonRequestBehavior.AllowGet);
            //}
            //else
            //{
            //    return Json(null, JsonRequestBehavior.AllowGet);
            //}

            var list = SalesOrderDAL.GetSalesBomByID(OcID, Ver);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
Beispiel #9
0
        //返回明細資料
        public JsonResult List(Order_Head model)
        {
            ////构造成Json的格式传递
            ////var result = new { iTotalRecords = 100, iTotalDisplayRecords = 10, data = list };
            //if (!string.IsNullOrEmpty(model.OcID))
            //{
            //    var list = SalesOrderDAL.GetOcDetailsByID(model.OcID);
            //    var result = new { total = list.Count, rows = list };
            //    return Json(result, JsonRequestBehavior.AllowGet);
            //}
            //else
            //{
            //    return Json(null, JsonRequestBehavior.AllowGet);
            //}

            var list = SalesOrderDAL.GetOcDetailsByID(model.OcID);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
Beispiel #10
0
        //返回SalesBom明細資料
        public JsonResult SalesBomList(SalesBom model)
        {
            //构造成Json的格式传递

            //if (!string.IsNullOrEmpty(model.OcID))
            //{
            //    //var list = SalesOrderDAL.GetSalesBomByID(model.OcID,model.Ver,model.UpperSeq);
            //    //2021/03/12參數改為數據模型傳值
            //    var list = SalesOrderDAL.GetSalesBomByID(model);
            //    var result = new { total = list.Count, rows = list };
            //    return Json(result, JsonRequestBehavior.AllowGet);
            //}
            //else
            //{
            //    return Json(null, JsonRequestBehavior.AllowGet);
            //}

            var list = SalesOrderDAL.GetSalesBomByID(model);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
        public List <SalesOrderEntity> GetAllSalesOrders()
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.GetAllSalesOrders());
        }
        public bool DeleteOrder(int purchaseQuotID)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.DeleteQuotatoin(purchaseQuotID));
        }
        public bool CanDeleteOrder(int pqID)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.CanDeleteOrder(pqID));
        }
Beispiel #14
0
 public ActionResult DeleteList(string OcID, int Ver, string Seq)
 {
     SalesOrderDAL.DeleteOcDetails(OcID, Ver, Seq);
     return(Json("OK"));
 }
Beispiel #15
0
        public ActionResult AddHead(Order_Head model)
        {
            string result = SalesOrderDAL.UpdateOcHead(model);

            return(Json(result));
        }
Beispiel #16
0
        //返回明細表總金額
        public ActionResult GetTotalAmount(string strOcID, int Ver, string strSeq)
        {
            var list = SalesOrderDAL.GetTotalAmountByID(strOcID, Ver, strSeq);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
Beispiel #17
0
        //返回匯率(返回字串,單個值也要轉JSON)
        public ActionResult GetCurrencyRate(string strCurrencyID)
        {
            var list = SalesOrderDAL.GetCurrencyRateByID(strCurrencyID);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
        public int ConvertToSalesOrder(SalesOrderForm pqForm)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.ConvertToSalesOrder(pqForm));
        }
Beispiel #19
0
        //后臺生成OC數據
        public ActionResult BuildOrder(PurchaseInfo model)
        {
            var result = SalesOrderDAL.GetBuildOCID(model);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
        public int UpdationOrder(SalesOrderForm quotationData)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.UpdationOrder(quotationData));
        }
Beispiel #21
0
        //返回產品編號描述(返回單行兩列)
        public ActionResult GetProductID(string strProductID)
        {
            var result = SalesOrderDAL.GetProductByID(strProductID);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Beispiel #22
0
        //返回客戶中英文描述(返回單行兩列)
        public ActionResult GetCustomer(string strCustomerID)
        {
            var result = SalesOrderDAL.GetCustomerByID(strCustomerID);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
        public int GetLatestOrderNo()
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.GetLastOrderNo());
        }
Beispiel #24
0
        //綁定值測試代碼
        public ActionResult GetClass()//數量單位
        {
            var list = SalesOrderDAL.GetQtyUnitReturnList();

            return(Json(list));
        }
        public SalesOrderForm GetSalesOrder(string pqNo)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.GetSalesOrder(pqNo));
        }
Beispiel #26
0
        //取最大單號
        public ActionResult GetMaxOcID(string strArea)
        {
            var result = SalesOrderDAL.GetMaxOcID(strArea);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
        public string GetCategoryContent(string catType)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.GetCategoryContent(catType));
        }
Beispiel #28
0
        //前端以Json格式傳多個參數,控制器可以用model或與之對應的參數列表接收.
        public ActionResult GetMoSerialNo(string strMoType, string strMoDept, string strMoGroup)
        {
            var list = SalesOrderDAL.GetMoSerialNo(strMoType, strMoDept, strMoGroup);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
        public int ConvertToSalesInvoice(SalesOrderForm quotationData)
        {
            ISalesOrderDAL PQDAL = new SalesOrderDAL();

            return(PQDAL.ConvertToSalesInvoice(quotationData));
        }
Beispiel #30
0
        //public ActionResult Print()//(string ID)
        //{
        //    //SoPrintHeadWithDetails model = new SoPrintHeadWithDetails();
        //    //model = SoDAL.PrintSo(ID);
        //    //if(model==null)
        //    //    return Content("No Order To Print~~");
        //    //return View(model);
        //    string ID = "731031556";
        //    string aspx = "/Areas/Sales/AspNetReports/Order.aspx?ID=" + ID;
        //    using (var sw = new StringWriter())
        //    {
        //        System.Web.HttpContext.Current.Server.Execute(aspx, sw, true);
        //        return Content(sw.ToString());
        //    }
        //    //return View();
        //}


        //返回數量轉換率(返回字串,單個值也要轉JSON)
        public ActionResult GetQuantityUnitRate(string strID)
        {
            var list = SalesOrderDAL.GetQuantityUnitRateByID(strID);

            return(Json(list, JsonRequestBehavior.AllowGet));
        }