Esempio n. 1
0
        public static int UpdateOrderDetail(int OID, int PID, int OrderCount, int UsedStockCountColored, int UsedStockCountNonColored, int ProductionCount, int CID, string PackageType, int OPStatus, int Operator, int ProductedAmount)
        {
            int nResult = -1;

            DataSet ds = new DataSet();

            using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required))
            {
                try
                {
                    DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider();


                    nResult = oSqlClientProvider.UpdateOrderDetail(OID, PID, OrderCount, UsedStockCountColored, UsedStockCountNonColored, ProductionCount, CID, PackageType, OPStatus, Operator, ProductedAmount);

                    if (nResult == 0)
                    {
                        scope1.Complete();
                    }
                }
                catch (System.Data.SqlClient.SqlException Exp)
                {
                    //bool rethrow =
                    // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy");

                    //if (rethrow)
                    //{
                    //    throw;
                    //}
                }
                catch (Exception Exp)
                {
                    //bool rethrow =
                    // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy");

                    //if (rethrow)
                    //{
                    //    throw;
                    //}
                }
            }
            return(nResult);
        }