public ActionResult UpdateMeasurementUnit(MeasurementUnits UNitDetails) { try { MeasurementUnits measurement = new MeasurementUnits(); measurement = db.MeasurementUnits.Find(UNitDetails.MeasurementUnitID); measurement.UpdateBy = AppUtils.GetLoginUserID(); measurement.UpdateDate = AppUtils.GetDateTimeNow(); measurement.UnitName = UNitDetails.UnitName; db.Entry(measurement).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); var measurementUnit = new CustomMeasuremetUnit() { MeasurementUnitID = UNitDetails.MeasurementUnitID, UnitName = UNitDetails.UnitName, UpdateMeasurementUnit = ISP_ManagementSystemModel.AppUtils.HasAccessInTheList(ISP_ManagementSystemModel.AppUtils.Update_Attendance_Type) ? true : false, }; var JSON = Json(new { UpdateSuccess = true, Units = measurementUnit }, JsonRequestBehavior.AllowGet); JSON.MaxJsonLength = int.MaxValue; return(JSON); } catch (Exception ex) { return(Json(new { UpdateSuccess = false, EMPLH = "" }, JsonRequestBehavior.AllowGet)); } }
public void LoadFromFile() { //string address = Directory.GetCurrentDirectory() + @"\VTOLVR_ModLoader\mods\Bananas_Per_Second"; string address = ModFolder; Debug.Log("Checking for: " + address); if (Directory.Exists(address)) { Debug.Log(address + " exists!"); try { Debug.Log("Checking for: " + address + @"\units.json"); string temp = File.ReadAllText(address + @"\units.json"); units = JsonConvert.DeserializeObject <MeasurementUnits>(temp); } catch { Debug.Log("no json found, making one"); File.WriteAllText(address + @"\units.json", JsonConvert.SerializeObject(units)); } } else { Debug.Log("Mod folder not found? Make sure the name of the mod folder is \"Bananas_Per_Second\""); } }
private void ExecuteDelete(object parameter) { int _id = ((Models.MeasurementUnitModel)parameter).ID; if (_id != 0) { int ctr = DatabaseQueries.CountUsedID(CountSPName.CountUsedMeasurementUnitID, _id); IMessageBoxService _msgbox = new MessageBoxService(); if (ctr > 0) { _msgbox.ShowMessage(((Models.MeasurementUnitModel)parameter).MeasurementUnit + " is assigned to an Asset and cannot be deleted", "Cannot Delete", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Asterisk); // _canexecutedelete = false; } else if (_msgbox.ShowMessage("Do you want to delete " + ((Models.MeasurementUnitModel)parameter).MeasurementUnit + "?", "Delete Measurement Unit", GenericMessageBoxButton.OKCancel, GenericMessageBoxIcon.Question) == GenericMessageBoxResult.OK) { MeasurementUnits.Remove((Models.MeasurementUnitModel)parameter); DatabaseQueries.DeleteItem(_id, DeleteSPName.DeleteMeasurementUnit); } _msgbox = null; } else { MeasurementUnits.Remove((Models.MeasurementUnitModel)parameter); } }
private void LoadComboBox() { MeasurementUnits listMeasurementUnits = new MeasurementUnits(); cbbMeasurementUnit.DataSource = listMeasurementUnits.ListMeasurementUnits(); cbbMeasurementUnit.DisplayMember = "Name"; cbbMeasurementUnit.ValueMember = "Id"; }
/// <summary> /// Запрос выбирающий количество добавленное на склад, отгруженное со склада /// и зарезервированное в заказах каждой номенклатуры по выбранному типу оборудования /// </summary> public static QueryOver <Nomenclature, Nomenclature> QueryAvailableNonSerialEquipmentForRent(EquipmentType type) { Nomenclature nomenclatureAlias = null; WarehouseMovementOperation operationAddAlias = null; //Подзапрос выбирающий по номенклатуре количество добавленное на склад var subqueryAdded = QueryOver.Of <WarehouseMovementOperation>(() => operationAddAlias) .Where(() => operationAddAlias.Nomenclature.Id == nomenclatureAlias.Id) .Where(Restrictions.IsNotNull(Projections.Property <WarehouseMovementOperation>(o => o.IncomingWarehouse))) .Select(Projections.Sum <WarehouseMovementOperation>(o => o.Amount)); //Подзапрос выбирающий по номенклатуре количество отгруженное со склада var subqueryRemoved = QueryOver.Of <WarehouseMovementOperation>(() => operationAddAlias) .Where(() => operationAddAlias.Nomenclature.Id == nomenclatureAlias.Id) .Where(Restrictions.IsNotNull(Projections.Property <WarehouseMovementOperation>(o => o.WriteoffWarehouse))) .Select(Projections.Sum <WarehouseMovementOperation>(o => o.Amount)); //Подзапрос выбирающий по номенклатуре количество зарезервированное в заказах до отгрузки со склада Vodovoz.Domain.Orders.Order localOrderAlias = null; OrderEquipment localOrderEquipmentAlias = null; Equipment localEquipmentAlias = null; var subqueryReserved = QueryOver.Of <Vodovoz.Domain.Orders.Order>(() => localOrderAlias) .JoinAlias(() => localOrderAlias.OrderEquipments, () => localOrderEquipmentAlias) .JoinAlias(() => localOrderEquipmentAlias.Equipment, () => localEquipmentAlias) .Where(() => localEquipmentAlias.Nomenclature.Id == nomenclatureAlias.Id) .Where(() => localOrderEquipmentAlias.Direction == Direction.Deliver) .Where(() => localOrderAlias.OrderStatus == OrderStatus.Accepted || localOrderAlias.OrderStatus == OrderStatus.InTravelList || localOrderAlias.OrderStatus == OrderStatus.OnLoading) .Select(Projections.Sum(() => localOrderEquipmentAlias.Count)); NomenclatureForRentVMNode resultAlias = null; MeasurementUnits unitAlias = null; EquipmentType equipmentType = null; //Запрос выбирающий количество добавленное на склад, отгруженное со склада //и зарезервированное в заказах каждой номенклатуры по выбранному типу оборудования var query = QueryOver.Of <Nomenclature>(() => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Unit, () => unitAlias) .JoinAlias(() => nomenclatureAlias.Type, () => equipmentType); if (type != null) { query = query.Where(() => nomenclatureAlias.Type.Id == type.Id); } query = query.SelectList(list => list .SelectGroup(() => nomenclatureAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => equipmentType.Id).WithAlias(() => resultAlias.TypeId) .Select(() => unitAlias.Name).WithAlias(() => resultAlias.UnitName) .Select(() => unitAlias.Digits).WithAlias(() => resultAlias.UnitDigits) .SelectSubQuery(subqueryAdded).WithAlias(() => resultAlias.Added) .SelectSubQuery(subqueryRemoved).WithAlias(() => resultAlias.Removed) .SelectSubQuery(subqueryReserved).WithAlias(() => resultAlias.Reserved) ) .TransformUsing(Transformers.AliasToBean <NomenclatureForRentVMNode>()); return(query); }
private void ribbonButton2_Click(object sender, EventArgs e) { Application.DoEvents(); selectedUnit = (MeasurementUnits)Enum.Parse(typeof(MeasurementUnits),((RibbonButton)sender).Text,true); NuGenMediImageCtrl ngMediImage = (NuGenMediImageCtrl)parent; ngMediImage.MeasurementUnits = selectedUnit; Application.DoEvents(); this.Close(); }
private void ExecuteAddNew(object parameter) { _canexecuteadd = false; MeasurementUnits.Add(new Models.MeasurementUnitModel()); SelectedItemIndex = MeasurementUnits.Count - 1; ScrollToLastItem = true; MeasurementUnitsListEnabled = false; AssetLabel = newassetlabel; CloseBtnLabel = _cancellabel; }
public IProductPrice Create(MeasurementUnits _MeasurementUnit, decimal _Price, IProduct _Product) { var entity = new ProductPrice() { MeasurementUnit = _MeasurementUnit, Price = _Price, Product = _Product }; return(entity); }
private void ribbonButton2_Click(object sender, EventArgs e) { Application.DoEvents(); selectedUnit = (MeasurementUnits)Enum.Parse(typeof(MeasurementUnits), ((RibbonButton)sender).Text, true); NuGenMediImageCtrl ngMediImage = (NuGenMediImageCtrl)parent; ngMediImage.MeasurementUnits = selectedUnit; Application.DoEvents(); this.Close(); }
internal static void RefreshTabWater(Panel_FeedFire panel) { MeasurementUnits units = InterfaceManager.m_Panel_OptionsMenu.m_State.m_Units; panel.m_Label_PotableSupply.text = Utils.GetLiquidQuantityStringNoOunces(units, WATER.ActualPotable) + "/" + Utils.GetLiquidQuantityStringWithUnitsNoOunces(units, WATER.CapacityPotable); panel.m_Label_NonpotableSupply.text = Utils.GetLiquidQuantityStringNoOunces(units, WATER.ActualNonPotable) + "/" + Utils.GetLiquidQuantityStringWithUnitsNoOunces(units, WATER.CapacityNonPotable); labelEmptyCapacity.text = Utils.GetLiquidQuantityStringWithUnitsNoOunces(units, WATER.CapacityEmpty); panel.m_Texture_InspectItem.gameObject.SetActive(Cookware != null); panel.m_Texture_GearItem.alpha = 0.25f; }
public SettingsViewModel(INavigationService navigationService, ISettingsService settingsService) : base(navigationService) { _settingsService = settingsService; PropertyChanged += OnSettingsViewModelPropertyChanged; //TODO: Glenn - Translate enums! MeasurementUnits.Add(DistanceUnitType.Kilometres.ToString()); MeasurementUnits.Add(DistanceUnitType.Miles.ToString()); SortTypes.Add(ActivitySort.StartTime.ToString()); SortTypes.Add(ActivitySort.EndTime.ToString()); }
private void LoadDropdowlist() { Ingredients Listingredients = new Ingredients(); DropDownListIngredient.DataSource = Listingredients.ListAll(); DropDownListIngredient.DataTextField = "Name"; DropDownListIngredient.DataValueField = "ID"; DropDownListIngredient.DataBind(); MeasurementUnits measurementUnits = new MeasurementUnits(); DropDownListMeasurementUnit.DataSource = measurementUnits.ListMeasurementUnits(); DropDownListMeasurementUnit.DataTextField = "Name"; DropDownListMeasurementUnit.DataValueField = "ID"; DropDownListMeasurementUnit.DataBind(); DifficultieRanges difficultieRanges = new DifficultieRanges(); DropDownListRecipeDifficulty.DataSource = difficultieRanges.ListAllDifficutyRanges(); DropDownListRecipeDifficulty.DataTextField = "Difficulty"; DropDownListRecipeDifficulty.DataValueField = "IdDifficulty"; DropDownListRecipeDifficulty.DataBind(); TimesToMake timesToMake = new TimesToMake(); DropDownListTimeToMake.DataSource = timesToMake.ListAllTimesToMake(); DropDownListTimeToMake.DataTextField = "Time"; DropDownListTimeToMake.DataValueField = "IdTimeToMake"; DropDownListTimeToMake.DataBind(); CostRanges costRanges = new CostRanges(); DropDownListCostRange.DataSource = costRanges.ListAllCostRanges(); DropDownListCostRange.DataTextField = "Cost"; DropDownListCostRange.DataValueField = "IDcost"; DropDownListCostRange.DataBind(); CuisineTypes cuisineTypes = new CuisineTypes(); DropDownListCuisineType.DataSource = cuisineTypes.ListAllCuisineType(); DropDownListCuisineType.DataTextField = "CuisineTypeName"; DropDownListCuisineType.DataValueField = "IdCuisine"; DropDownListCuisineType.DataBind(); DishCategories dishCategories = new DishCategories(); CheckBoxListCategory.DataSource = dishCategories.ListAllDishCategories(); CheckBoxListCategory.DataTextField = "DishCategoryName"; CheckBoxListCategory.DataValueField = "DishCategoryID"; CheckBoxListCategory.DataBind(); }
private static double ConverToCelsius(double temperature, MeasurementUnits measurementUnit) { if (measurementUnit == MeasurementUnits.Fahrenheit) { return(5.0 / 9.0 * (temperature - 32)); } if (measurementUnit == MeasurementUnits.Kelvin) { return(temperature - 273.15); } return(temperature); }
private static double ConverFromCelsius(double temperature, MeasurementUnits measurementUnit) { if (measurementUnit == MeasurementUnits.Fahrenheit) { return(9.0 / 5.0 * temperature + 32); } if (measurementUnit == MeasurementUnits.Kelvin) { return(temperature + 273.15); } return(temperature); }
public async Task <string> ImportAsync(string fileId, MeasurementUnits measurementUnits, string callbackUrl = null) { var url = "web-api/operation/import"; var requestData = new ImportRequest { FileId = fileId, MeasurementUnits = measurementUnits.ToString(), CallbackUrl = callbackUrl }; var result = await PostOperationAsync(url, requestData); return(result); }
private void ExecuteCancel(object parameter) { if (!_canexecuteadd) { _canexecuteadd = true; MeasurementUnitsListEnabled = true; AssetLabel = selectedassetlabel; CloseBtnLabel = _closelabel; MeasurementUnits.Remove(MeasurementUnit); } else { DialogResult = false; CloseWindow(); } }
public ActionResult DeleteMeasurement(int MeasurementUnitID) { MeasurementUnits measureUnit = new MeasurementUnits(); measureUnit = db.MeasurementUnits.Find(MeasurementUnitID); measureUnit.DeleteBy = AppUtils.GetLoginUserID(); measureUnit.DeleteDate = AppUtils.GetDateTimeNow(); measureUnit.Status = AppUtils.TableStatusIsDelete; db.Entry(measureUnit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); var JSON = Json(new { DeleteSuccess = true, measureUnitID = measureUnit.MeasurementUnitID }, JsonRequestBehavior.AllowGet); JSON.MaxJsonLength = int.MaxValue; return(JSON); }
public static IList <SubdivisionRecivedInfo> ItemsBalance(IUnitOfWork uow, Subdivision subdivision) { if (subdivision.Id == 0) //Если подразделение не сохранено возвращаем пустой лист. { return(new List <SubdivisionRecivedInfo>()); } SubdivisionRecivedInfo resultAlias = null; SubdivisionIssueOperation subdivisionIssueOperationAlias = null; Nomenclature nomenclatureAlias = null; ItemsType itemsTypeAlias = null; MeasurementUnits measurementUnitsAlias = null; SubdivisionPlace subdivisionPlaceAlias = null; IProjection projection = Projections.Sum(Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.Int32, "IFNULL(?1, 0) - IFNULL(?2, 0)"), NHibernateUtil.Int32, Projections.Property <SubdivisionIssueOperation>(x => x.Issued), Projections.Property <SubdivisionIssueOperation>(x => x.Returned) )); var incomeList = uow.Session.QueryOver <SubdivisionIssueOperation>(() => subdivisionIssueOperationAlias) .Where(x => x.Subdivision == subdivision) .JoinAlias(() => subdivisionIssueOperationAlias.Nomenclature, () => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Type, () => itemsTypeAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin) .JoinAlias(() => itemsTypeAlias.Units, () => measurementUnitsAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin) .JoinAlias(() => subdivisionIssueOperationAlias.SubdivisionPlace, () => subdivisionPlaceAlias, NHibernate.SqlCommand.JoinType.LeftOuterJoin) .SelectList(list => list .SelectGroup(() => nomenclatureAlias.Id).WithAlias(() => resultAlias.NomenclatureId) .SelectGroup(() => subdivisionIssueOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) .SelectGroup(() => subdivisionIssueOperationAlias.SubdivisionPlace.Id).WithAlias(() => resultAlias.PlaceId) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomeclatureName) .Select(() => subdivisionPlaceAlias.Name).WithAlias(() => resultAlias.Place) .SelectMax(() => subdivisionIssueOperationAlias.OperationTime).WithAlias(() => resultAlias.LastReceive) .Select(projection).WithAlias(() => resultAlias.Amount) ) .Where(Restrictions.Gt(projection, 0)) .TransformUsing(Transformers.AliasToBean <SubdivisionRecivedInfo>()) .List <SubdivisionRecivedInfo>(); return(incomeList); }
public ActionResult <DeviceSettings> GetDeviceInfo(string deviceName, MeasurementUnits units = MeasurementUnits.Default) { // we have had to replace \ with || to get past cors checking, so reinstate \ (NB: we are assuming || is rare in a printer name!) deviceName = deviceName.Replace("||", "\\"); _logger.LogInformation("GET api/v1/printhtml/deviceinfo/{deviceName}/{units}", deviceName, units); if (!HandleAuthentication()) { return(Unauthorized()); } if (string.CompareOrdinal(deviceName, "default") != 0 && string.CompareOrdinal(deviceName, "Test printer") != 0 && string.CompareOrdinal(deviceName, "A3 Printer") != 0) { return(NotFound()); } if (string.CompareOrdinal(deviceName, "default") == 0) { return(new DeviceSettings { PrinterName = "Test printer", IsDefault = true, PaperSizeName = "A4" }); } if (string.CompareOrdinal(deviceName, "systemdefault") == 0) { return(new DeviceSettings { PrinterName = "Test system default printer", IsDefault = true, PaperSizeName = "A4" }); } return(new DeviceSettings { PrinterName = deviceName, PaperSizeName = "A5", Forms = new string[] { "A3", "A4", "A5" }, Bins = new string[] { "Upper", "Lower" }, Attributes = 1, Collate = BooleanOption.False, Duplex = Duplex.Default, IsLocal = true, PaperSourceName = "Upper", Status = 0, Copies = 1, }); }
public SettingsViewModel(INavigationService navigationService, ISettingsService settingsService, IOService ioService, IMessenger messenger) : base(navigationService, messenger) { _settingsService = settingsService; _ioService = ioService; PropertyChanged += OnSettingsViewModelPropertyChanged; IncrementNumberRounder rounder = new IncrementNumberRounder(); rounder.Increment = 0.01; rounder.RoundingAlgorithm = RoundingAlgorithm.RoundHalfUp; _decimalFormat.NumberRounder = rounder; //TODO: Glenn - Translate enums! MeasurementUnits.Add(DistanceUnitType.Kilometres.ToString()); MeasurementUnits.Add(DistanceUnitType.Miles.ToString()); SortTypes.Add(ActivitySort.StartTime.ToString()); SortTypes.Add(ActivitySort.EndTime.ToString()); }
private void AddType(string name, MeasurementUnits units, string[] keyWords) { var type = ItemsTypes.FirstOrDefault(x => x.Name == name); if (type == null) { type = new ItemsType { Name = name, Category = ItemTypeCategory.property, Units = units }; ItemsTypes.Add(type); } TypeDescription desc = new TypeDescription(type); foreach (var word in keyWords) { KeyWords.Add(word.ToLower(), desc); } }
public override void ModLoaded() { HarmonyInstance harmony = HarmonyInstance.Create("cheese.bananas"); harmony.PatchAll(Assembly.GetExecutingAssembly()); Debug.Log("bananas"); base.ModLoaded(); units = new MeasurementUnits(); units.measurementDistUnits = new List <MeasurementDistUnit>(); units.measurementDistUnits.Add(new MeasurementDistUnit("Meters", 1, "m")); units.measurementDistUnits.Add(new MeasurementDistUnit("NautMiles", 0.000539957f, "nm")); units.measurementDistUnits.Add(new MeasurementDistUnit("Feet", 3.28084f, "ft")); units.measurementDistUnits.Add(new MeasurementDistUnit("Miles", 0.000621371f, "mi")); units.measurementDistUnits.Add(new MeasurementDistUnit("Bananas", 5.618f, "bns")); units.measurementDistUnits.Add(new MeasurementDistUnit("Ierdnas", 0.59880239521f, "i")); units.measurementAltUnits = new List <MeasurementAltUnit>(); units.measurementAltUnits.Add(new MeasurementAltUnit("Meters", 1, "m")); units.measurementAltUnits.Add(new MeasurementAltUnit("Feet", 3.28084f, "ft")); units.measurementAltUnits.Add(new MeasurementAltUnit("Bananas", 5.618f, "bns")); units.measurementAltUnits.Add(new MeasurementAltUnit("Ierdnas", 0.59880239521f, "i")); units.measurementSpeedUnits = new List <MeasurementSpeedUnit>(); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("MetersPerSecond", 1, "m/s")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("KilometersPerHour", 3.6f, "KPH")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("Knots", 1.94384f, "kt")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("MilesPerHour", 2.23694f, "MPH")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("FeetPerSecond", 3.28084f, "ft/s")); //units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("Mach", 0.00291545f, "M")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("BananasPerSecond", 5.618f, "BPS")); units.measurementSpeedUnits.Add(new MeasurementSpeedUnit("IerdnasPerSecond", 0.59880239521f, "I/S")); LoadFromFile(); }
private void DrawIOCAImage(Container imc, List <ImageInfo> images, float xStartingInch, float yStartingInch, PrintPageEventArgs e) { // Each container may hold one image or several, as tiles. Draw each one with consideration to its offset from the original draw point foreach (ImageInfo image in images) { // Get the positioning and scaling info based on the current object environment container OBD oaDescriptor = imc.GetStructure <OBD>(); OBP oaPosition = imc.GetStructure <OBP>(); if (oaDescriptor != null && oaPosition != null) { // Get sizing info triplets ObjectAreaSize oaSize = oaDescriptor.GetTriplet <ObjectAreaSize>(); MeasurementUnits mu = oaDescriptor.GetTriplet <MeasurementUnits>(); // Get inch origins based on unit scaling int xUnitOrigin = oaPosition.XOrigin + oaPosition.XContentOrigin; int yUnitOrigin = oaPosition.YOrigin + oaPosition.YContentOrigin; float xInchOrigin = xStartingInch + (float)(Converters.GetInches(xUnitOrigin, mu.XUnitsPerBase, mu.BaseUnit) * 100); float yInchOrigin = yStartingInch + (float)(Converters.GetInches(yUnitOrigin, mu.YUnitsPerBase, mu.BaseUnit) * 100); // Get inch scaling values double heightInches = Converters.GetInches((int)oaSize.YExtent, mu.YUnitsPerBase, mu.BaseUnit); // We have the inch value and number of pixels, so set DPI based on those values Bitmap bmp = new Bitmap(new MemoryStream(image.Data)); float dpi = (float)Math.Round(bmp.Height / heightInches); bmp.SetResolution(dpi, dpi); e.Graphics.DrawImage(bmp, xInchOrigin, yInchOrigin); } else { throw new NotImplementedException("Image could not be displayed - no OBD/OBP fields found."); } } }
public ActionResult <PrintHtmlDefaultSettings> GetHtmlPrintDefaults(MeasurementUnits units = MeasurementUnits.Default) { _logger.LogInformation("GET api/v1/printhtml/htmlPrintDefaults/{units}", units); if (!HandleAuthentication()) { return(Unauthorized()); } return(new PrintHtmlDefaultSettings { AvailablePrinters = new string[] { "A3 Printer", "Test printer" }, Device = new DeviceSettings { PrinterName = "Test printer", IsDefault = true, PaperSizeName = "A4", Forms = new string[] { "A3", "A4", "A5" }, Bins = new string[] { "Upper", "Lower" }, Attributes = 1, Collate = BooleanOption.False, Duplex = Duplex.Default, IsLocal = true, PaperSourceName = "Upper", Status = 0, Copies = 1 }, Settings = new HtmlPrintSettings { Header = "Default header from server", Footer = "Default footer from server", Page = new PageSettings { Orientation = PageOrientation.Landscape, Margins = { Bottom = "1", Left = "1", Right = "2", Top = "2" }, Units = MeasurementUnits.Inches }, ViewScale = -1, PrintBackgroundColorsAndImages = BooleanOption.True } }); }
public JsonResult InsertMeasurementUnit(MeasurementUnits measureUnit) { try { db.MeasurementUnits.Add(measureUnit); measureUnit.CreateBy = AppUtils.GetLoginUserID(); measureUnit.CreateDate = AppUtils.GetDateTimeNow(); measureUnit.Status = AppUtils.TableStatusIsActive; db.SaveChanges(); CustomMeasuremetUnit UnitInfo = new CustomMeasuremetUnit { MeasurementUnitID = measureUnit.MeasurementUnitID, UnitName = measureUnit.UnitName, UpdateMeasurementUnit = ISP_ManagementSystemModel.AppUtils.HasAccessInTheList(ISP_ManagementSystemModel.AppUtils.Update_Measurement_Unit) ? true : false, }; return(Json(new { SuccessInsert = true, UnitInfo = UnitInfo }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet)); } }
public Measurements() { this.valueList = new List<Measurement>(); this.units = new MeasurementUnits(); }
protected IQueryOver <WarehouseOperation> ItemsQuery(IUnitOfWork uow) { StockBalanceJournalNode resultAlias = null; WarehouseOperation warehouseExpenseOperationAlias = null; WarehouseOperation warehouseIncomeOperationAlias = null; WarehouseOperation warehouseOperationAlias = null; Nomenclature nomenclatureAlias = null; ItemsType itemTypesAlias = null; MeasurementUnits unitsAlias = null; Size sizeAlias = null; Size heightAlias = null; // null == null => null null <=> null => true var expenseQuery = QueryOver.Of(() => warehouseExpenseOperationAlias) .Where(() => warehouseExpenseOperationAlias.Nomenclature.Id == nomenclatureAlias.Id && (warehouseExpenseOperationAlias.WearSize.Id == sizeAlias.Id || warehouseOperationAlias.WearSize == null && sizeAlias == null) && (warehouseExpenseOperationAlias.Height.Id == heightAlias.Id || warehouseOperationAlias.Height == null && heightAlias == null) && warehouseExpenseOperationAlias.WearPercent == warehouseOperationAlias.WearPercent) .Where(e => e.OperationTime < Filter.Date.AddDays(1)); if (Filter.Warehouse == null) { expenseQuery.Where(x => x.ExpenseWarehouse != null); } else { expenseQuery.Where(x => x.ExpenseWarehouse == Filter.Warehouse); } expenseQuery.Select(Projections .Sum(Projections .Property(() => warehouseExpenseOperationAlias.Amount))); var incomeSubQuery = QueryOver.Of(() => warehouseIncomeOperationAlias) .Where(() => warehouseIncomeOperationAlias.Nomenclature.Id == nomenclatureAlias.Id && (warehouseIncomeOperationAlias.WearSize.Id == sizeAlias.Id || warehouseOperationAlias.WearSize == null && sizeAlias == null) && (warehouseIncomeOperationAlias.Height.Id == heightAlias.Id || warehouseOperationAlias.Height == null && heightAlias == null) && warehouseIncomeOperationAlias.WearPercent == warehouseOperationAlias.WearPercent) .Where(e => e.OperationTime < Filter.Date.AddDays(1)); if (Filter.Warehouse == null) { incomeSubQuery.Where(x => x.ReceiptWarehouse != null); } else { incomeSubQuery.Where(x => x.ReceiptWarehouse == Filter.Warehouse); } incomeSubQuery.Select(Projections .Sum(Projections .Property(() => warehouseIncomeOperationAlias.Amount))); var projection = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.Int32, "( IFNULL(?1, 0) - IFNULL(?2, 0) )"), NHibernateUtil.Int32, Projections.SubQuery(incomeSubQuery), Projections.SubQuery(expenseQuery) ); var queryStock = uow.Session.QueryOver(() => warehouseOperationAlias); queryStock.Where(Filter.ShowNegativeBalance ? Restrictions.Not(Restrictions.Eq(projection, 0)) : Restrictions.Gt(projection, 0)); if (Filter.ItemTypeCategory != null) { queryStock.Where(() => itemTypesAlias.Category == Filter.ItemTypeCategory); } //Если у нас выключена способность показывать общие по всем складам остатки. //Но не указан склад мы должны показывать пустую таблицу. //Это заведомо ложное условие. if (ShowSummary == false && Filter.Warehouse == null) { queryStock.Where(x => x.Id == -1); } if (Filter.ProtectionTools != null) { queryStock.Where(x => x.Nomenclature.IsIn(Filter.ProtectionTools.MatchedNomenclatures.ToArray())); } return(queryStock .JoinAlias(() => warehouseOperationAlias.Nomenclature, () => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Type, () => itemTypesAlias) .JoinAlias(() => itemTypesAlias.Units, () => unitsAlias) .JoinAlias(() => warehouseOperationAlias.WearSize, () => sizeAlias, JoinType.LeftOuterJoin) .JoinAlias(() => warehouseOperationAlias.Height, () => heightAlias, JoinType.LeftOuterJoin) .Where(GetSearchCriterion( () => nomenclatureAlias.Number, () => nomenclatureAlias.Name, () => sizeAlias.Name, () => heightAlias.Name)) .SelectList(list => list .SelectGroup(() => nomenclatureAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName) .Select(() => nomenclatureAlias.Number).WithAlias(() => resultAlias.NomenclatureNumber) .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName) .SelectGroup(() => sizeAlias.Name).WithAlias(() => resultAlias.SizeName) .SelectGroup(() => heightAlias.Name).WithAlias(() => resultAlias.HeightName) .SelectGroup(() => sizeAlias.Id).WithAlias(() => resultAlias.SizeId) .SelectGroup(() => heightAlias.Id).WithAlias(() => resultAlias.HeightId) .SelectGroup(() => warehouseOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) .Select(projection).WithAlias(() => resultAlias.Amount) ) .OrderBy(() => nomenclatureAlias.Name).Asc .ThenBy(Projections.SqlFunction( new SQLFunctionTemplate( NHibernateUtil.String, "CAST(SUBSTRING_INDEX(?1, '-', 1) AS DECIMAL(5,1))"), NHibernateUtil.String, Projections.Property(() => sizeAlias.Name))).Asc .ThenBy(Projections.SqlFunction( new SQLFunctionTemplate( NHibernateUtil.String, "CAST(SUBSTRING_INDEX(?1, '-', 1) AS DECIMAL(5,1))"), NHibernateUtil.String, Projections.Property(() => heightAlias.Name))).Asc .TransformUsing(Transformers.AliasToBean <StockBalanceJournalNode>())); }
private void ShowMeasurementResult(bool showLabel, ScaleLine.ScaleLineUnit outUnits) { showLabel = showLabel && CheckResultOnMap.IsChecked.Value; if (outUnits != ScaleLine.ScaleLineUnit.Undefined) { resultUnits = outUnits; } if (measurementMode == MODE_LENGTH && geometryService.LengthsLastResult != null) { // Length in meters double length = geometryService.LengthsLastResult[0] * UnitsHelper.GetConversionToMeter(resultUnits); // Length in selected units MeasurementUnits lenUnits = (ListLengthUnits.SelectedItem as ComboBoxItem).Tag as MeasurementUnits; TextLengthResult.Text = string.Format("{0}", Math.Round(length * lenUnits.Conversion, 3)); if (showLabel && this.GraphicsLayer.Graphics.Count > 0) { int k = this.GraphicsLayer.Graphics.Count - 1; ESRI.ArcGIS.Client.Geometry.Geometry geometry = this.GraphicsLayer.Graphics[k].Geometry; string label = string.Format("Length: {0} {1}", TextLengthResult.Text, lenUnits.Abbreviation); Graphic lblGraphic = new Graphic() { Geometry = geometry.Extent.GetCenter(), Symbol = new TextSymbol() { Text = label, OffsetX = 30, OffsetY = 15, FontSize = 12.0, FontFamily = new FontFamily("Arial Black"), Foreground = new SolidColorBrush(Color.FromArgb(0xFF, 0x00, 0x00, 0xFF)) } }; AddGraphic(lblGraphic); } } else if (measurementMode == MODE_AREA && geometryService.AreasAndLengthsLastResult != null) { // Length in meters double length = geometryService.AreasAndLengthsLastResult.Lengths[0] * UnitsHelper.GetConversionToMeter(resultUnits); // Area in square meters double area = Math.Abs(geometryService.AreasAndLengthsLastResult.Areas[0]) * Math.Pow(UnitsHelper.GetConversionToMeter(resultUnits), 2); // Length in selected units MeasurementUnits lenUnits = (ListLengthUnits.SelectedItem as ComboBoxItem).Tag as MeasurementUnits; TextLengthResult.Text = string.Format("{0}", Math.Round(length * lenUnits.Conversion, 3)); // Area in selected units MeasurementUnits areaUnits = (ListAreaUnits.SelectedItem as ComboBoxItem).Tag as MeasurementUnits; TextAreaResult.Text = string.Format("{0}", Math.Round(area * areaUnits.Conversion, 3)); if (showLabel && this.GraphicsLayer.Graphics.Count > 0) { int k = this.GraphicsLayer.Graphics.Count - 1; ESRI.ArcGIS.Client.Geometry.Geometry geometry = this.GraphicsLayer.Graphics[k].Geometry; string label = string.Format("Parimeter: {0} {1}\nArea: {2} {3}", TextLengthResult.Text, lenUnits.Abbreviation, TextAreaResult.Text, areaUnits.Abbreviation); Graphic lblGraphic = new Graphic() { Geometry = geometry.Extent.GetCenter(), Symbol = new TextSymbol() { Text = label, OffsetX = 50, OffsetY = 15, FontSize = 12.0, FontFamily = new FontFamily("Arial Black"), Foreground = new SolidColorBrush(Color.FromArgb(0xFF, 0x00, 0x00, 0x99)) } }; AddGraphic(lblGraphic); } } this.IsBusy = false; }
private void AddType(string name, СlothesType category, MeasurementUnits units, string[] keyWords, СlothesType?category2 = null, string[] keywords2 = null) { var type = ItemsTypes.FirstOrDefault(x => x.Name == name); if (type == null) { type = new ItemsType { Name = name, Category = ItemTypeCategory.wear, WearCategory = category, Units = units, }; switch (category) { case СlothesType.Wear: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер одежды"); type.HeightType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Рост"); break; case СlothesType.Shoes: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер обуви"); break; case СlothesType.WinterShoes: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер зимней обуви"); break; case СlothesType.Headgear: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер головного убора"); break; case СlothesType.Gloves: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер перчаток"); break; case СlothesType.Mittens: type.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер рукавиц"); break; } ItemsTypes.Add(type); } TypeDescription desc; if (category2 != null) { var type2 = new ItemsType { Name = name, Category = ItemTypeCategory.wear, WearCategory = category2.Value, Units = units }; switch (category) { case СlothesType.Wear: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер одежды"); type2.HeightType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Рост"); break; case СlothesType.Shoes: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер обуви"); break; case СlothesType.WinterShoes: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер зимней обуви"); break; case СlothesType.Headgear: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер головного убора"); break; case СlothesType.Gloves: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер перчаток"); break; case СlothesType.Mittens: type2.SizeType = sizeService.GetSizeType(uow).FirstOrDefault(x => x.Name == "Размер рукавиц"); break; } desc = new TypeDescription(type, type2, keywords2.Select(x => x.ToLower()).ToArray()); } else { desc = new TypeDescription(type); } foreach (var word in keyWords) { KeyWords.Add(word.ToLower(), desc); } }
public Measurements() { this.valueList = new List <Measurement>(); this.units = new MeasurementUnits(); }
public IQueryOver <SubdivisionIssueOperation> ItemsQuery(IUnitOfWork unitOfWork) { SubdivisionBalanceJournalNode resultAlias = null; SubdivisionIssueOperation issueOperationAlias = null; Nomenclature nomenclatureAlias = null; ItemsType itemTypesAlias = null; MeasurementUnits unitsAlias = null; SubdivisionIssueOperation removeIssueOperationAlias = null; WarehouseOperation warehouseOperationAlias = null; Subdivision subdivisionAlias = null; var expense = unitOfWork.Session.QueryOver(() => issueOperationAlias); if (Filter.Subdivision != null) { expense.Where(e => e.Subdivision == Filter.Subdivision); } var subQueryRemove = QueryOver.Of(() => removeIssueOperationAlias) .Where(() => removeIssueOperationAlias.IssuedOperation == issueOperationAlias) .Select(Projections.Sum <SubdivisionIssueOperation>(o => o.Returned)); var balance = Projections.SqlFunction( new SQLFunctionTemplate(NHibernateUtil.Int32, "( IFNULL(?1, 0) - IFNULL(?2, 0) )"), NHibernateUtil.Int32, Projections.Property(() => issueOperationAlias.Issued), Projections.SubQuery(subQueryRemove)); if (Filter.Subdivision != null) { expense .JoinAlias(() => issueOperationAlias.Nomenclature, () => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Type, () => itemTypesAlias) .JoinAlias(() => itemTypesAlias.Units, () => unitsAlias) .JoinAlias(() => issueOperationAlias.WarehouseOperation, () => warehouseOperationAlias) .JoinAlias(() => issueOperationAlias.Subdivision, () => subdivisionAlias) .Where(e => e.AutoWriteoffDate == null || e.AutoWriteoffDate > Filter.Date) .Where(Restrictions.Not(Restrictions.Eq(balance, 0))) .SelectList(list => list .SelectGroup(() => issueOperationAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName) .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName) .Select(() => issueOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) .Select(() => issueOperationAlias.OperationTime).WithAlias(() => resultAlias.IssuedDate) .Select(() => issueOperationAlias.ExpiryOn).WithAlias(() => resultAlias.ExpiryDate) .Select(() => subdivisionAlias.Name).WithAlias(() => resultAlias.SubdivisionName) .Select(balance).WithAlias(() => resultAlias.Balance)); } else { expense .JoinAlias(() => issueOperationAlias.Nomenclature, () => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Type, () => itemTypesAlias) .JoinAlias(() => itemTypesAlias.Units, () => unitsAlias) .JoinAlias(() => issueOperationAlias.WarehouseOperation, () => warehouseOperationAlias) .JoinAlias(() => issueOperationAlias.Subdivision, () => subdivisionAlias) .Where(e => e.AutoWriteoffDate == null || e.AutoWriteoffDate > Filter.Date) .Where(Restrictions.Not(Restrictions.Eq(balance, 0))) .SelectList(list => list .Select(() => issueOperationAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName) .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName) .Select(() => issueOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) .Select(() => issueOperationAlias.OperationTime).WithAlias(() => resultAlias.IssuedDate) .Select(() => issueOperationAlias.ExpiryOn).WithAlias(() => resultAlias.ExpiryDate) .Select(() => subdivisionAlias.Name).WithAlias(() => resultAlias.SubdivisionName) .Select(balance).WithAlias(() => resultAlias.Balance)); expense = expense.OrderBy(() => subdivisionAlias.Name).Asc; } return(expense.TransformUsing(Transformers.AliasToBean <SubdivisionBalanceJournalNode>())); }
protected IQueryOver <WarehouseOperation> ItemsQuery(IUnitOfWork uow) { StockMovmentsJournalNode resultAlias = null; WarehouseOperation warehouseOperationAlias = null; ExpenseItem expenseItemAlias = null; IncomeItem incomeItemAlias = null; TransferItem transferItemAlias = null; CollectiveExpenseItem collectiveExpenseItemAlias = null; WriteoffItem writeOffItemAlias = null; EmployeeCard employeeCardAlias = null; EmployeeIssueOperation employeeIssueOperationAlias = null; CompletionResultItem completionResultItemAlias = null; CompletionSourceItem completionSourceItemAlias = null; Nomenclature nomenclatureAlias = null; ItemsType itemTypesAlias = null; MeasurementUnits unitsAlias = null; Size sizeAlias = null; Size heightAlias = null; var queryStock = uow.Session.QueryOver(() => warehouseOperationAlias) .JoinAlias(() => warehouseOperationAlias.WearSize, () => sizeAlias, JoinType.LeftOuterJoin) .JoinAlias(() => warehouseOperationAlias.Height, () => heightAlias, JoinType.LeftOuterJoin); if (Filter.Warehouse != null) { queryStock.Where(x => x.ReceiptWarehouse == Filter.Warehouse || x.ExpenseWarehouse == Filter.Warehouse); } if (Filter.StartDate.HasValue) { queryStock.Where(x => x.OperationTime >= Filter.StartDate.Value); } if (Filter.EndDate.HasValue) { queryStock.Where(x => x.OperationTime < Filter.EndDate.Value.AddDays(1)); } if (Filter.StockPosition != null) { queryStock.Where(x => x.Nomenclature == Filter.StockPosition.Nomenclature); queryStock.Where(x => x.WearSize == Filter.StockPosition.WearSize); queryStock.Where(x => x.Height == Filter.StockPosition.Height); queryStock.Where(x => x.WearPercent == Filter.StockPosition.WearPercent); } if (Filter.Nomenclature != null) { queryStock.Where(x => x.Nomenclature == Filter.Nomenclature); } if (Filter.Size != null) { queryStock.Where(x => x.WearSize.Id == Filter.Size.Id); } if (Filter.Height != null) { queryStock.Where(x => x.Height.Id == Filter.Height.Id); } IProjection receiptProjection, expenseProjection; if (Filter.Warehouse != null) { receiptProjection = Projections.Conditional( Restrictions.Eq(Projections .Property <WarehouseOperation>(x => x.ReceiptWarehouse.Id), Filter.Warehouse.Id), Projections.Constant(true), Projections.Constant(false) ); expenseProjection = Projections.Conditional( Restrictions.Eq(Projections .Property <WarehouseOperation>(x => x.ExpenseWarehouse.Id), Filter.Warehouse.Id), Projections.Constant(true), Projections.Constant(false) ); switch (Filter.Direction) { case DirectionOfOperation.expense: queryStock.Where(x => x.ExpenseWarehouse.Id == Filter.Warehouse.Id); break; case DirectionOfOperation.receipt: queryStock.Where(x => x.ReceiptWarehouse.Id == Filter.Warehouse.Id); break; } } else { receiptProjection = Projections.Conditional( Restrictions.IsNotNull(Projections .Property <WarehouseOperation>(x => x.ReceiptWarehouse.Id)), Projections.Constant(true), Projections.Constant(false) ); expenseProjection = Projections.Conditional( Restrictions.IsNotNull(Projections .Property <WarehouseOperation>(x => x.ExpenseWarehouse.Id)), Projections.Constant(true), Projections.Constant(false) ); switch (Filter.Direction) { case DirectionOfOperation.expense: queryStock.Where(x => x.ReceiptWarehouse == null); break; case DirectionOfOperation.receipt: queryStock.Where(x => x.ExpenseWarehouse == null); break; } } queryStock .JoinAlias(() => warehouseOperationAlias.Nomenclature, () => nomenclatureAlias) .JoinAlias(() => nomenclatureAlias.Type, () => itemTypesAlias) .JoinAlias(() => itemTypesAlias.Units, () => unitsAlias) .JoinEntityAlias(() => expenseItemAlias, () => expenseItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => collectiveExpenseItemAlias, () => collectiveExpenseItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => incomeItemAlias, () => incomeItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => transferItemAlias, () => transferItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => writeOffItemAlias, () => writeOffItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => employeeIssueOperationAlias, () => employeeIssueOperationAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => employeeCardAlias, () => employeeIssueOperationAlias.Employee.Id == employeeCardAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => completionResultItemAlias, () => completionResultItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .JoinEntityAlias(() => completionSourceItemAlias, () => completionSourceItemAlias.WarehouseOperation.Id == warehouseOperationAlias.Id, JoinType.LeftOuterJoin) .Where(GetSearchCriterion( () => employeeCardAlias.FirstName, () => employeeCardAlias.LastName, () => employeeCardAlias.Patronymic )); if (Filter.CollapseOperationItems) { queryStock.SelectList(list => list .SelectGroup(() => warehouseOperationAlias.Nomenclature.Id) .Select(() => warehouseOperationAlias.OperationTime).WithAlias(() => resultAlias.OperationTime) .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName) .Select(receiptProjection).WithAlias(() => resultAlias.Receipt) .Select(expenseProjection).WithAlias(() => resultAlias.Expense) .SelectSum(() => warehouseOperationAlias.Amount).WithAlias(() => resultAlias.Amount) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName) .Select(() => employeeCardAlias.FirstName).WithAlias(() => resultAlias.EmployeeName) .Select(() => employeeCardAlias.LastName).WithAlias(() => resultAlias.EmployeeSurname) .Select(() => employeeCardAlias.Patronymic).WithAlias(() => resultAlias.EmployeePatronymic) //Ссылки .SelectGroup(() => expenseItemAlias.ExpenseDoc.Id).WithAlias(() => resultAlias.ExpenceId) .SelectGroup(() => collectiveExpenseItemAlias.Document.Id).WithAlias(() => resultAlias.CollectiveExpenseId) .SelectCount(() => employeeCardAlias.Id).WithAlias(() => resultAlias.NumberOfCollapsedRows) .SelectGroup(() => incomeItemAlias.Document.Id).WithAlias(() => resultAlias.IncomeId) .SelectGroup(() => transferItemAlias.Document.Id).WithAlias(() => resultAlias.TransferItemId) .SelectGroup(() => writeOffItemAlias.Document.Id).WithAlias(() => resultAlias.WriteoffId) .SelectGroup(() => completionResultItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromResultId) .SelectGroup(() => completionSourceItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromSourceId) .SelectGroup(() => sizeAlias.Name).WithAlias(() => resultAlias.WearSizeName) .SelectGroup(() => heightAlias.Name).WithAlias(() => resultAlias.HeightName) .SelectGroup(() => warehouseOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) ); } else { queryStock.SelectList(list => list .Select(() => warehouseOperationAlias.Id).WithAlias(() => resultAlias.Id) .Select(() => warehouseOperationAlias.OperationTime).WithAlias(() => resultAlias.OperationTime) .Select(() => unitsAlias.Name).WithAlias(() => resultAlias.UnitsName) .Select(receiptProjection).WithAlias(() => resultAlias.Receipt) .Select(expenseProjection).WithAlias(() => resultAlias.Expense) .Select(() => warehouseOperationAlias.Amount).WithAlias(() => resultAlias.Amount) .Select(() => nomenclatureAlias.Name).WithAlias(() => resultAlias.NomenclatureName) .Select(() => sizeAlias.Name).WithAlias(() => resultAlias.WearSizeName) .Select(() => heightAlias.Name).WithAlias(() => resultAlias.HeightName) .Select(() => warehouseOperationAlias.WearPercent).WithAlias(() => resultAlias.WearPercent) //Ссылки .Select(() => expenseItemAlias.Id).WithAlias(() => resultAlias.ExpenceItemId) .Select(() => expenseItemAlias.ExpenseDoc.Id).WithAlias(() => resultAlias.ExpenceId) .Select(() => collectiveExpenseItemAlias.Id).WithAlias(() => resultAlias.CollectiveExpenseItemId) .Select(() => collectiveExpenseItemAlias.Document.Id).WithAlias(() => resultAlias.CollectiveExpenseId) .Select(() => incomeItemAlias.Id).WithAlias(() => resultAlias.IncomeItemId) .Select(() => incomeItemAlias.Document.Id).WithAlias(() => resultAlias.IncomeId) .Select(() => transferItemAlias.Id).WithAlias(() => resultAlias.TransferId) .Select(() => transferItemAlias.Document.Id).WithAlias(() => resultAlias.TransferItemId) .Select(() => writeOffItemAlias.Id).WithAlias(() => resultAlias.WriteoffItemId) .Select(() => writeOffItemAlias.Document.Id).WithAlias(() => resultAlias.WriteoffId) .Select(() => employeeCardAlias.FirstName).WithAlias(() => resultAlias.EmployeeName) .Select(() => employeeCardAlias.LastName).WithAlias(() => resultAlias.EmployeeSurname) .Select(() => employeeCardAlias.Patronymic).WithAlias(() => resultAlias.EmployeePatronymic) .Select(() => completionResultItemAlias.Id).WithAlias(() => resultAlias.CompletionResultItemId) .Select(() => completionSourceItemAlias.Id).WithAlias(() => resultAlias.CompletionSourceItemId) .Select(() => completionSourceItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromSourceId) .Select(() => completionResultItemAlias.Completion.Id).WithAlias(() => resultAlias.CompletionFromResultId) ); } return(queryStock .OrderBy(x => x.OperationTime).Desc .ThenBy(x => x.Id).Asc .TransformUsing(Transformers.AliasToBean <StockMovmentsJournalNode>())); }