Esempio n. 1
0
        public OpenPOoutputmodel Post(OpenPOinputmodel model)
        {
            string            plantcd    = model.plantcd;
            OpenPOoutputmodel result     = new OpenPOoutputmodel();
            DataTable         dt         = new DataTable();
            string            JsonString = string.Empty;

            JsonString = JsonConvert.SerializeObject(dt);

            result.OutputData = result.getDataFromDB("EXEC [helper].[uSP_Open_PO_Report_Data]  '" + model.materialnum + "','" + model.ponum + "','" + plantcd + "','" + model.pripbg + "','" + model.potype + "','" + model.plannername + "','" + model.plannermanager + "','" + model.plannerdirector + "','" + model.suppliersitename + "','" + model.ParentSupplierName + "'", " ");


            return(result);
        }
Esempio n. 2
0
        public OpenPOinputmodel Get()
        {
            OpenPOoutputmodel result     = new OpenPOoutputmodel();
            OpenPOinputmodel  input      = new OpenPOinputmodel();
            DataTable         dt         = new DataTable();
            string            JsonString = string.Empty;

            JsonString    = JsonConvert.SerializeObject(dt);
            input.pripbg  = result.getDataFromDB("exec helper.uSP_open_po_inputs 'pripbg' ", " ");
            input.plantcd = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plantcd'", " ");

            input.potype             = result.getDataFromDB("exec helper.uSP_open_po_inputs 'potype'", " ");
            input.plannername        = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannername'", " ");
            input.plannermanager     = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannermanager'", " ");
            input.plannerdirector    = result.getDataFromDB("exec helper.uSP_open_po_inputs 'plannerdirector'", " ");
            input.suppliersitename   = result.getDataFromDB("exec helper.uSP_open_po_inputs 'suppliersitename'", " ");
            input.ParentSupplierName = result.getDataFromDB("exec helper.uSP_open_po_inputs 'ParentSupplierName'", " ");

            return(input);
        }