public MainPage()
{
InitializeComponent();
this.NextPage.Clicked += NextPage_Clicked;
this.PreviousPage.Clicked += PreviousPage_Clicked;
this.ChangeBehavior.Clicked += ChangeBehavior_Clicked;
uoW = XpoHelper.CreateUnitOfWork();
SortingCollection sorting = new SortingCollection();
sorting.Add(new SortProperty("Index", DevExpress.Xpo.DB.SortingDirection.Ascending));
XPCollection <Item> Collection = new XPCollection <Item>(uoW);
Collection.Sorting = sorting;
selector = new XamarinXpoPageSelector <Item>(Collection, 10, XpoObservablePageSelectorBehavior.SinglePage);
this.listView.ItemsSource = selector.ObservableData;
//var pagecount = selector.Selector.PageCount;
// FirstPage();
}
public void SPCBRPsoriasisInitializeKodeSolusi()
{
XPCollection <DataSolusi> querykodesolusi = new XPCollection <DataSolusi>(Session);
SortingCollection sort = new SortingCollection();
sort.Add(new SortProperty("kodesolusi", SortingDirection.Ascending));
querykodesolusi.Sorting = sort;
foreach (DataSolusi theRow in querykodesolusi)
{
this.kosul = (Int32.Parse(theRow.kodesolusi.Substring(1)) + 1).ToString();
}
if (this.kosul != null)
{
if (this.kosul.Length == 1)
{
this.KodeSolusi = "S000" + this.kosul;
}
else if (this.kosul.Length == 2)
{
this.KodeSolusi = "S00" + this.kosul;
}
else if (this.kosul.Length == 3)
{
this.KodeSolusi = "S0" + this.kosul;
}
else
{
this.KodeSolusi = "S" + this.kosul;
}
}
else
{
this.KodeSolusi = "S0001";
}
}
public void SPCBRPsoriasisInitializeAikode()
{
XPCollection <DataKeluhan> queryaikode = new XPCollection <DataKeluhan>(Session);
SortingCollection sort = new SortingCollection();
sort.Add(new SortProperty("kodekeluhan", SortingDirection.Ascending));
queryaikode.Sorting = sort;
foreach (DataKeluhan theRow in queryaikode)
{
this.Aikode = (Int32.Parse(theRow.KodeKeluhan.Substring(2)) + 1).ToString();
}
if (this.Aikode != null)
{
if (this.Aikode.Length == 1)
{
this.KodeKeluhan = "KL000" + this.Aikode;
}
else if (this.Aikode.Length == 2)
{
this.KodeKeluhan = "KL00" + this.Aikode;
}
else if (this.Aikode.Length == 3)
{
this.KodeKeluhan = "KL0" + this.Aikode;
}
else
{
this.KodeKeluhan = "KL" + this.Aikode;
}
}
else
{
this.KodeKeluhan = "KL0001";
}
}
public void SortStepsBySeqNo()
{
SortingCollection sortCollection = new SortingCollection();
sortCollection.Add(new SortProperty("SeqNo", SortingDirection.Ascending));
Steps.Sorting = sortCollection;
}
//Get DocumentFinanceYearSerieTerminal for Terminal
public static fin_documentfinanceyearserieterminal GetDocumentFinanceYearSerieTerminal(Session pSession, Guid pDocumentType, Guid pLoggedTerminal)
{
DateTime currentDateTime = FrameworkUtils.CurrentDateTimeAtomic();
fin_documentfinanceyearserieterminal documentFinanceYearSerieTerminal = null;
fin_documentfinancetype documentFinanceType = (fin_documentfinancetype)FrameworkUtils.GetXPGuidObject(pSession, typeof(fin_documentfinancetype), pDocumentType);
//If DocumentTypeInvoiceWayBill Replace/Override Helper Document Type InvoiceWayBill with InvoiceWay to get Invoice Serie,
//this way we have Invoice Serie but DocumentMaster keeps DocumentFinanceType has DocumentFinanceTypeInvoiceWayBill
//Usefull for Future Documents WayBill distinct code, ex have WayBill, ex Re-Print Documents in WayBillMode etc
Guid documentFinanceTypeSerieGuid = (documentFinanceType.Oid == SettingsApp.XpoOidDocumentFinanceTypeInvoiceWayBill)
? SettingsApp.XpoOidDocumentFinanceTypeInvoice
: documentFinanceType.Oid
;
//Get Document Serie
SortingCollection sortCollection = new SortingCollection();
sortCollection.Add(new SortProperty("FiscalYear", DevExpress.Xpo.DB.SortingDirection.Ascending));
CriteriaOperator criteria = CriteriaOperator.Parse(string.Format("(Disabled = 0 OR Disabled IS NULL) AND DocumentType == '{0}'", documentFinanceTypeSerieGuid.ToString()));
ICollection collectionDocumentFinanceSeries = pSession.GetObjects(pSession.GetClassInfo(typeof(fin_documentfinanceyearserieterminal)), criteria, sortCollection, int.MaxValue, false, true);
foreach (fin_documentfinanceyearserieterminal item in collectionDocumentFinanceSeries)
{
if (currentDateTime.Year >= item.FiscalYear.FiscalYear)
{
if (item.Terminal.Oid == pLoggedTerminal)
{
documentFinanceYearSerieTerminal = item;
}
}
}
return(documentFinanceYearSerieTerminal);
}
public UI_Sesion_Recauda(DevExpress.XtraBars.BarButtonItem opcionMenu, DevExpress.XtraBars.BarHeaderItem headerMenu, object objetoExtra, object objetoExtra1, object objetoExtra2, object objetoExtra3, object objetoExtra4)
{
WaitForm1 WaitForm1 = new WaitForm1();
DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(WaitForm1, typeof(WaitForm1), false, false, false);
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Sesiones Activas...");
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Espere un momento por favor... Cargando y Validando Datos... .");
//
InitializeComponent();
this.SetStyle(ControlStyles.ResizeRedraw, true);
//
OpcionMenu = opcionMenu;
HeaderMenu = headerMenu;
ObjetoExtra = objetoExtra;
ObjetoExtra1 = objetoExtra1;
ObjetoExtra2 = objetoExtra2;
ObjetoExtra3 = objetoExtra3;
ObjetoExtra4 = objetoExtra4;
lHeader_ant = HeaderMenu.Caption;
// llena los datos de colecciones //
CriteriaOperator filtro_sesiones = (new OperandProperty("status") == new OperandValue(1)) | (new OperandProperty("status") == new OperandValue(2)) | (new OperandProperty("status") == new OperandValue(3)) | (new OperandProperty("status") == new OperandValue(5));
sesiones = new DevExpress.Xpo.XPCollection <Fundraising_PTDM.FUNDRAISING_PT.Sesiones>(DevExpress.Xpo.XpoDefault.Session, true);
orden_sesiones = new DevExpress.Xpo.SortingCollection(new DevExpress.Xpo.SortProperty("id_sesion", DevExpress.Xpo.DB.SortingDirection.Descending));
// bindeo de datos al bindingsource principal //
string_filter_principal = Fundraising_PT.Properties.Settings.Default.sucursal_filter + " and (" + filtro_sesiones.ToString().Trim() + ")";
bindingSource1.DataSource = sesiones;
sesiones.CriteriaString = string_filter_principal;
sesiones.Sorting = orden_sesiones;
sesiones.BeginLoad(true);
}
public override SortingCollection GetSorting()
{
SortingCollection sorting = new SortingCollection();
return(sorting);
}
public static int GetMaxId()
{
//Session session = new Session();
//session.ConnectionString = XpoDefault.ConnectionString;
// Obtain the persistent object class info required by the GetObjects method
XPClassInfo dstnClass = XpoDefault.Session.GetClassInfo(typeof(DataStore));
// Create criteria to get objects
CriteriaOperator criteria = null; // new BinaryOperator("Discontinued", true);
// Create a sort list if objects must be processed in a specific order
SortingCollection sortProps = null; // new SortingCollection(null);
// sortProps.Add(new SortProperty("Price", DevExpress.Xpo.DB.SortingDirection.Ascending));
// Create criteria patcher to filter out the objects marked as "deleted"
// and to support loading of inherited objects of a given base persistent class
CollectionCriteriaPatcher patcher = new DevExpress.Xpo.Generators.CollectionCriteriaPatcher(false, XpoDefault.Session.TypesManager);
// Call GetObjects
ICollection collection = XpoDefault.Session.GetObjects(dstnClass, criteria, sortProps, 0, patcher, true);
int max = int.MinValue;
// Do processing
foreach (DataStore dstn in collection)
{
max = Math.Max(max, dstn.Id);
}
return(max);
}
//Check if Document has SaftDocumentType Parent (Recursively)
public static bool IsDocumentMasterChildOfDocumentType(FIN_DocumentFinanceMaster pDocumentFinanceMaster, SaftDocumentType pSaftDocumentType)
{
bool debug = false;
bool result = false;
List <Guid> documentFinanceTypeList = new List <Guid>();
CriteriaOperator criteriaOperator = CriteriaOperator.Parse(string.Format("(Disabled = 0 OR Disabled is NULL) AND (SaftDocumentType = {0})", (int)pSaftDocumentType));
SortingCollection sortingCollection = new SortingCollection();
sortingCollection.Add(new SortProperty("Ord", SortingDirection.Ascending));
XPCollection xpcDocumentFinanceType = GetXPCollectionFromCriteria(GlobalFramework.SessionXpo, typeof(FIN_DocumentFinanceType), criteriaOperator, sortingCollection);
try
{
foreach (FIN_DocumentFinanceType item in xpcDocumentFinanceType)
{
if (debug)
{
_log.Debug(string.Format("Add DocumentFinanceType: [{0}]", item.Designation));
}
documentFinanceTypeList.Add(item.Oid);
}
if (documentFinanceTypeList.Count > 0)
{
result = IsDocumentMasterChildOfDocumentType(pDocumentFinanceMaster, documentFinanceTypeList);
}
}
catch (Exception ex)
{
_log.Error(ex.Message, ex);
}
return(result);
}
public XPCollection <PlanningMemo> GetAll(Int64 planningId, DateTime date)
{
try
{
XPCollection <PlanningMemo> planningMemos = new XPCollection <PlanningMemo>(Session);
XPCollection <PlanningMemo> planningMemosTwo = new XPCollection <PlanningMemo>(Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", DevExpress.Xpo.DB.SortingDirection.Ascending));
planningMemos.Sorting = sc;
foreach (PlanningMemo memo in planningMemos)
{
if (memo.Planning != planningId || memo.PlanningMemoDate.Date != date.Date)
{
planningMemosTwo.Remove(memo);
}
}
return(planningMemosTwo);
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public XPCollection <Job> GetAll(Int64 planningId, DateTime date)
{
try
{
//List<Job> jobs = new XPCollection<Job>(Session).OrderBy(bc => bc.Id).ToList();
//TODO: Find better fix
var jobs = new XPCollection <Job>(this.Session);
var jobsTwo = new XPCollection <Job>(this.Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", SortingDirection.Ascending));
jobs.Sorting = sc;
foreach (Job job in jobs)
{
if (job.Planning != planningId || job.JobDate.Date != date.Date)
{
jobsTwo.Remove(job);
}
}
return(jobsTwo);
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public void SPCBRPsoriasisInitializeAikode()
{
XPCollection <DataPasien> queryaikode = new XPCollection <DataPasien>(Session);
SortingCollection sort = new SortingCollection();
sort.Add(new SortProperty("kodepasien", SortingDirection.Ascending));
queryaikode.Sorting = sort;
foreach (DataPasien theRow in queryaikode)
{
this.Aikode = (Int32.Parse(theRow.kodepasien.Substring(1)) + 1).ToString();
}
if (this.Aikode.Length == 1)
{
this.KodePasien = "P000" + this.Aikode;
}
else if (this.Aikode.Length == 2)
{
this.KodePasien = "P00" + this.Aikode;
}
else if (this.Aikode.Length == 3)
{
this.KodePasien = "P0" + this.Aikode;
}
else
{
this.KodePasien = "P" + this.Aikode;
}
}
internal static SerializedUnit GetLastReturnForType(Session session, SerializedUnit unit)
{
ICollection serializedReturns;
XPClassInfo serializedClass;
GroupOperator criteria;
BinaryOperator op1;
BinaryOperator op2;
BinaryOperator op3;
SortingCollection sortProps;
SerializedUnit m_lastReturn = null;
serializedClass = session.GetClassInfo <SerializedUnit>();
op1 = new BinaryOperator("EndIdent", unit.InitIdent);
op2 = new BinaryOperator("ReturnType", unit.ReturnType);
op3 = new BinaryOperator("Item.Shopfloorline", unit.Item.Shopfloorline);
criteria = new GroupOperator(op1, op2, op3);
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("ReturnDate", SortingDirection.Descending));
serializedReturns = session.GetObjects(serializedClass, criteria, sortProps, 1, false, true);
foreach (SerializedUnit serializedReturn in serializedReturns)
{
m_lastReturn = serializedReturn;
}
return(m_lastReturn);
}
void IQueryVisitor.Visit(SortingCollection sorting)
{
_isFirstItem = true;
foreach (var sd in sorting)
{
sd.Accept(this);
}
}
public static Category[] List()
{
SortingCollection sc = new SortingCollection();
sc.Add(Category.Properties.Name);
return(Category.Search(null, sc));
}
public static Department[] List()
{
SortingCollection sc = new SortingCollection();
sc.Add(Department.Properties.Name);
return(Department.Search(null, sc));
}
private void btnTestIncomeProdRoute_Execute(object sender, SimpleActionExecuteEventArgs e)
{
ProdRoute pRoute = (ProdRoute)View.CurrentObject;
SortingCollection sortProps;
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("CreatedDate", SortingDirection.Ascending));
pRoute.ProdRouteLists.Sorting = sortProps;
Dictionary<ProdRouteList, float> dictListIn = new Dictionary<ProdRouteList, float>();
System.Collections.ArrayList arrayOut = new System.Collections.ArrayList();
System.Collections.ArrayList arrayIn = new System.Collections.ArrayList();
foreach (ProdRouteList prList in pRoute.ProdRouteLists)
{
if (prList.Qty > 0)
arrayOut.Add(prList);
else
{
arrayIn.Add(prList);
dictListIn.Add(prList, 0);
}
}
StringBuilder sbLog = new StringBuilder();
foreach(ProdRouteList prListOut in arrayOut)
{
float outQty = prListOut.Qty ;
foreach(ProdRouteList prListIn in arrayIn)
{
float inQty = dictListIn[prListIn];
float inBal = Math.Abs(prListIn.Qty) - inQty;
if (inBal > 0)
{
if (outQty > inBal)
{
sbLog.AppendLine(string.Format("Start Date : {0}, End Date : {1}, Qty : {2}", prListOut.Date, prListIn.Date, inBal));
outQty = outQty - inBal;
dictListIn[prListIn] = Math.Abs(prListIn.Qty);
}
else
{
sbLog.AppendLine(string.Format("Start Date : {0}, End Date : {1}, Qty : {2}", prListOut.Date, prListIn.Date, outQty));
dictListIn[prListIn] = dictListIn[prListIn] + outQty;
outQty = 0;
break;
}
}
}
}
MessageBox.Show(sbLog.ToString());
}
public override SortingCollection GetSorting()
{
SortingCollection sorting = new SortingCollection();
// if (SortByName) {
sorting.Add(new SortProperty("DocDate", SortingDirection.Descending));
// }
return(sorting);
}
public QueryPaggedBase <TItem, TResult> AddSorting(Expression <Func <TItem, object> > memberSelector, bool desc = false)
{
if (_sorting == null)
{
_sorting = new SortingCollection();
}
_sorting.Add(SortingDescriptor.Get(memberSelector, desc));
return(this);
}
/// <summary>
/// Resgata o Colaborador Logado
/// </summary>
/// <param name="session">Session</param>
/// <returns>Lista de Colaboradores</returns>
public static XPCollection <Colaborador> GetColaboradores(Session session)
{
SortingCollection sortCollection = new SortingCollection();
sortCollection.Add(new SortProperty("Usuario.FullName", SortingDirection.Ascending));
XPCollection <Colaborador> result = new XPCollection <Colaborador>(session);
result.Sorting.Add(sortCollection);
return(result);
}
public static Item[] ListByCategory(int categoryId)
{
ConditionCollection cc = new ConditionCollection();
cc.Add(Item.Properties.CategoryId, categoryId);
SortingCollection sc = new SortingCollection();
sc.Add(Item.Properties.Description);
return(Item.Search(cc, sc));
}
void IQueryVisitor.Visit(SortingCollection sorting)
{
for (int i = 0; i < sorting.Count; ++i)
{
if (i > 0)
{
_bld.Append(", ");
}
sorting[i].Accept(this);
}
}
public IQueryable <T> ApplySorting(IQueryable <T> query, SortingCollection coll)
{
_query = query;
coll.Accept(this);
var res = _query;
_query = null;
return(res);
}
public override SortingCollection GetSorting()
{
SortingCollection sorting = new SortingCollection();
if (SortByName)
{
sorting.Add(new SortProperty("Category.Name", SortingDirection.Ascending));
//sorting.Add(new SortProperty("crmWorkPlan.Current.Supplier.Name", SortingDirection.Ascending));
}
return(sorting);
}
//XpoMode
public TreeViewDocumentFinanceYearSerieTerminal(Window pSourceWindow, XPGuidObject pDefaultValue, CriteriaOperator pXpoCriteria, Type pDialogType, GenericTreeViewMode pGenericTreeViewMode = GenericTreeViewMode.Default, GenericTreeViewNavigatorMode pGenericTreeViewNavigatorMode = GenericTreeViewNavigatorMode.Default)
{
//Init Vars
Type xpoGuidObjectType = typeof(FIN_DocumentFinanceYearSerieTerminal);
//Override Default Value with Parameter Default Value, this way we can have diferent Default Values for GenericTreeView
FIN_DocumentFinanceYearSerieTerminal defaultValue = (pDefaultValue != null) ? pDefaultValue as FIN_DocumentFinanceYearSerieTerminal : null;
//Override Default DialogType with Parameter Dialog Type, this way we can have diferent DialogTypes for GenericTreeView
Type typeDialogClass = (pDialogType != null) ? pDialogType : typeof(DialogDocumentFinanceYearSerieTerminal);
//Configure columnProperties
List <GenericTreeViewColumnProperty> columnProperties = new List <GenericTreeViewColumnProperty>();
columnProperties.Add(new GenericTreeViewColumnProperty("FiscalYear")
{
Title = Resx.global_fiscal_year, ChildName = "Designation"
});
//columnProperties.Add(new GenericTreeViewColumnProperty("DocumentType") { Title = Resx.global_documentfinanceseries_documenttype, ChildName = "Designation" });
//columnProperties.Add(new GenericTreeViewColumnProperty("Serie") { Title = Resx.global_documentfinance_series, ChildName = "Designation" });
columnProperties.Add(new GenericTreeViewColumnProperty("Designation")
{
Title = Resx.global_designation, Expand = true
});
columnProperties.Add(new GenericTreeViewColumnProperty("Terminal")
{
Title = Resx.global_configurationplaceterminal, ChildName = "Designation"
});
columnProperties.Add(new GenericTreeViewColumnProperty("UpdatedAt")
{
Title = Resx.global_record_date_updated, MinWidth = 150, MaxWidth = 150
});
//Configure Criteria/XPCollection/Model : Use Default Filter
CriteriaOperator criteria = (ReferenceEquals(pXpoCriteria, null)) ? CriteriaOperator.Parse("(Disabled = 0 OR Disabled IS NULL)") : pXpoCriteria;
//Init Collection
XPCollection xpoCollection = new XPCollection(GlobalFramework.SessionXpo, xpoGuidObjectType, criteria);
//Override default Sorting
SortingCollection sortingCollection = new SortingCollection();
sortingCollection.Add(new SortProperty("Terminal", DevExpress.Xpo.DB.SortingDirection.Ascending));
sortingCollection.Add(new SortProperty("Ord", DevExpress.Xpo.DB.SortingDirection.Ascending));
xpoCollection.Sorting = sortingCollection;
//Call Base Initializer
base.InitObject(
pSourceWindow, //Pass parameter
defaultValue, //Pass parameter
pGenericTreeViewMode, //Pass parameter
pGenericTreeViewNavigatorMode, //Pass parameter
columnProperties, //Created Here
xpoCollection, //Created Here
typeDialogClass //Created Here
);
}
public async Task <ActionResult> FreightSearchresult()
{
CriteriaOperator criteria = null;
SortingCollection sortProps = new SortingCollection();
sortProps.Add(new SortProperty("CreatedOn", DevExpress.Xpo.DB.SortingDirection.Descending));
string OriginCountry = !string.IsNullOrEmpty(Request.Params["OriginCountry"]) ? Request.Params["OriginCountry"] : "Germany";
string DestCountry = !string.IsNullOrEmpty(Request.Params["DestCountry"]) ? Request.Params["DestCountry"] : "Germany";
if (!string.IsNullOrEmpty(Request.Params["SearchByradius"]))
{
FreightsController freightsController = new FreightsController();
int srad = !string.IsNullOrEmpty(Request.Params["OriginRadius"]) ? int.Parse(Request.Params["OriginRadius"]) : 10;
int erad = !string.IsNullOrEmpty(Request.Params["DestRadius"]) ? int.Parse(Request.Params["DestRadius"]) : 10;
double slat = double.Parse(Request["startLat"]);
double slon = double.Parse(Request["startLon"]);
double elat = double.Parse(Request["endLat"]);
double elon = double.Parse(Request["endLon"]);
double sminlat = freightsController.MinLat(slat, srad);
double smaxlat = freightsController.MaxLat(slat, srad);
double sminlon = freightsController.MinLon(slon, srad, slat);
double smaxlon = freightsController.MaxLon(slon, srad, slat);
//Getting min and max geo coordinates for destination
double eminlat = freightsController.MinLat(elat, erad);
double emaxlat = freightsController.MaxLat(elat, erad);
double eminlon = freightsController.MinLon(elon, erad, elat);
double emaxlon = freightsController.MaxLon(elon, erad, elat);
criteria = CriteriaOperator.Parse("StartLat >= ? and StartLat <= ? and StartLon >= ? and StartLon <= ? and EndLat >= ? and EndLat <= ? and EndLon >= ? and EndLon >= ?",
sminlat, smaxlat, sminlon, smaxlon, eminlat, emaxlat, eminlon, emaxlon);
}
else if (!string.IsNullOrEmpty(Request.Params["OriginZip"]) && !string.IsNullOrEmpty(Request.Params["DestZip"]))
{
string OriginZip = Request.Params["OriginZip"];
string DestZip = Request.Params["DestZip"];
criteria = CriteriaOperator.Parse("StartLocationZip == ? and EndLocationZip== ? and StartLocationCountry== ? and EndLocationCountry == ?", OriginZip, DestZip, OriginCountry, DestCountry);
}
else if (!string.IsNullOrEmpty(Request.Params["OriginCity"]) && !string.IsNullOrEmpty(Request.Params["DestCity"]))
{
string OriginCity = Request.Params["OriginCity"];
string DestCity = Request.Params["DestCity"];
criteria = CriteriaOperator.Parse("StartLocationCountry== ? and EndLocationCountry == ? and StartCity==? and EndCity==?", OriginCountry, DestCountry, OriginCity, DestCity);
}
else
{
criteria = CriteriaOperator.Parse("StartLocationCountry== ? and EndLocationCountry == ? ", OriginCountry, DestCountry);
}
var model = uow.GetObjects(uow.GetClassInfo(typeof(Freight)), criteria, sortProps, 50, false, false);
return(PartialView("~/Views/Freights/_GridViewPartial.cshtml", model));
}
public DBCollection(XPCollection collection)
: this(collection.Session, collection.ObjectType, collection.Criteria)
{
var sortProperties = new SortProperty[collection.Sorting.Count];
for (int i = 0; i < collection.Sorting.Count; i++)
{
SortProperty sortProperty = collection.Sorting[i];
sortProperties[i] = new SortProperty(sortProperty.PropertyName, sortProperty.Direction);
}
Sorting = new SortingCollection(this, sortProperties);
}
private void AddRecipientByRankGroupAction_Execute(object sender, PopupWindowShowActionExecuteEventArgs e)
{
Announcement currentAnnouncement = (Announcement)View.CurrentObject;
View.ObjectSpace.SetModified(currentAnnouncement);
foreach (RankGroup selected in e.PopupWindow.View.SelectedObjects)
{
ICollection tempEmployee;
DevExpress.Xpo.Metadata.XPClassInfo employeeClass;
DevExpress.Data.Filtering.CriteriaOperator criteria;
DevExpress.Xpo.SortingCollection sortProps;
DevExpress.Xpo.Session session;
DevExpress.Xpo.Generators.CollectionCriteriaPatcher patcher;
session = currentAnnouncement.Session;
//session.ConnectionString = XpoDefault.ConnectionString;
// Obtain the persistent object class info required by the GetObjects method
employeeClass = session.GetClassInfo(typeof(Employee));
// Create criteria to get objects
criteria = CriteriaOperator.Parse("StructuralPosition.RankGroup.Oid = ? And IsActive = true", selected.Oid);
// Create a sort list if objects must be processed in a specific order
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("FirstName", DevExpress.Xpo.DB.SortingDirection.Ascending));
// Create criteria patcher to filter out the objects marked as "deleted"
// and to support loading of inherited objects of a given base persistent class
patcher = new DevExpress.Xpo.Generators.CollectionCriteriaPatcher(false, session.TypesManager);
// Call GetObjects
//tempEmployee = session.GetObjects(employeeClass, criteria, sortProps, 0, patcher, selectDeleted:false, force: false);
tempEmployee = session.GetObjects(employeeClass, criteria, sortProps, 0, 0, false, true);
foreach (Employee emp in tempEmployee)
{
if (emp.IsActive == true)
{
Employee nEmp = ObjectSpace.GetObjectByKey <Employee>(emp.Oid);
AnnouncementRecepients nRec = new AnnouncementRecepients(currentAnnouncement.Session);
nRec.Employee = nEmp;
nRec.Email = nEmp.CorporateEmail;
currentAnnouncement.AnnouncementRecepients.Add(nRec);
}
}
}
if (View is DetailView && ((DetailView)View).ViewEditMode == ViewEditMode.View)
{
View.ObjectSpace.CommitChanges();
}
}
public void GenerateComboBox()
{
XPCollection<Customer> customers = new XPCollection<Customer>(uow);
SortingCollection sorting = new SortingCollection();
sorting.Add(new SortProperty("No", DevExpress.Xpo.DB.SortingDirection.Ascending));
customers.Sorting = sorting;
foreach (Customer customer in customers)
{
cboCustomer.Properties.Items.Add(customer.No);
dictCustomer.Add(customer.No, customer);
}
}
public QueryPaggedBase <TItem, TResult> AddSorting(string field, bool desc = false)
{
if (_sorting == null)
{
_sorting = new SortingCollection();
}
_sorting.Add(new SortingDescriptor()
{
Field = field, Desc = desc
});
return(this);
}
void dialog_Accepting(object sender, DevExpress.ExpressApp.SystemModule.DialogControllerAcceptingEventArgs e)
{
var session = _ParamObj.Session;
var sortProps = new SortingCollection(null);
var cop = CriteriaOperator.Parse("TranDate Between(?,?)",
_ParamObj.FromDate, _ParamObj.ToDate);
var cashFlows = session.GetObjects(session.GetClassInfo(typeof(CashFlow)),
cop, sortProps, 0, false, true);
ExcelWorksheet ws = Package.Workbook.Worksheets["Data"];
ExcelReportHelper.CopyObjectsToWorksheet(session, cashFlows, ws);
var reportSheet = Package.Workbook.Worksheets["Report"];
session.CommitTransaction();
}
public XPCollection <Vacation> GetAllChronological()
{
try
{
XPCollection <Vacation> vacations = new XPCollection <Vacation>(Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Date", DevExpress.Xpo.DB.SortingDirection.Ascending));
vacations.Sorting = sc;
return(vacations);
}
catch (Exception ex)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, ex);
}
}
public XPCollection<PlanningMemo> GetAll()
{
try
{
XPCollection<PlanningMemo> planningMemos = new XPCollection<PlanningMemo>(Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", DevExpress.Xpo.DB.SortingDirection.Ascending));
planningMemos.Sorting = sc;
return planningMemos;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
protected override Object RecreateCollection(CriteriaOperator criteria, SortingCollection sortings) {
XPClassInfo objectClassInfo = null;
if (XafTypesInfo.XpoTypeInfoSource.TypeIsKnown(ObjectTypeInfo.Type))
{
objectClassInfo = XafTypesInfo.XpoTypeInfoSource.GetEntityClassInfo(ObjectTypeInfo.Type);
}
if (objectClassInfo != null)
{
serverCollection = new XPServerCollectionSource(this.ObjectSpace.Session, objectClassInfo, criteria);
}
else
{
serverCollection = new XPServerCollectionSource(this.ObjectSpace.Session, this.ObjectTypeInfo.Type, criteria);
}
SetDisplayablePropertiesToCollection();
return serverCollection;
}
private BindingList<ProdOrderP> CalcProdOrderPs(Session session)
{
UnitOfWork uow = (UnitOfWork)session;
Vendor vendor = session.FindObject<Vendor>(new BinaryOperator("No", "NWC"));
WareHouse defaultWH = session.FindObject<WareHouse>(CriteriaOperator.Parse("WarehouseName == 'KP'"));
XPClassInfo poLineClass;
CriteriaOperator criteria;
SortingCollection sortProps;
poLineClass = uow.GetClassInfo(typeof(PurchOrderLine));
criteria = CriteriaOperator.Parse(string.Format("Vendor.Oid = '{0}' AND OrderStatus = '{1}' ", vendor.Oid, PurchOrderLine.PurchOrderStatus.Active));
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("NeedDate", SortingDirection.Descending));
ICollection poLines = uow.GetObjects(poLineClass, criteria, sortProps, int.MaxValue, false, true);
BindingList<ProdOrderP> ProdOrderPs = new BindingList<ProdOrderP>();
Dictionary<string, float> dictWHQty = new Dictionary<string, float>();
Dictionary<string, float> dictProdOrderQty;
dictProdOrderQty = GetDictProdOrderQty(uow);
// dictProdOrderQty.Add(WorkCenterNo-PartNo-Status)
foreach (PurchOrderLine poLine in poLines)
{
ProdOrderP pop = new ProdOrderP(uow);
pop.SetDefaultWH(defaultWH);
pop.SetPurchOrderLine(poLine);
pop.SetupRouteList();
pop.SetDictWH(dictWHQty);
pop.SetDictProdOrderQty(dictProdOrderQty);
pop.CalcNeed();
ProdOrderPs.Add(pop);
}
return ProdOrderPs;
}
private void btnIssue_Click(object sender, EventArgs e)
{
float remainQty;
float remainDefectQty;
txtItemNo.Text = txtItemNo.Text.Trim();
try
{
remainQty = float.Parse(txtQty.Text);
remainDefectQty = float.Parse(txtDefectQty.Text);
if (remainQty == 0 && remainDefectQty == 0)
{
XtraMessageBox.Show("请输入正确的良品数或不良品数");
txtQty.SelectAll();
return;
}
if (remainQty > float.Parse(txtCanShipQty.Text ) || remainDefectQty > float.Parse(txtCanShipDefectQty.Text))
{
XtraMessageBox.Show("输入的良品数或不良品数不能大于可派单数");
txtQty.SelectAll();
return;
}
}
catch
{
XtraMessageBox.Show("请输入正确的良品数或不良品数");
txtQty.SelectAll();
return;
}
uow = new UnitOfWork();
XPCollection<SubPurchOrderLine> poLines = new XPCollection<SubPurchOrderLine>(uow);
SortingCollection sortProps;
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("NeedDate", SortingDirection.Ascending));
poLines.Criteria = CriteriaOperator.Parse(string.Format("OrderStatus == '{0}' AND SubItem.ItemNo = '{1}'", SubPurchOrderLine.PurchOrderStatus.Active, txtItemNo.Text));
poLines.Sorting = sortProps;
poReceives = new List<SubPurchOrderReceive>();
float poBal = 0;
uow.BeginTransaction();
foreach (SubPurchOrderLine poLine in poLines)
{
SubPurchOrderReceive poReceive = new SubPurchOrderReceive(uow);
poReceive.PurchOrderLine = poLine;
poBal = poLine.BalQty;
if (poBal > remainQty)
{
poReceive.Qty = remainQty;
poBal = poBal - remainQty;
remainQty = 0;
}
else
{
poReceive.Qty = poBal;
remainQty = remainQty - poBal;
poBal = 0;
}
if (poBal > remainDefectQty)
{
poReceive.DefectQty = remainDefectQty;
poBal = poBal - remainDefectQty;
remainDefectQty = 0;
}
else
{
poReceive.DefectQty = poBal;
remainDefectQty = remainDefectQty - poBal;
poBal = 0;
}
poReceive.Save();
poReceive.Post();
poReceives.Add(poReceive);
if (remainQty == 0 && remainDefectQty == 0)
break;
}
uow.CommitChanges();
txtRemainQty.Text = remainQty.ToString();
txtRemainDefectQty.Text = remainDefectQty.ToString();
gridPurchOrderReceive.DataSource = poReceives;
btnPrint.Enabled = true;
}
private void btnIssueCMSO_Click(object sender, EventArgs e)
{
txtItemNo.Text = txtItemNo.Text.Trim();
txtSalesOrderNo.Text = txtSalesOrderNo.Text.Trim();
txtQty.Text = txtQty.Text.Trim();
if (txtItemNo.Text == "" || txtSalesOrderNo.Text == "" || txtQty.Text == "0")
{
txtMessage.Text = "错误!! 请输入销售单号 , 产品编码 及 数量 !";
PlayErrorSound();
return;
}
UnitOfWork uow = new UnitOfWork();
XPCollection<SalesOrderLine> SalesOrderLines = new XPCollection<SalesOrderLine>(uow);
SalesOrderLines.Criteria = CriteriaOperator.Parse(string.Format("CustomerItemNo == '{0}' AND SalesOrder.OrderNo == '{1}' AND OrderStatus == '{2}' ", txtItemNo.Text.Trim(), txtSalesOrderNo.Text.Trim(), SalesOrderLine.SalesOrderStatus.Active));
SortingCollection sorting = new SortingCollection();
ShipmentSetting sSetting = ShipmentSetting.GetInstance(uow);
if (sSetting.SortBy == ShipmentSetting.SortType.DatePriority)
{
sorting.Add(new SortProperty("NeedDate", DevExpress.Xpo.DB.SortingDirection.Ascending));
sorting.Add(new SortProperty("Priority", DevExpress.Xpo.DB.SortingDirection.Descending));
}
else
{
sorting.Add(new SortProperty("Priority", DevExpress.Xpo.DB.SortingDirection.Descending));
sorting.Add(new SortProperty("NeedDate", DevExpress.Xpo.DB.SortingDirection.Ascending));
}
SalesOrderLines.Sorting = sorting;
float shipQty = float.Parse(txtQty.Text);
uow.BeginTransaction();
foreach (SalesOrderLine soLine in SalesOrderLines)
{
if (soLine.LackQty > 0)
{
if (soLine.LackQty >= shipQty)
{
Shipment so = soLine.CreateShipment(uow, shipQty);
if (so != null)
{
so.ChangeStatusToReady();
shipQty = 0;
break;
}
}
else
{
float tmpLackQty = soLine.LackQty;
Shipment so = soLine.CreateShipment(uow, soLine.LackQty);
if (so != null)
{
so.ChangeStatusToReady();
shipQty = shipQty - tmpLackQty;
}
}
}
}
uow.CommitTransaction();
if (shipQty == 0)
{
PlayOKSound();
txtMessage.Text = "OK";
}
else
{
PlayErrorSound();
txtMessage.Text = string.Format("还有余数{0}", shipQty);
}
RefreshShipment();
}
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 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 GenerateProdRouteListActivity(ProdRouteList prListOriginal, UnitOfWork uow)
{
ProdRoute pRoute = prListOriginal.ProdRoute;
SortingCollection sortProps;
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("CreatedDate", SortingDirection.Ascending));
pRoute.ProdRouteLists.Sorting = sortProps;
Dictionary<ProdRouteList, float> dictListIn = new Dictionary<ProdRouteList, float>();
TimeSpan timeDiff;
System.Collections.ArrayList arrayOut = new System.Collections.ArrayList();
System.Collections.ArrayList arrayIn = new System.Collections.ArrayList();
foreach (ProdRouteList prList in pRoute.ProdRouteLists)
{
if (prList.Qty > 0)
arrayOut.Add(prList);
else
{
arrayIn.Add(prList);
dictListIn.Add(prList, 0);
}
}
foreach (ProdRouteList prListOut in arrayOut)
{
float outQty = prListOut.Qty;
ProdRouteListActivity prlActivity;
foreach (ProdRouteList prListIn in arrayIn)
{
float inQty = dictListIn[prListIn];
float inBal = Math.Abs(prListIn.Qty) - inQty;
if (inBal > 0)
{
if (outQty > inBal)
{
if (prListIn == prListOriginal)
{
prlActivity = new ProdRouteListActivity(uow);
prlActivity.StartDate = prListOut.Date;
prlActivity.EndDate = prListIn.Date;
prlActivity.ProdRoute = pRoute;
prlActivity.Qty = inBal;
timeDiff = prlActivity.EndDate.Subtract(prlActivity.StartDate);
prlActivity.WorkDay = (int)timeDiff.TotalDays;
if (pRoute.Item.ColorCode != null)
{
if (prlActivity.WorkDay > pRoute.ProdOrder.Item.ColorCode.DefaultSampleLT)
prlActivity.Status = ProdRouteListActivity.ActivityStatus.Fail;
}
prlActivity.Save();
}
outQty = outQty - inBal;
dictListIn[prListIn] = Math.Abs(prListIn.Qty);
}
else
{
if (prListIn == prListOriginal)
{
prlActivity = new ProdRouteListActivity(uow);
prlActivity.StartDate = prListOut.Date;
prlActivity.EndDate = prListIn.Date;
prlActivity.ProdRoute = pRoute;
prlActivity.Qty = outQty;
timeDiff = prlActivity.EndDate.Subtract(prlActivity.StartDate);
prlActivity.WorkDay = (int)timeDiff.TotalDays;
if (pRoute.Item.ColorCode != null)
{
if (prlActivity.WorkDay > pRoute.ProdOrder.Item.ColorCode.DefaultSampleLT)
prlActivity.Status = ProdRouteListActivity.ActivityStatus.Fail;
}
prlActivity.Save();
}
dictListIn[prListIn] = dictListIn[prListIn] + outQty;
outQty = 0;
break;
}
}
}
}
}
public BindingList<woPurchOrder> CalcWoPurchOrder(Session _session)
{
XPClassInfo woClass;
CriteriaOperator criteria;
SortingCollection sortProps;
_fromWareHouse = StoreWH;
session = _session;
UnitOfWork uow = (UnitOfWork)session;
woClass = uow.GetClassInfo(typeof(WorkOrder));
if (this.WorkOrder == null)
criteria = CriteriaOperator.Parse("WorkOrderNo >= '0'");
else
criteria = CriteriaOperator.Parse("WorkOrderNo >= '" + this.WorkOrder.WorkOrderNo + "'");
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("WorkOrderNo", SortingDirection.Ascending));
ICollection workOrders = uow.GetObjects(woClass, criteria, sortProps, int.MaxValue, false, true);
BindingList<woPurchOrder> woPurchOrders = new BindingList<woPurchOrder>();
Dictionary<string, float> dictWHQty = new Dictionary<string, float>();
foreach (WorkOrder wo in workOrders)
{
if (wo.WorkOrderNo.StartsWith("WoHistory") == false)
{
if (wo.NeedQty - wo.ExtraQty > 0 )
this.CalcWoPurchOrderLine(woPurchOrders, dictWHQty, wo, wo.Item, wo.NeedQty - wo.ExtraQty, wo.Item.Source, 1, 1, 0, 0);
}
}
return woPurchOrders;
}
private void initLUE()
{
UnitOfWork uow2 = new UnitOfWork();
XPCollection<Project> projects = new XPCollection<Project>(uow2);
SortingCollection sortProps2 = new SortingCollection(null);
sortProps2.Add(new SortProperty("No", SortingDirection.Descending));
projects.Sorting = sortProps2;
lueProject.Properties.DataSource = projects;
lueProject.Properties.ValueMember = "This";
lueProject.Properties.DisplayMember = "No";
XPCollection<OrderType> orderTypes = new XPCollection<OrderType>(uow2);
SortingCollection sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("Name", SortingDirection.Ascending));
orderTypes.Sorting = sortProps;
lueOrderType1.Properties.DataSource = orderTypes;
lueOrderType1.Properties.ValueMember = "Name";
lueOrderType1.Properties.DisplayMember = "Name";
lueOrderType2.Properties.DataSource = orderTypes;
lueOrderType2.Properties.ValueMember = "Name";
lueOrderType2.Properties.DisplayMember = "Name";
lueOrderType3.Properties.DataSource = orderTypes;
lueOrderType3.Properties.ValueMember = "Name";
lueOrderType3.Properties.DisplayMember = "Name";
lueOrderType4.Properties.DataSource = orderTypes;
lueOrderType4.Properties.ValueMember = "Name";
lueOrderType4.Properties.DisplayMember = "Name";
lueOrderType5.Properties.DataSource = orderTypes;
lueOrderType5.Properties.ValueMember = "Name";
lueOrderType5.Properties.DisplayMember = "Name";
}
private Dictionary<string, float> GetDictProdOrderQty(UnitOfWork uow)
{
string key = "";
Dictionary<string, float> dictProdOrderQty = new Dictionary<string, float>();
#region Get Waiting Qty
XPCollection<ProdOrder> prodOrders = new XPCollection<ProdOrder>(uow, CriteriaOperator.Parse(string.Format("OrderStatus = '{0}' || OrderStatus = '{1}'", ProdOrder.ProdOrderStatus.Waiting, ProdOrder.ProdOrderStatus.Calculated)));
foreach (ProdOrder prodOrder in prodOrders)
{
ProdRoute pRoute = prodOrder.GetFirstProdRoute();
if (pRoute != null)
{
key = pRoute.WorkCenter.WorkCenterNo + "-" + prodOrder.Item.ItemNo + "-" + ProdOrder.ProdOrderStatus.Waiting;
if (dictProdOrderQty.ContainsKey(key))
dictProdOrderQty[key] = dictProdOrderQty[key] + prodOrder.NeedQty;
else
dictProdOrderQty.Add(key, prodOrder.NeedQty);
}
}
#endregion
#region Get Active Qty
XPClassInfo prodRouteClass;
CriteriaOperator criteria;
SortingCollection sortProps;
prodRouteClass = uow.GetClassInfo(typeof(ProdRoute));
criteria = CriteriaOperator.Parse(string.Format("ProdOrder.OrderStatus = '{0}'", ProdOrder.ProdOrderStatus.Active));
sortProps = new SortingCollection(null);
ICollection prodRoutes = uow.GetObjects(prodRouteClass, criteria, sortProps, int.MaxValue, false, true);
foreach (ProdRoute prodRoute in prodRoutes)
{
key = prodRoute.WorkCenter.WorkCenterNo + "-" + prodRoute.Item.ItemNo + "-" + ProdOrder.ProdOrderStatus.Active;
if (dictProdOrderQty.ContainsKey(key))
dictProdOrderQty[key] = dictProdOrderQty[key] + prodRoute.WipQty;
else
dictProdOrderQty.Add(key, prodRoute.WipQty);
}
#endregion
return dictProdOrderQty;
}
private BindingList<PurchOrder_Receive> CalcPurchOrderLine(Session session)
{
BindingList<PurchOrder_Receive> poReceives = new BindingList<PurchOrder_Receive>();
XPClassInfo poLineClass;
CriteriaOperator criteria;
SortingCollection sortProps;
StringBuilder sbCriteria = new StringBuilder();
sbCriteria.Append(string.Format("OrderStatus = '{0}'", PurchOrderLine.PurchOrderStatus.Active));
if (txtItemNo.Text != "")
sbCriteria.Append(string.Format(" AND Item.ItemNo = '{0}'", txtItemNo.Text));
if (txtVendor.Text != "")
sbCriteria.Append(string.Format(" AND Vendor.No = '{0}'", txtVendor.Text));
poLineClass = session.GetClassInfo(typeof(PurchOrderLine));
criteria = CriteriaOperator.Parse(sbCriteria.ToString());
sortProps = new SortingCollection(null);
ICollection poLines = session.GetObjects(poLineClass, criteria, sortProps, int.MaxValue, false, true);
foreach (PurchOrderLine poLine in poLines)
{
PurchOrder_Receive poReceive = new PurchOrder_Receive();
poReceive.PurchOrderLine = poLine;
poReceive.Item = poLine.Item;
poReceive.ItemType = poLine.Item.ItemType;
poReceive.ReceivedWarehouse = poLine.Warehouse;
poReceives.Add(poReceive);
}
return poReceives;
}
private void gridView1_ShownEditor(object sender, EventArgs e)
{
woPurchOrder woPurchOrder = (woPurchOrder)gridView1.GetFocusedRow();
if (gridView1.FocusedColumn.FieldName == "Vendor")
{
LookUpEdit lueVendor;
lueVendor = (LookUpEdit)gridView1.ActiveEditor;
if (chkShowAllVendor.Checked == true)
{
XPCollection<Vendor> vendors = new XPCollection<Vendor>(uow);
SortingCollection sCollection = new SortingCollection();
sCollection.Add(new SortProperty("No", DevExpress.Xpo.DB.SortingDirection.Ascending));
vendors.Sorting = sCollection;
lueVendor.Properties.DataSource = vendors;
}
else
{
lueVendor.Properties.DataSource = woPurchOrder.BomItem.AvailVendor;
}
}
}
public DBCollection(XPCollection collection)
: this(collection.Session, collection.ObjectType, collection.Criteria)
{
var sortProperties = new SortProperty[collection.Sorting.Count];
for (int i = 0; i < collection.Sorting.Count; i++)
{
SortProperty sortProperty = collection.Sorting[i];
sortProperties[i] = new SortProperty(sortProperty.PropertyName, sortProperty.Direction);
}
Sorting = new SortingCollection(this, sortProperties);
}
protected XPCollection<SalesOrderLine> GetSoLines()
{
//return SalesOrderLine.GetOpenSalesOrderLine(uow, null, DateTime.Today.AddYears(100));
XPCollection<SalesOrderLine> soLines = new XPCollection<SalesOrderLine>(uow);
StringBuilder sbCriteria = new StringBuilder();
sbCriteria.Append(string.Format(" ( OrderStatus = '{0}' OR OrderStatus = '{1}') ", SalesOrderLine.SalesOrderStatus.Active, SalesOrderLine.SalesOrderStatus.Waiting));
soLines.Criteria = CriteriaOperator.Parse(sbCriteria.ToString());
SortingCollection sCollection = new SortingCollection();
ShipmentSetting setting = ShipmentSetting.GetInstance(uow);
if (setting.SortBy == ShipmentSetting.SortType.PriorityDate)
{
sCollection.Add(new SortProperty("Priority", DevExpress.Xpo.DB.SortingDirection.Descending));
sCollection.Add(new SortProperty("NeedDate", DevExpress.Xpo.DB.SortingDirection.Ascending));
}
else
{
sCollection.Add(new SortProperty("NeedDate", DevExpress.Xpo.DB.SortingDirection.Ascending));
sCollection.Add(new SortProperty("Priority", DevExpress.Xpo.DB.SortingDirection.Descending));
}
soLines.Sorting = sCollection;
return soLines;
}
private void InitLUE()
{
UnitOfWork uow = new UnitOfWork();
XPCollection<Customer> customers = new XPCollection<Customer>(uow);
SortingCollection sortProps3 = new SortingCollection(null);
sortProps3.Add(new SortProperty("No", SortingDirection.Descending));
customers.Sorting = sortProps3;
lueCustomer.Properties.DataSource = customers;
lueCustomer.Properties.ValueMember = "No";
lueCustomer.Properties.DisplayMember = "No";
XPClassInfo classInfo = uow.GetClassInfo(typeof(Item));
XPServerCollectionSource items = new XPServerCollectionSource(uow, classInfo);
SortingCollection sortProps2 = new SortingCollection(null);
sortProps2.Add(new SortProperty("ItemNo", SortingDirection.Descending));
//items.Sorting = sortProps2;
lueItem1.Properties.DataSource = items;
lueItem1.Properties.ValueMember = "This";
lueItem1.Properties.DisplayMember = "ItemNo";
lueItem2.Properties.DataSource = items;
lueItem2.Properties.ValueMember = "This";
lueItem2.Properties.DisplayMember = "ItemNo";
lueItem3.Properties.DataSource = items;
lueItem3.Properties.ValueMember = "This";
lueItem3.Properties.DisplayMember = "ItemNo";
lueItem4.Properties.DataSource = items;
lueItem4.Properties.ValueMember = "This";
lueItem4.Properties.DisplayMember = "ItemNo";
lueItem5.Properties.DataSource = items;
lueItem5.Properties.ValueMember = "This";
lueItem5.Properties.DisplayMember = "ItemNo";
lueItem6.Properties.DataSource = items;
lueItem6.Properties.ValueMember = "This";
lueItem6.Properties.DisplayMember = "ItemNo";
lueItem7.Properties.DataSource = items;
lueItem7.Properties.ValueMember = "This";
lueItem7.Properties.DisplayMember = "ItemNo";
lueItem8.Properties.DataSource = items;
lueItem8.Properties.ValueMember = "This";
lueItem8.Properties.DisplayMember = "ItemNo";
lueItem9.Properties.DataSource = items;
lueItem9.Properties.ValueMember = "This";
lueItem9.Properties.DisplayMember = "ItemNo";
XPCollection<OrderType> orderTypes = new XPCollection<OrderType>(uow);
SortingCollection sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("Name", SortingDirection.Ascending));
orderTypes.Sorting = sortProps;
lueOrderType1.Properties.DataSource = orderTypes;
lueOrderType1.Properties.ValueMember = "Name";
lueOrderType1.Properties.DisplayMember = "Name";
lueOrderType2.Properties.DataSource = orderTypes;
lueOrderType2.Properties.ValueMember = "Name";
lueOrderType2.Properties.DisplayMember = "Name";
lueOrderType3.Properties.DataSource = orderTypes;
lueOrderType3.Properties.ValueMember = "Name";
lueOrderType3.Properties.DisplayMember = "Name";
lueOrderType4.Properties.DataSource = orderTypes;
lueOrderType4.Properties.ValueMember = "Name";
lueOrderType4.Properties.DisplayMember = "Name";
lueOrderType5.Properties.DataSource = orderTypes;
lueOrderType5.Properties.ValueMember = "Name";
lueOrderType5.Properties.DisplayMember = "Name";
lueOrderType6.Properties.DataSource = orderTypes;
lueOrderType6.Properties.ValueMember = "Name";
lueOrderType6.Properties.DisplayMember = "Name";
lueOrderType7.Properties.DataSource = orderTypes;
lueOrderType7.Properties.ValueMember = "Name";
lueOrderType7.Properties.DisplayMember = "Name";
lueOrderType8.Properties.DataSource = orderTypes;
lueOrderType8.Properties.ValueMember = "Name";
lueOrderType8.Properties.DisplayMember = "Name";
lueOrderType9.Properties.DataSource = orderTypes;
lueOrderType9.Properties.ValueMember = "Name";
lueOrderType9.Properties.DisplayMember = "Name";
}
public XPCollection<BoardComputer> GetAll()
{
try
{
XPCollection<BoardComputer> boardcomputers = new XPCollection<BoardComputer>(Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", DevExpress.Xpo.DB.SortingDirection.Ascending));
boardcomputers.Sorting = sc;
return boardcomputers;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public XPCollection<Job> GetAll()
{
try
{
//List<Job> jobs = new XPCollection<Job>(Session).OrderBy(bc => bc.Id).ToList();
var jobs = new XPCollection<Job>(this.Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", SortingDirection.Ascending));
jobs.Sorting = sc;
return jobs;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
protected override object RecreateCollection(CriteriaOperator criteria, SortingCollection sortings)
{
if (Query!= null)
return linqCollectionHelper.ConvertQueryToCollection(Query);
return base.RecreateCollection(criteria, sortings);
}
public static void CreateLabel(DateTime startDate, UnitOfWork uow)
{
SubPurchOrderReceiveLabel.DeleteAllLabel(uow);
int DefaultBoxQty = SubItemSetting.GetInstance(uow, SubItem.SubItemType.QC).DefaultBoxQty;
XPCollection<SubPurchOrderReceive> poReceives = new XPCollection<SubPurchOrderReceive>(uow);
poReceives.Criteria = CriteriaOperator.Parse(string.Format("CreatedDate >= #{0}#", startDate));
SortingCollection sortProps;
sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("PurchOrderLine.SubItem", SortingDirection.Ascending));
poReceives.Sorting = sortProps;
for (int i = 0; i < poReceives.Count; i++)
{
SubPurchOrderReceive poReceive = poReceives[i];
poReceive.CreateLabel(DefaultBoxQty);
}
}
public override SortingCollection GetSorting()
{
SortingCollection sorting = new SortingCollection();
return sorting;
}
public XPCollection<Job> GetAll(Int64 planningId, DateTime date)
{
try
{
//List<Job> jobs = new XPCollection<Job>(Session).OrderBy(bc => bc.Id).ToList();
//TODO: Find better fix
var jobs = new XPCollection<Job>(this.Session);
var jobsTwo = new XPCollection<Job>(this.Session);
SortingCollection sc = new SortingCollection();
sc.Add(new SortProperty("Id", SortingDirection.Ascending));
jobs.Sorting = sc;
foreach (Job job in jobs)
{
if (job.Planning != planningId || job.JobDate.Date != date.Date)
jobsTwo.Remove(job);
}
return jobsTwo;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
private void lueProject_EditValueChanged(object sender, EventArgs e)
{
if (lueProject.EditValue == null)
return;
Project project = (Project)lueProject.EditValue;
txtBrand.EditValue = project.Brand.Name;
txtDescription.EditValue = project.Description;
txtLaunchDate.EditValue = project.LaunchDate.ToString("yyyy-MM-dd");
txtLot.EditValue = project.Lot.LotNo;
txtProjectName.EditValue = project.Name;
UnitOfWork uow = new UnitOfWork();
XPCollection<Style> styles = new XPCollection<Style>(uow);
styles.Criteria = CriteriaOperator.Parse(string.Format("Project.Oid == '{0}' ", project.Oid));
styles2 = new BindingList<Namwah.Module.BO_NONPersistent.style>();
SortingCollection sortProps = new SortingCollection(null);
sortProps.Add(new SortProperty("ProjectLineNo", SortingDirection.Ascending));
styles.Sorting = sortProps;
foreach (Style style in styles)
{
Namwah.Module.BO_NONPersistent.style style2 = new Namwah.Module.BO_NONPersistent.style();
style2.Selected = true;
style2.Style = style;
styles2.Add(style2);
}
gridStyle.DataSource = styles2;
btnPost.Enabled = true;
uow = null;
}
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 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);
}
}
void IQueryVisitor.Visit(SortingCollection sorting)
{
for (int i = 0; i < sorting.Count; ++i)
{
if (i > 0)
_bld.Append(", ");
sorting[ i ].Accept(this);
}
}
public void BuildSortExpression(StringBuilder bld, SortingCollection coll)
{
_bld = bld;
coll.Accept(this);
_bld = null;
}