public FrmEmpleado(XPCollection xpcEmpleado, XPCollection xpcDepartamento, XPCollection xpcTipoNomina,XPCollection xpcPuesto,XPCollection xpcTipoEmpleado,XPCollection xpcGrupoEmpleado, XPCollection xpcPercepcion, XPCollection xpcDeduccion,XPCollection xpcConcepto,XPCollection xpcCuentaContable, UnitOfWork uow)
 {
     InitializeComponent();
     this.uow = uow;
     this.xpcEmpleado = xpcEmpleado;
     this.xpcEmpleado.Session = uow;
     this.xpcDepartamento=xpcDepartamento;
     this.xpcTipoNomina=xpcTipoNomina;
     this.xpcPuesto=xpcPuesto;
     this.xpcTipoEmpleado=xpcTipoEmpleado;
     this.xpcGrupoEmpleado = xpcGrupoEmpleado;
     this.xpcDepartamento.Session = uow;
     this.xpcTipoNomina.Session = uow;
     this.xpcPuesto.Session = uow;
     this.xpcTipoEmpleado.Session = uow;
     this.xpcGrupoEmpleado.Session = uow;
     this.xpcPercepcion = xpcPercepcion;
     this.xpcPercepcion.Session = uow;
     this.xpcDeduccion = xpcDeduccion;
     this.xpcDeduccion.Session = uow;
     this.xpcConcepto = xpcConcepto;
     this.xpcConcepto.Session = uow;
     this.xpcCuentaContable = xpcCuentaContable;
     this.xpcCuentaContable.Session = uow;
     RecargarColecciones();
     gridEmpleado.DataSource = this.xpcEmpleado;
     UpdateMenu();
     grdEmpleado.Columns.Clear();
     grdEmpleado.Columns.AddVisible("Oid");
     grdEmpleado.Columns.AddVisible("ApellidoPaterno");
     grdEmpleado.Columns.AddVisible("ApellidoMaterno");
     grdEmpleado.Columns.AddVisible("Nombre");
     grdEmpleado.BestFitColumns();
     RefreshGrid();
 }

 public FrmCrearTipoNomina(TipoNomina tiponomina, XPCollection xpcTipoNomina, UnitOfWork uow)
     : this()
 {
     this.TipoNomina = tiponomina;
     this.uow = uow;
     this.xpcTipoNomina = xpcTipoNomina;
 }

 public FrmCrearTipoEmpleado(TipoEmpleado tipoempleado, XPCollection xpcTipoEmpleado, UnitOfWork uow)
     : this()
 {
     this.TipoEmpleado = tipoempleado;
     this.uow = uow;
     this.xpcTipoEmpleado = xpcTipoEmpleado;
 }

        void SynchronizeTypes(UnitOfWork unitOfWork) {
            var xpObjectTypes = new XPCollection<XPObjectType>(unitOfWork);
            var dataStoreManager = new SqlMultiDataStoreProxy(ConnectionString);
            foreach (var xpObjectType in xpObjectTypes) {
                var type = ReflectionHelper.FindType(xpObjectType.TypeName);
                if (type != null) {
                    var connectionString = dataStoreManager.DataStoreManager.GetConnectionString(type);
                    var sqlDataStoreProxy = new SqlDataStoreProxy(connectionString);
                    var xpoObjectHacker = new XpoObjectHacker();
                    XPObjectType type1 = xpObjectType;
                    var simpleDataLayer = new SimpleDataLayer(sqlDataStoreProxy);
                    var session = new Session(simpleDataLayer);
                    bool sync = false;
                    sqlDataStoreProxy.DataStoreModifyData += (sender, args) => {
                        var insertStatement = args.ModificationStatements.OfType<InsertStatement>().Where(statement => statement.TableName == typeof(XPObjectType).Name).SingleOrDefault();
                        if (insertStatement != null && !sync) {
                            sync = true;
                            xpoObjectHacker.CreateObjectTypeIndetifier(insertStatement, simpleDataLayer, type1.Oid);
                            ModificationResult modificationResult = sqlDataStoreProxy.ModifyData(insertStatement);
                            args.ModificationResult = modificationResult;
                            args.ModificationResult.Identities = new[] { new ParameterValue { Value = type1.Oid }, };
                        }
                    };

                    if (session.FindObject<XPObjectType>(objectType => objectType.TypeName == type1.TypeName) == null) {
                        var objectType = new XPObjectType(session, xpObjectType.AssemblyName, xpObjectType.TypeName);
                        session.Save(objectType);

                    }
                }
            }
        }

        private void frmShipmentFromWH_Load(object sender, EventArgs e)
        {
            session = new Session();
            XPCollection<Customer> customers = new XPCollection<Customer>(session);
            cboCustomer.Properties.DataSource = customers;

            if (customers.Count > 0)
                cboCustomer.EditValue = customers[0].Oid;

            XPCollection<WareHouse> warehouses = new XPCollection<WareHouse>(session);
            lueWarehouse.Properties.DataSource = warehouses;

            if (warehouses.Count > 0)
                lueWarehouse.EditValue = warehouses[0].Oid;

            cboSortBy.Properties.Items.Add("先交期, 后优先");
            cboSortBy.Properties.Items.Add("先优先, 后交期");

            sSetting = ShipmentSetting.GetInstance(session);
            fromWH = new Shipment_FromWH();
            dateLastNeedDate.DateTime = DateTime.Today.AddDays(sSetting.NoOfDay);

            if (sSetting.SortBy == ShipmentSetting.SortType.DatePriority)
                cboSortBy.SelectedIndex = 0;
            else
                cboSortBy.SelectedIndex = 1;

            chkSSTK.Checked = sSetting.IncludeSSTK;
        }

 void AssignCategory(RFCategory goodRfCategory, RFCategory veryGoodRfCategory, RFCategory bestRfCategory, RFCategory badRfCategory) {
     var session = ((ObjectSpace)ObjectSpace).Session;
     var customers = new XPCollection<RFCustomer>(session);
     for (int i = 0; i < customers.Count; i++) {
         switch (i) {
             case 0:
                 customers[i].Category = goodRfCategory;
                 break;
             case 1:
                 customers[i].Category = veryGoodRfCategory;
                 break;
             case 2:
                 customers[i].Category = bestRfCategory;
                 break;
             case 3:
                 customers[i].Category = badRfCategory;
                 break;
             case 4:
                 customers[i].Category = goodRfCategory;
                 break;
             case 5:
                 customers[i].Category = veryGoodRfCategory;
                 break;
             case 6:
                 customers[i].Category = bestRfCategory;
                 break;
         }
     }
 }

        public decimal GetAverageTurnOverMonthByYearBySupplier(int year, Supplier supplier)
        {
            Decimal cost = 0;
            try
            {
                DateTime minValue = new DateTime(year, 1, 1);
                DateTime maxValue = new DateTime(year, 12, 31);
                XPCollection<Cost> costs = new XPCollection<Cost>(uow, Cost.Fields.tas_TNR_SUPPLIER == supplier
                                                                            & Cost.Fields.Date >= minValue & Cost.Fields.Date <= maxValue);

                decimal months = 1;
                if (minValue.Year == DateTime.Now.Year)
                    months = Math.Round(Convert.ToDecimal(System.DateTime.Now.Subtract(minValue).TotalDays) / Convert.ToDecimal(30.5), 0);
                else
                    months = 12;

                cost = costs.Sum(q => q.PurchaseAmount) / months;
            }
            catch (Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
            return cost;
        }

 public FrmCrearCuentaContable(CuentaContable cuentacontable, XPCollection xpcCuentaContable, UnitOfWork uow)
     : this()
 {
     this.CuentaContable = cuentacontable;
     this.uow = uow;
     this.xpcCuentaContable = xpcCuentaContable;
 }

 public FrmCrearGrupoEmpleado(GrupoEmpleado grupoempleado, XPCollection xpcGrupoEmpleado, UnitOfWork uow)
     : this()
 {
     this.GrupoEmpleado = grupoempleado;
     this.uow = uow;
     this.xpcGrupoEmpleado = xpcGrupoEmpleado;
 }

        private void btnCreateProdOrderPickList_Execute(object sender, SimpleActionExecuteEventArgs e)
        {
            if (View.CurrentObject == null)
                return;

            XPObjectSpace objectSpace = (XPObjectSpace)Application.CreateObjectSpace();

            ProdBom pBom = (ProdBom)View.CurrentObject;
            XPCollection<ProdBom> prodBoms = new XPCollection<ProdBom>(objectSpace.Session);
            prodBoms.Criteria = DevExpress.Data.Filtering.CriteriaOperator.Parse(string.Format("Oid = '{0}'", pBom.Oid));

            ProdBom prodBom = prodBoms[0];
            ProdOrder pOrder = prodBom.ProdOrder;
            ProdOrderStart prodOrderStart = pOrder.GetLastProdOrderStart();
            ProdOrderPickList pickList = objectSpace.CreateObject<ProdOrderPickList>();
            pickList.ProdBom = prodBom;
            pickList.ProdOrderStart = prodOrderStart;
            pickList.PickQty = pickList.RecommendQty;

            e.ShowViewParameters.CreatedView = Application.CreateDetailView(objectSpace, pickList);
            e.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow;
            e.ShowViewParameters.Context = TemplateContext.PopupWindow;
            e.ShowViewParameters.CreateAllControllers = true;

            DialogController dialogController = new DialogController();
            e.ShowViewParameters.Controllers.Add(dialogController);
        }

        private void btnLoad_Click(object sender, EventArgs e)
        {
            session = new Session();
            ProdOrder prodOrder;

            txtProdOrderNo.Text = txtProdOrderNo.Text.Trim().ToUpper();
            prodOrder = session.FindObject<ProdOrder>(new BinaryOperator("OrderNo", txtProdOrderNo.Text));

            if (prodOrder == null)
            {
                XtraMessageBox.Show(string.Format("找不到此生产单号 {0} !!", txtProdOrderNo.Text));
                clear();
                return;
            }

            txtItemNo.Text = prodOrder.Item.ItemNo;
            txtItemName.Text = prodOrder.Item.ItemName;
            txtItemType.Text = prodOrder.Item.ItemType.ItemTypeName;
            txtStartQty.Text = prodOrder.StartQty.ToString();
            txtFinishQty.Text = prodOrder.FinishQty.ToString();
            txtWipQty.Text = prodOrder.WipQty.ToString();

            prodBomReturns = this.GetProdBomReturnIList(prodOrder);
            gridProdOrderReturList.DataSource = prodBomReturns;

            XPCollection<WareHouse> wareHouses = new XPCollection<WareHouse>(session);
            lookupWarehouse.DataSource = wareHouses;
            lookupWarehouse.ValueMember = "This";
            lookupWarehouse.DisplayMember = "WarehouseName";
            btnPost.Enabled = true;
        }

 public FrmCrearSubsidio(Subsidio subsidio, XPCollection xpcSubsidio, UnitOfWork uow)
     : this()
 {
     this.Subsidio = subsidio;
     this.uow = uow;
     this.xpcSubsidio = xpcSubsidio;
 }

 public FrmCrearPuesto(Puesto puesto, XPCollection xpcPuesto, UnitOfWork uow)
     : this()
 {
     this.Puesto = puesto;
     this.uow = uow;
     this.xpcPuesto = xpcPuesto;
 }

 private void btnAsignar_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
 {
     PercepcionBase percepcionbase = ((PercepcionBase)xpcPercepcionBase[grdPercepcionBase.FocusedRowHandle]);
     XPCollection xpcPercepcionBaseAnidada = new XPCollection(uowAnidada, xpcPercepcionBase, new GroupOperator(GroupOperatorType.And, new BinaryOperator("This", percepcionbase, BinaryOperatorType.Equal)));
     if (xpcPercepcionBaseAnidada.Count != 0)
     {
         PercepcionBase percepcionbase1 = (PercepcionBase)(xpcPercepcionBaseAnidada[0]);
         xpcConceptoDetalleAnidada.Filter = new GroupOperator(GroupOperatorType.And, new BinaryOperator("PercepcionBase", percepcionbase1, BinaryOperatorType.Equal),
             new BinaryOperator("Concepto", concepto, BinaryOperatorType.Equal));
         if (xpcConceptoDetalleAnidada.Count == 0)
         {
             ConceptoDetalle conceptodetalle = new ConceptoDetalle(uowAnidada);
             conceptodetalle.Concepto = concepto;
             conceptodetalle.PercepcionBase = percepcionbase1;
             //                conceptodetalle.Save();
             xpcConceptoDetalleAnidada.Add(conceptodetalle);
             xpcConceptoDetalleAnidada.Filter = new GroupOperator(GroupOperatorType.And, new BinaryOperator("Concepto", concepto, BinaryOperatorType.Equal));
             Close();
         }
         else
         {
             XtraMessageBox.Show("La Percepcion Base ya Esta Incluida en el Concepto", "Percepcion Base ya Incluida", MessageBoxButtons.OK, MessageBoxIcon.Error);
             xpcConceptoDetalleAnidada.Filter = new GroupOperator(GroupOperatorType.And, new BinaryOperator("Concepto", concepto, BinaryOperatorType.Equal));
             Close();
         }
     }
 }

 public FrmCrearImpuesto(Impuesto impuesto, XPCollection xpcImpuesto, UnitOfWork uow)
     : this()
 {
     InitializeComponent();
     this.Impuesto = impuesto;
     this.uow = uow;
     this.xpcImpuesto = xpcImpuesto;
 }

        protected override void OnActivated()
        {
            base.OnActivated();

            subjectAreaCollection = ObjectSpace.CreateObject<XPCollection<SubjectArea>>();
            subjectAreaCollection.Load();

            PopulateSubjectAreaList();
        }

 protected override void OnChanged(string propertyName, object oldValue, object newValue) {
     base.OnChanged(propertyName, oldValue, newValue);
     if (propertyName == "ConnectionString") {
         try {
             _dataTables = new XPCollection<DataTable>(Session, GetStorageTables());
         } catch (UnableToOpenDatabaseException) {
         }
         OnChanged("DataTables");
     }
 }

        /// <summary>
        /// 检索消费备注项目列表
        /// </summary>
        /// <returns></returns>
        public XPCollection<t_Consume_Content> SearchConsumItems()
        {
            GroupOperator groupCriteria = new GroupOperator(
                GroupOperatorType.And,
                new BinaryOperator("State", 0, BinaryOperatorType.Equal)
            );

            XPCollection<t_Consume_Content> res = new XPCollection<t_Consume_Content>(theCriteria: groupCriteria);
            return res;
        }

 public void SynchronizeTypes( string connectionString) {
     var types = new XPCollection<XPObjectType>(new Session { ConnectionString = connectionString });
     var xpObjectTypes = types.ToList().Where(objectType => ReflectionHelper.FindType(objectType.TypeName) != null);
     var sqlMultiDataStoreProxy = new SqlMultiDataStoreProxy(connectionString);
     foreach (var connstring in GetConnectionStrings(sqlMultiDataStoreProxy.DataStoreManager, xpObjectTypes,connectionString)) {
         if (connstring!=connectionString) {
             SynchronizeTypes(connstring, xpObjectTypes);
         }
     }
 }

 public FrmCuentaContable(XPCollection xpcCuentaContable, UnitOfWork uow)
 {
     InitializeComponent();
     this.uow = uow;
     this.xpcCuentaContable = xpcCuentaContable;
     this.xpcCuentaContable.Session = uow;
     RecargarColecciones();
     gridCuentaContable.DataSource = this.xpcCuentaContable;
     UpdateMenu();
     RefreshGrid();
 }