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