示例#1
0
        /// <summary>
        /// call bapi
        /// </summary>
        /// <param name="upDT"></param>
        /// <returns></returns>
        public static bool Z_BAPI_GSD_UPDATE(DataTable upDT)
        {
            bool flag = false;

            Console.WriteLine("- Fetch : Z_BAPI_GET_SPECIAL_DOC");

            StringBuilder sbError    = new StringBuilder();
            Hashtable     InputParas = new Hashtable();

            Client.ClientParas _clientparas = new Client.ClientParas();
            _clientparas.AppID       = "CZ_Workflow";
            _clientparas.SAPFunction = "MM";
            _clientparas.BAPI        = "Z_BAPI_GET_SPECIAL_DOC";

            _clientparas.InputParas    = InputParas;
            _clientparas.InputTable    = new DataTable[1];
            _clientparas.InputTable[0] = upDT;
            _clientparas.OutputParas   = new Hashtable();
            bool bReturn = false;;

            try
            {
                bReturn = LiteOn.ICM.SIC.Client.getSAPData(ref _clientparas);
                if (bReturn)
                {
                    int iCount = _clientparas.ResultTable.Length;
                    for (int i = 0; i < iCount; i++)
                    {
                        Console.WriteLine("- Table=" + _clientparas.ResultTable[i].TableName + " rows = " + _clientparas.ResultTable[i].Rows.Count);

                        if (_clientparas.ResultTable[i].TableName == "T_ZTCPCN6D_W")
                        {
                        }
                    }
                    flag = true;
                }
                else
                {
                    DBIO.WriteLog("# Fail: " + _clientparas.sErrMsg, appName);
                    Console.WriteLine("# Fail: " + _clientparas.sErrMsg);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                DBIO.WriteLog("# Fail: " + ex.Message, appName);
            }
            return(flag);
        }
示例#2
0
        /// <summary>
        /// get sap data SAP刪除的單據
        /// </summary>
        static public void Z_BAPI_GDS_SEND_D()
        {
            Console.WriteLine("- Fetch : Z_BAPI_GDS_SEND_D");
            StringBuilder sbError    = new StringBuilder();
            Hashtable     InputParas = new Hashtable();

            Client.ClientParas _clientparas = new Client.ClientParas();
            _clientparas.AppID       = "CZ_Workflow";
            _clientparas.SAPFunction = "MM";
            _clientparas.BAPI        = "Z_BAPI_GDS_SEND_D";

            _clientparas.InputParas    = InputParas;
            _clientparas.InputTable    = new DataTable[1];
            _clientparas.InputTable[0] = BuildInputTable_GetGDS();
            _clientparas.OutputParas   = new Hashtable();

            try
            {
                bool bReturn = LiteOn.ICM.SIC.Client.getSAPData(ref _clientparas);
                if (bReturn)
                {
                    //get sap return data
                    DataTable dtD    = new DataTable();
                    int       iCount = _clientparas.ResultTable.Length;
                    for (int i = 0; i < iCount; i++)
                    {
                        Console.WriteLine(_clientparas.ResultTable[i].TableName + " rows = " + _clientparas.ResultTable[i].Rows.Count);
                        if (_clientparas.ResultTable[i].TableName == "T_GDS_D")
                        {
                            dtD = _clientparas.ResultTable[i];
                        }
                    }

                    if (dtD.Rows.Count == 0)
                    {
                        return;
                    }
                    else
                    {
                        foreach (DataRow dr in dtD.Rows)
                        {
                            string    WERKS   = dr["WERKS"].ToString();
                            string    MBLNR_A = dr["MBLNR_A"].ToString();
                            DataTable dt      = GetMaster(WERKS, MBLNR_A);
                            if (dt.Rows.Count > 0)
                            {
                                AbortFormNo(int.Parse(dt.Rows[0]["CASEID"].ToString()));
                            }
                        }
                    }
                }
                else
                {
                    Console.WriteLine("# Fail: BAPI RETURN FAIL " + _clientparas.sErrMsg);
                    DBIO.WriteLog("# Fail: BAPI RETURN FAIL" + _clientparas.sErrMsg, appName);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                DBIO.WriteLog("# Fail: SIC ERROR" + ex.Message, appName);
            }
        }