Beispiel #1
0
        private void CreateDisribution(string reNum, string reType)
        {
            BLL.CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStr, true);
            try
            {
                COA       c       = new COA(dbiz);
                ArrayList al      = c.Generate_Distribution(reNum, reType);
                string    strType = "R";
                if (reType == "UD")
                {
                    strType = "U";
                }

                dbiz.ExecuteNonQuery("delete from AR_Line_Distribution where TRANSACTION_NO='" + reNum + "' and TRANSACTION_TYPE='" + strType + "' and post_status<>'P'");
                c.Insert_Distribution(al);
                dbiz.Commit();
            }
            catch (Exception)
            {
                dbiz.Abort();
                throw;
            }
        }