public crmStage SubStagesCreate() { crmStage stage = new crmStage(this.Session, this.VersionState); SubStages.Add(stage); return(stage); }
private void Form1_Load(object sender, System.EventArgs e) { if (xpCollection1.Count == 0) { Person person = new Person(session1); person.Name = "Adam"; Address addr = new Address(session1); addr.AddressLine1 = "Apple st., 1"; addr.City = "Edem"; addr.Zip = "111"; person.Address = addr; person.Save(); xpCollection1.Add(person); person = new Person(session1); person.Name = "Freddy"; addr = new Address(session1); addr.AddressLine1 = "Elm st., 13"; addr.City = "San-city"; addr.Zip = "222"; person.Address = addr; person.Save(); xpCollection1.Add(person); } }
internal static int AddNew(User user) { using (var unitOfWork = new UnitOfWork()) { DB.Users dbUser; using (var users = new XPCollection <DB.Users>(unitOfWork)) { dbUser = users.FirstOrDefault(u => u.Login == user.Login); if (dbUser != null) { throw new Exception(Resources.Users_AddNew_Такой_пользователь_уже_существует_); } dbUser = new DB.Users(unitOfWork) { Login = user.Login, PasswordHash = user.PasswordHash, SiteId = user.SiteId }; users.Add(dbUser); } unitOfWork.CommitChanges(); return(dbUser.Id); } }
private static int AddNew(Car item) { using (var unitOfWork = new UnitOfWork()) { DB.Cars dbItem; using (var items = new XPCollection <DB.Cars>(unitOfWork)) { dbItem = new DB.Cars(unitOfWork) { Color = (int)item.Color, Engine = item.Enginge, Kpp = item.Kpp, Number = item.Number, Sts = item.Sts, TO = item.TO, Year = item.Year, Body = (int)item.BodyType, Insurance = item.Insurance, BodyNumber = item.BodyNumber, Mileage = item.Mileage, SiteId = item.SiteId, Deleted = item.Deleted }; items.Add(FillDependencies(unitOfWork, dbItem, item)); } unitOfWork.CommitChanges(); AddDependencies(unitOfWork, item, dbItem.Id); unitOfWork.CommitChanges(); return(dbItem.Id); } }
internal static int AddNew(Prokat item) { using (var unitOfWork = new UnitOfWork()) { DB.Prokats dbItem; using (var items = new XPCollection <DB.Prokats>(unitOfWork)) { dbItem = new DB.Prokats(unitOfWork) { Name = item.Name, Address = item.Address, Phones = item.Phones, Worktime = item.Worktime }; using (var usrs = new XPCollection <DB.Users>(unitOfWork)) { dbItem.User = usrs.FirstOrDefault(q => q.Id == item.User.Id); } items.Add(dbItem); } unitOfWork.CommitChanges(); return(dbItem.Id); } }
internal static int AddNew(Service item) { using (var unitOfWork = new UnitOfWork()) { DB.Services dbItem; using (var items = new XPCollection <DB.Services>(unitOfWork)) { dbItem = items.FirstOrDefault(u => u.Name == item.Name && u.User != null && u.User.Id == item.User.Id); if (dbItem != null) { throw new Exception(Resources.Services_AddNew_Такая_услуга_уже_существует_); } dbItem = new DB.Services(unitOfWork) { Name = item.Name, Price = item.Price, PriceType = item.PriceType, Status = item.Status, SiteId = item.SiteId, CompanyId = item.CompanyId }; using (var usrs = new XPCollection <DB.Users>(unitOfWork)) { dbItem.User = usrs.FirstOrDefault(q => q.Id == item.User.Id); } items.Add(dbItem); } unitOfWork.CommitChanges(); return(dbItem.Id); } }
internal static int AddNew(Damage item, UnitOfWork unitOfWork, bool commit = false) { DB.Damages dbItem; using (var items = new XPCollection <DB.Damages>(unitOfWork)) { if (item.Id > 0) { dbItem = items.FirstOrDefault(q => q.Id == item.Id); if (dbItem != null) { dbItem.Archive = false; } } else { dbItem = new DB.Damages(unitOfWork) { Description = item.Description, Detail = item.Detail, }; } items.Add(FillDependencies(unitOfWork, dbItem, item)); } if (commit) { unitOfWork.CommitChanges(); } return(dbItem.Id); }
public void CreateTemplates(string text, Type typeToCreate) { var textValues = text.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < textValues.Count(); i++) { if (textValues[i].Trim().Length == 0) { continue; } if (textValues[i].StartsWith("\t") == false) { var template = GenTemplate(0, i, textValues, typeToCreate); if (template != null) { TextTemplates.Add(template); } } } OnChanged("AnamnezTemplates"); OnChanged("ComplainTemplates"); OnChanged("RecomendTemplates"); OnChanged("ObjStatusTerTemplates"); Session.CommitTransaction(); }
private void sb_ok_Click(object sender, EventArgs e) { if (!CheckBeforeSave()) { return; } UnitOfWork unitOfWork = xp_cb01.Session as UnitOfWork; try { cb01.CB002 = rg_cb002.EditValue.ToString(); cb01.CB003 = te_cb003.Text; cb01.CB005 = glue_cb005.EditValue == null ? "": glue_cb005.EditValue.ToString(); cb01.CB006 = mem_cb006.Text; if (b_isnew) { xp_cb01.Add(cb01); } unitOfWork.CommitChanges(); XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DialogResult = DialogResult.OK; this.Close(); } catch (Exception ee) { unitOfWork.RollbackTransaction(); LogUtils.Error(ee.Message); XtraMessageBox.Show(ee.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
internal static int AddNew(Mark item) { using (var unitOfWork = new UnitOfWork()) { DB.Marks dbItem; using (var items = new XPCollection <DB.Marks>(unitOfWork)) { dbItem = items.FirstOrDefault(u => u.Name == item.Name); if (dbItem != null) { throw new Exception(Resources.Marks_AddNew_Такая_марка_уже_есть_); } dbItem = new DB.Marks(unitOfWork) { Name = item.Name, SiteId = item.SiteId }; items.Add(dbItem); } unitOfWork.CommitChanges(); return(dbItem.Id); } }
void AccountItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox comboItemUnit = source as ASPxComboBox; CriteriaOperator filter = new BinaryOperator("Code", "0", BinaryOperatorType.Equal); XPCollection <NAS.DAL.Accounting.AccountChart.Account> collection = new XPCollection <NAS.DAL.Accounting.AccountChart.Account>(session, filter); foreach (NAS.DAL.Accounting.AccountChart.Account account in AccountingBO.getNotParentAccountList(session)) { collection.Add(account); } //collection.SkipReturnedObjects = e.BeginIndex; //collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; //CriteriaOperator criteria = // CriteriaOperator.Or( // new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), // new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) //); //collection.Criteria = criteria; //collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); }
public PersistentPermissionObject AddPermission(IPermission permission) { PersistentPermissionObject result = new PersistentPermissionObject(Session, permission); PersistentPermissions.Add(result); return(result); }
private void UpdateEmployees() { Employees.SuspendChangedEvents(); try { while (Employees.Count > 0) { Employees.Remove(Employees[0]); } if (!String.IsNullOrEmpty(_EmployeeIds)) { XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml(_EmployeeIds); foreach (XmlNode xmlNode in xmlDocument.DocumentElement.ChildNodes) { Employee activityUser = Session.GetObjectByKey <Employee>(new Guid(xmlNode.Attributes["Value"].Value)); if (activityUser != null) { Employees.Add(activityUser); } } } } finally { Employees.ResumeChangedEvents(); } }
internal static int AddNew(Order item) { using (var unitOfWork = new UnitOfWork()) { DB.Orders dbItem; using (var items = new XPCollection <DB.Orders>(unitOfWork)) { dbItem = new DB.Orders(unitOfWork) { Closed = item.Closed, DateFrom = item.DateFrom, DateTo = item.DateTo, MileageEnd = item.MileageEnd, Other = item.Other, Overrun = item.Overrun, Territory = item.Territory, Wash = item.Wash, Discount = item.Discount, DiscountType = item.DiscountType, SiteId = item.SiteId, Deleted = item.Deleted }; items.Add(FillDependencies(unitOfWork, dbItem, item)); } unitOfWork.CommitChanges(); AddDependencies(unitOfWork, item, dbItem); unitOfWork.CommitChanges(); return(dbItem.Id); } }
private void AddPrivateMessageinCache(string fromEmail, string chatToEmail, string userName, string message) { var uow = new XpoDAO().ProvideUnitOfWork(); var ChatPrivateMessageMasters = new XPCollection <ChatPrivateMessageMaster>(uow); // Save master var master = ChatPrivateMessageMasters.ToList().Where(a => a.EmailID.Equals(fromEmail)).ToList(); if (master.Count == 0) { var result = new ChatPrivateMessageMaster(uow) { EmailID = fromEmail, UserName = userName }; ChatPrivateMessageMasters.Add(result); uow.CommitChanges(); } // Save details var ChatPrivateMessageDetails = new XPCollection <ChatPrivateMessageDetail>(uow); var resultDetails = new ChatPrivateMessageDetail(uow) { MasterEmailID = fromEmail, ChatToEmailID = chatToEmail, Message = message }; ChatPrivateMessageDetails.Add(resultDetails); uow.CommitChanges(); }
public void FillValutaCourceCollection(DateTime courceDate) { if (courceDate == DateTime.MinValue) { return; } XPQuery <csCNMValutaCourse> valutaCourses = new XPQuery <csCNMValutaCourse>(Session, true); var queryValutaCourses = from valutaCourse in valutaCourses where valutaCourse.CourseDate == courceDate select valutaCourse; foreach (var valutaCourse in queryValutaCourses) { if (!_CourseDayTable.Contains <csCNMValutaCourse>(valutaCourse)) { _CourseDayTable.Add(valutaCourse); } } // Дополнение коллекции теми валютами, которые в ней отсутствуют, а в справочнике валют имеются. XPQuery <csValuta> currencies = new XPQuery <csValuta>(Session, true); var queryCurrencies = from currency in currencies select currency; foreach (var currency in queryCurrencies) { bool isFound = false; foreach (csCNMValutaCourse vCourse in _CourseDayTable) { if (vCourse.Valuta == currency) { isFound = true; break; } } if (!isFound) { csCNMValutaCourse newRow = new csCNMValutaCourse(Session); newRow.Valuta = currency; newRow.CourseDate = CourseDate.Date; newRow.Course = 0; _CourseDayTable.Add(newRow); } } }
public async Task OnInitializeDatabaseRulesCommand() { XPCollection <RuleModel> _rules = new XPCollection <RuleModel>(uow); var RulesMain = await Utilities.GetFirewallRule(); foreach (var psObj in RulesMain) { var r = new RuleModel(uow); var _rule = await Utilities.ConvertToRule(psObj); XPCollection <RuleModel> check = new XPCollection <RuleModel>(uow, CriteriaOperator.Parse($@"DisplayName = '{_rule.DisplayName}'")); if (check.Count == 0 && _rule.DisplayGroup == "") { try { await _rule.GetAdditionalInfo(); r.DisplayName = _rule.DisplayName; r.DisplayGroup = _rule.DisplayGroup; r.InstanceID = _rule.InstanceID; r.Action = _rule.Action.ToString(); r.Enabled = _rule.Enabled.ToString(); r.Direction = _rule.Direction.ToString(); r.EdgeTraversalPolicy = _rule.EdgeTraversalPolicy.ToString(); r.PrimaryStatus = _rule.PrimaryStatus.ToString(); r.InterfaceType = _rule.InterfaceType.ToString(); r.Program = _rule.Program; r.LocalAddress = _rule.LocalAddress; r.RemoteAddress = _rule.RemoteAddress; r.LocalPort = _rule.LocalPort; r.RemotePort = _rule.RemotePort; r.Protocol = _rule.Protocol.ToString(); r.Profile = _rule.Profile.ToString(); _rules.Add(r); uow.CommitChanges(); } catch { r.DisplayName = _rule.DisplayName; r.Description = "FAILED"; _rules.Add(r); Debug.WriteLine($@"FAILED INSERT {_rule.DisplayName}"); } } } }
public MovieCategory CreateCategory() { XPCollection <MovieCategory> categories = MovieCategoriesEdit.VRObjectsEditObject.VideoRentObjects; MovieCategory category; using (NewNameGenerator <MovieCategory> generator = new NewNameGenerator <MovieCategory>(categories)) { category = new MovieCategory(categories.Session, generator.RetrieveNewName()); } categories.Add(category); MovieCategoriesEdit.CurrentRecord = category; return(category); }
public XPCollection <RouteStation> MapFrom(XPCollection <ServiceStation> input) { XPCollection <RouteStation> routeStations; routeStations = new XPCollection <RouteStation>(input.Session); foreach (ServiceStation station in input) { routeStations.Add(new RouteStationMapper().MapFrom(station)); } return(routeStations); }
public static XPCollection <MovieItem> CreateFewItems(MovieItem pattern, int count) { XPCollection <MovieItem> ret = new XPCollection <MovieItem>(pattern.Session, false); for (int i = 0; i < count; ++i) { MovieItem item = new MovieItem(pattern.Movie, pattern.Format); item.AvailableForSell = pattern.AvailableForSell; item.SellingPrice = pattern.SellingPrice; ret.Add(item); } return(ret); }
/// <summary> /// Resgata todos os motivos com status inativos cadastrados /// </summary> /// <param name="session">sessão</param> /// <returns>coleção de motivos ativos</returns> public static XPCollection <MotivoCancelamento> GetMotivosInativos(Session session) { ICollection collection = session.GetObjects(session.GetClassInfo <MotivoCancelamento>(), CriteriaOperator.Parse(String.Format("CsSituacao = '{0}'", CsStatusMotivoCancelamento.Inativo)), null, 0, false, true); XPCollection <MotivoCancelamento> result = new XPCollection <MotivoCancelamento>(session, false); foreach (MotivoCancelamento ct in collection) { result.Add(ct); } return(result); }
private void AddAllMessageinCache(string userName, string message) { var uow = new XpoDAO().ProvideUnitOfWork(); var ChatMessageDetails = new XPCollection <ChatMessageDetail>(uow); var messageDetail = new ChatMessageDetail(uow) { UserName = userName, Message = message, EmailID = emailIDLoaded }; ChatMessageDetails.Add(messageDetail); uow.CommitChanges(); }
internal static int AddNew(Rent item, UnitOfWork unitOfWork) { DB.Rents dbItem; using (var items = new XPCollection <DB.Rents>(unitOfWork)) { dbItem = new DB.Rents(unitOfWork) { Status = item.Status, Price = item.Price, To = item.To, From = item.From, SiteId = item.SiteId }; items.Add(FillDependencies(unitOfWork, dbItem, item)); } return(dbItem.Id); }
private static void CreateTable() { UnitOfWork uow = new UnitOfWork(); XPCollection <Customer> col = new XPCollection <Customer>(uow); if (col.Count != 0) { return; } for (int i = 0; i < 50; i++) { Customer customer = new Customer(uow); customer.ID = i; customer.Name = "Name" + i; col.Add(customer); } uow.CommitChanges(); }
private void btnAddNewAppointment_Click(object sender, RoutedEventArgs e) { XPCollection xpcAppointments = schedulerControl1.Storage.AppointmentStorage.DataSource as XPCollection; DateTime baseTime = DateTime.Today; XPAppointment apt = new XPAppointment(); apt.Created = baseTime.AddHours(3); apt.Finish = baseTime.AddHours(4); apt.Subject = "Test3"; apt.Location = "Office"; apt.Description = "Test procedure"; apt.Price = 20m; xpcAppointments.Add(apt); apt.Save(); schedulerControl1.Start = baseTime; }
public void OnUpdateButtonCommand() { SelectedSavePersonCollection = new XPCollection <Person_Selected>(session); foreach (var p in SelectedPersonCollection) { Person_Selected ps = new Person_Selected(session) { FirstName = p.FirstName, PersonObj = p, LastName = p.LastName, MiddleName = p.MiddleName }; SelectedSavePersonCollection.Add(ps); } session.Save(SelectedSavePersonCollection); }
internal static int AddNew(Damage item) { using (var unitOfWork = new UnitOfWork()) { DB.Damages dbItem; using (var items = new XPCollection <DB.Damages>(unitOfWork)) { dbItem = new DB.Damages(unitOfWork) { Description = item.Description, Detail = item.Detail, }; items.Add(FillDependencies(unitOfWork, dbItem, item)); } unitOfWork.CommitChanges(); return(dbItem.Id); } }
internal static int AddNew(Template item) { using (var unitOfWork = new UnitOfWork()) { DB.Templates dbItem; using (var items = new XPCollection <DB.Templates>(unitOfWork)) { dbItem = new DB.Templates(unitOfWork) { Path = item.Path, File = item.File }; using (var usrs = new XPCollection <DB.Users>(unitOfWork)) { dbItem.User = usrs.FirstOrDefault(q => q.Id == item.User.Id); } items.Add(dbItem); } unitOfWork.CommitChanges(); return(dbItem.Id); } }
public static int AddNew(Damage item, DB.Orders order, UnitOfWork unitOfWork) { DB.OrderDamages dbItem; using (var items = new XPCollection <DB.Damages>(unitOfWork)) { var dbDamage = items.FirstOrDefault(u => u.Id == item.Id); if (dbDamage == null) { throw new Exception(Resources.Damages_Read_Повреждение_не_найдено_); } using (var ods = new XPCollection <DB.OrderDamages>(unitOfWork)) { dbItem = new DB.OrderDamages(unitOfWork) { Damage = dbDamage, Order = order }; ods.Add(dbItem); } } return(dbItem.Id); }
public static int AddNew(Service item, DB.Orders order, UnitOfWork unitOfWork) { DB.OrderServices dbItem; using (var items = new XPCollection <DB.Services>(unitOfWork)) { var dbServ = items.FirstOrDefault(u => u.Id == item.Id); if (dbServ == null) { throw new Exception(Resources.Services_Read_Услуга_не_найдена_); } using (var oss = new XPCollection <DB.OrderServices>(unitOfWork)) { dbItem = new DB.OrderServices(unitOfWork) { Service = dbServ, Order = order }; oss.Add(dbItem); } } return(dbItem.Id); }
private void cacheProdRoute() { XPClassInfo prodRouteClass; CriteriaOperator criteria; SortingCollection sortProps; string key; prodRouteClass = uow.GetClassInfo(typeof(ProdRoute)); criteria = CriteriaOperator.Parse(string.Format("(ProdOrder.OrderStatus = '{0}' && WipQty > 0) ", ProdOrder.ProdOrderStatus.Active)); sortProps = new SortingCollection(null); //sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending)); ICollection prodRoutes = uow.GetObjects(prodRouteClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPProdRoute> pRoutes; WIPProdRoute pRoute; foreach (ProdRoute prodRoute in prodRoutes ) { pRoute = new WIPProdRoute(Session, prodRoute); if (pRoute.Qty > 0) { pRoute.WIPTable = wipTable; pRoute.Save(); key = pRoute.ProdRoute.Item.ItemNo + "_" + pRoute.ProdRoute.ProdOrder.OrderType.Name +"_" + pRoute.ProdRoute.WorkOper.Name; if (dictProdRoute.ContainsKey(key)) { pRoutes = dictProdRoute[key]; pRoutes.Add(pRoute); } else { pRoutes = new XPCollection<WIPProdRoute>(Session, false); pRoutes.Add(pRoute); dictProdRoute.Add(key, pRoutes); } } else { pRoute.Delete(); } } }
private void cachePOLine() { XPClassInfo poLineClass = uow.GetClassInfo(typeof(PurchOrderLine)); CriteriaOperator criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' OR OrderStatus = '{1}' OR OrderStatus = '{2}') ", PurchOrderLine.PurchOrderStatus.Approval, PurchOrderLine.PurchOrderStatus.Waiting, PurchOrderLine.PurchOrderStatus.Active)); SortingCollection sortProps = new SortingCollection(null); sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending)); ICollection purchOrderLines = uow.GetObjects(poLineClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPPurchOrderLine> poLines; WIPPurchOrderLine poLine; foreach (PurchOrderLine purchOrderLine in purchOrderLines) { string itemNo = purchOrderLine.Item.ItemNo; poLine = new WIPPurchOrderLine(uow, purchOrderLine); poLine.WIPTable = wipTable; poLine.Save(); if (dictPoLine.ContainsKey(itemNo)) { poLines = dictPoLine[itemNo]; poLines.Add(poLine); } else { poLines = new XPCollection<WIPPurchOrderLine>(uow, false); poLines.Add(poLine); dictPoLine.Add(itemNo, poLines); } } }
private void cacheSOLine() { XPClassInfo soLineClass; CriteriaOperator criteria; SortingCollection sortProps; soLineClass = uow.GetClassInfo(typeof(SalesOrderLine)); criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' || OrderStatus == '{1}') ", SalesOrderLine.SalesOrderStatus.Active, SalesOrderLine.SalesOrderStatus.Waiting)); if (debugMode) { criteria = CriteriaOperator.Parse(string.Format("(Item.ItemNo = '05CA1798A01' ) ")); //criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' || OrderStatus == '{1}') && Item.ItemNo == '01CA9096A05' ", SalesOrderLine.SalesOrderStatus.Active, SalesOrderLine.SalesOrderStatus.Waiting)); } sortProps = new SortingCollection(null); sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending)); ICollection salesOrderLines = uow.GetObjects(soLineClass, criteria, sortProps, int.MaxValue, false, true); soLines = new XPCollection<WIPSalesOrderLine>(Session, false); WIPSalesOrderLine soLine; foreach (SalesOrderLine salesOrderLine in salesOrderLines) { soLine = new WIPSalesOrderLine(Session, salesOrderLine); soLine.WIPTable = wipTable; System.Diagnostics.Debug.Print(string.Format("SO {0}, Item {1}", salesOrderLine.SalesOrder.OrderNo, salesOrderLine.Item.ItemNo)); MakeWIPRouteLine(salesOrderLine.Item); soLine.Save(); soLines.Add(soLine); } }
private void cacheSOLine() { XPClassInfo soLineClass = uow.GetClassInfo(typeof(SalesOrderLine)); CriteriaOperator criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' || OrderStatus == '{1}') ", SalesOrderLine.SalesOrderStatus.Active, SalesOrderLine.SalesOrderStatus.Waiting)); SortingCollection sortProps = new SortingCollection(null); sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending)); ICollection salesOrderLines = uow.GetObjects(soLineClass, criteria, sortProps, int.MaxValue, false, true); soLines = new XPCollection<WIPSalesOrderLine>(uow, false); WIPSalesOrderLine soLine; foreach (SalesOrderLine salesOrderLine in salesOrderLines) { soLine = new WIPSalesOrderLine(uow, salesOrderLine); soLine.WIPTable = wipTable; soLine.Save(); soLines.Add(soLine); } }
private void cacheWHTotal() { XPClassInfo whTotalClass = uow.GetClassInfo(typeof(WHTotal)); CriteriaOperator criteria = CriteriaOperator.Parse(""); SortingCollection sortProps = new SortingCollection(null); //criteria = CriteriaOperator.Parse(string.Format("(ProdOrder.OrderStatus = '{0}') ", ProdOrder.ProdOrderStatus.Active)); //sortProps.Add(new SortProperty("NeedDate", SortingDirection.Descending)); ICollection whTotals = uow.GetObjects(whTotalClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPWHTotal> wipWHTotals; WIPWHTotal wipWHTotal; string key; foreach (WHTotal whTotal in whTotals) { wipWHTotal = new WIPWHTotal(uow, whTotal); wipWHTotal.WIPTable = wipTable; wipWHTotal.Save(); key = wipWHTotal.Item.ItemNo; if (dictWHTotal.ContainsKey(key)) { wipWHTotals = dictWHTotal[key]; wipWHTotals.Add(wipWHTotal); } else { wipWHTotals = new XPCollection<WIPWHTotal>(uow, false); wipWHTotals.Add(wipWHTotal); dictWHTotal.Add(key, wipWHTotals); } wipWHTotals.Add(wipWHTotal); } }
private void cacheProdBom() { XPClassInfo prodBomClass = uow.GetClassInfo(typeof(ProdBom)); CriteriaOperator criteria = CriteriaOperator.Parse(string.Format("(ProdOrder.OrderStatus = '{0}' && ProdOrder.WipQty > 0) ", ProdOrder.ProdOrderStatus.Active)); SortingCollection sortProps = new SortingCollection(null); string key; ICollection prodBoms = uow.GetObjects(prodBomClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPProdBom> pBoms; WIPProdBom pBom; foreach (ProdBom prodBom in prodBoms) { double diffQty = prodBom.CanMakeKitQty - prodBom.ProdOrder.KitQty; //key = prodBom.bomItem.ItemNo; key = String.Format("{0}_{1}", prodBom.ProdOrder.Item.ItemNo, prodBom.bomItem.ItemNo); if (diffQty > 0) { diffQty = (prodBom.ProdOrder.WipQty - prodBom.ProdOrder.KitQty) * prodBom.Qty / prodBom.PerSeries; if (prodBom.Unit != null) diffQty = Math.Round(diffQty, prodBom.Unit.Decimal); if (diffQty < 0) diffQty = 0; } if (diffQty > 0) { pBom = new WIPProdBom(uow, prodBom); pBom.Qty = (float)diffQty; pBom.WIPTable = wipTable; pBom.Save(); if (dictProdBom.ContainsKey(key)) { pBoms = dictProdBom[key]; pBoms.Add(pBom); } else { pBoms = new XPCollection<WIPProdBom>(uow, false); pBoms.Add(pBom); dictProdBom.Add(key, pBoms); } } } }
private void cacheProdRoute() { XPClassInfo prodRouteClass = uow.GetClassInfo(typeof(ProdRoute)); CriteriaOperator criteria = CriteriaOperator.Parse(string.Format("(ProdOrder.OrderStatus = '{0}' && WipQty > 0) ", ProdOrder.ProdOrderStatus.Active)); SortingCollection sortProps = new SortingCollection(null); string key; ICollection prodRoutes = uow.GetObjects(prodRouteClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPProdRoute> pRoutes; WIPProdRoute pRoute; foreach (ProdRoute prodRoute in prodRoutes) { pRoute = new WIPProdRoute(uow, prodRoute); pRoute.WIPTable = wipTable; pRoute.Save(); key = String.Format("{0}_{1}", pRoute.ProdRoute.Item.ItemNo, pRoute.ProdRoute.WorkOper.Name); if (pRoute.Qty > 0) { if (dictProdRoute.ContainsKey(key)) { pRoutes = dictProdRoute[key]; pRoutes.Add(pRoute); } else { pRoutes = new XPCollection<WIPProdRoute>(uow, false); pRoutes.Add(pRoute); dictProdRoute.Add(key, pRoutes); } } } }
private void RefreshAvailVendor() { _availVendor = new XPCollection<Vendor>(Session) { LoadingEnabled = false }; foreach (PriceDisc pDisc in PriceDiscs) { if (pDisc.Type == PriceDisc.PriceType.Purch) _availVendor.Add((Vendor)pDisc.ExternalContact); } }
private void cachePOLine() { XPClassInfo poLineClass; CriteriaOperator criteria; SortingCollection sortProps; poLineClass = uow.GetClassInfo(typeof(PurchOrderLine)); // Move QAQty to WHTotal //criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' OR OrderStatus = '{1}' OR OrderStatus = '{2}' OR PendingReceivedQty > 0 ) ", PurchOrderLine.PurchOrderStatus.Approval, PurchOrderLine.PurchOrderStatus.Waiting, PurchOrderLine.PurchOrderStatus.Active)); criteria = CriteriaOperator.Parse(string.Format("(OrderStatus = '{0}' OR OrderStatus = '{1}' OR OrderStatus = '{2}' ) ", PurchOrderLine.PurchOrderStatus.Approval, PurchOrderLine.PurchOrderStatus.Waiting, PurchOrderLine.PurchOrderStatus.Active)); sortProps = new SortingCollection(null); sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending)); ICollection purchOrderLines = uow.GetObjects(poLineClass, criteria, sortProps, int.MaxValue, false, true); XPCollection<WIPPurchOrderLine> poLines; WIPPurchOrderLine poLine; foreach (PurchOrderLine purchOrderLine in purchOrderLines) { string key; key = purchOrderLine.Item.ItemNo + "_" + purchOrderLine.OrderType.Name; poLine = new WIPPurchOrderLine(Session, purchOrderLine); poLine.WIPTable = wipTable; poLine.Save(); if (dictPoLine.ContainsKey(key)) { poLines = dictPoLine[key]; poLines.Add(poLine); } else { poLines = new XPCollection<WIPPurchOrderLine>(Session, false); poLines.Add(poLine); dictPoLine.Add(key, poLines); } } }
private void cachePOLineQAQty() { XPClassInfo poReceiveClass; CriteriaOperator criteria; SortingCollection sortProps; poReceiveClass = uow.GetClassInfo(typeof(PurchOrderReceive)); criteria = CriteriaOperator.Parse(string.Format("(Status = '{0}' ) ", PurchOrderReceive.OrderReceiveStatus.Waiting)); sortProps = new SortingCollection(null); ICollection poReceives = uow.GetObjects(poReceiveClass, criteria, sortProps, int.MaxValue, false, true); foreach (PurchOrderReceive poReceive in poReceives) { string key; key = poReceive.PurchOrderLine.Item.ItemNo ; WIPWHTotal wipWHTotal = GetWHTotal(key, poReceive.PurchOrderLine.Warehouse); if (wipWHTotal != null) { wipWHTotal.QAQty = wipWHTotal.QAQty + poReceive.Qty + poReceive.ScrapQty; } else { wipWHTotal = new WIPWHTotal(Session, poReceive); wipWHTotal.QAQty = wipWHTotal.QAQty + poReceive.Qty + poReceive.ScrapQty; wipWHTotal.Save(); } XPCollection<WIPWHTotal> wipWHTotals; if (dictWHTotal.ContainsKey(key)) { wipWHTotals = dictWHTotal[key]; wipWHTotals.Add(wipWHTotal); } else { wipWHTotals = new XPCollection<WIPWHTotal>(Session, false); wipWHTotal.WIPTable = wipTable; wipWHTotals.Add(wipWHTotal); dictWHTotal.Add(key, wipWHTotals); } } }
private void RefreshAvailProdOrder() { _availProdOrder = new XPCollection<ProdOrder>(Session); _availProdOrder.LoadingEnabled = false; BindingList<ProdRoute> pRoutes = this.CalcProdOrderFQCs(Session); foreach (ProdRoute pRoute in pRoutes) { _availProdOrder.Add(pRoute.ProdOrder); } }
private void cacheProdRouteQAQty() { XPClassInfo rListTransferClass; CriteriaOperator criteria; SortingCollection sortProps; rListTransferClass = uow.GetClassInfo(typeof(ProdRouteListTransfer)); criteria = CriteriaOperator.Parse(string.Format("(Status = '{0}' ) ", ProdRouteListTransfer.ProdRouteListStatus.Waiting)); sortProps = new SortingCollection(null); ICollection rListTransfers = uow.GetObjects(rListTransferClass, criteria, sortProps, int.MaxValue, false, true); foreach (ProdRouteListTransfer rListTransfer in rListTransfers) { if (rListTransfer.ToProdRoute == null) { string itemNo; itemNo = rListTransfer.ProdOrder.Item.ItemNo; WIPWHTotal wipWHTotal = GetWHTotal(itemNo, rListTransfer.ProdOrder.Warehouse); if (wipWHTotal != null) { wipWHTotal.QAQty = wipWHTotal.QAQty + rListTransfer.Qty + rListTransfer.ScrapQty; } else { wipWHTotal = new WIPWHTotal(Session, rListTransfer); wipWHTotal.WIPTable = wipTable; wipWHTotal.QAQty = wipWHTotal.QAQty + rListTransfer.Qty + rListTransfer.ScrapQty; wipWHTotal.Save(); } XPCollection<WIPWHTotal> wipWHTotals; if (dictWHTotal.ContainsKey(itemNo)) { wipWHTotals = dictWHTotal[itemNo]; wipWHTotals.Add(wipWHTotal); } else { wipWHTotals = new XPCollection<WIPWHTotal>(Session, false); wipWHTotals.Add(wipWHTotal); dictWHTotal.Add(itemNo, wipWHTotals); } } } }