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; } }