MS SQL 9NTZSEhfQ7xCTJzcTkx3J9F6wYnnW7uF4kHtbGH0IjfgMLnrS2v6zctBudxOhOEq13D7AkVZuplvSb1Q5MTnG40g98vIA5P5aVq5WGBJYnfVVlPrYUtLgX9cvZhwTG3jxFS5zcU= 72c457613e5549219649b81a5d84a888 MS SQL dsMain ORIGINAL,Объект,Объект,Объект,System.String,b8b4bf232fb947fd8f7eec198af7842b ORIGINAL,Номенклатура,Номенклатура,Номенклатура,System.String,d1f8a2e95d194ee88435739dba4ed23d ORIGINAL,Лимит,Лимит,Лимит,System.Decimal,f8dd716c36a94e158896ca7a310ffeea ORIGINAL,Отгружено,Отгружено,Отгружено,System.Decimal,_x0032_74e52f8c65045258dd95b41f4b6fcb3 ORIGINAL,Остаток,Остаток,Остаток,System.Decimal,_x0032_fd18e2340ef4c9a91ca9d093138e5a5 ORIGINAL,Quantity,Quantity,Quantity,System.Decimal,_x0039_45ee81af7ed4aaa861a9ccec1be8438 ORIGINAL,Площадка,Площадка,Площадка,System.String,_x0036_9e22d77974b4ce5b68bd0862b2b047a ИД_x0020_площадка,System.Int32 30 4524c28fb5b647debd8f44cb5f821bbd dsMain MS SQL SELECT ot.Name [Объект] ,w.FullName [Номенклатура] ,otp.Quantity [Лимит] ,sum(dld.Quantity) [Отгружено] ,ms.Quantity [Остаток] ,f.Name [Площадка] ,f.ID [ИД площадка] ,( SELECT sum(ms.Quantity) FROM MaterialStocks ms WHERE ms.WareId = w.ID AND StockType = 1 AND ms.FactoryId IN ({factories.Count == 0 ? "NULL" : factories.ToQueryString()}) ) Quantity FROM Wares w INNER JOIN ObjectTitlePlans otp ON otp.WareId=w.id INNER JOIN ObjectTitles ot ON w.ID = otp.WareId AND ot.id = otp.ObjectTitleId INNER JOIN Documents d ON d.ObjectTitleId=ot.Id INNER JOIN DocumentLines dl ON dl.DocumentId = d.Id AND dl.WareId = w.Id INNER JOIN DocumentLineDetails dld ON dld.LineId = dl.Id INNER JOIN MaterialStocks ms ON ms.FactoryId = d.FactoryId AND ms.WareId = dl.WareId INNER JOIN Factories f ON f.id = ms.FactoryId WHERE 1=1 AND ot.id IN ({object1.Count == 0 ? "NULL" : object1.ToQueryString()}) AND f.id IN ({factories.Count == 0 ? "NULL" : factories.ToQueryString()}) AND w.FullName Like '%' + @ware + '%' AND (d.Kind =2 OR d.Kind is null) AND ms.StockType = 1 GROUP BY ot.Name, w.FullName, otp.Quantity, ms.Quantity, f.Name,f.ID, w.ID dsObject ORIGINAL,id,id,id,System.Int32,_x0036_2eb176a6f214ec3bf6a9ee6179bb371 ORIGINAL,Name,Name,Name,System.String,_x0036_e592f1c9d55499c9e9972920b51b65d ORIGINAL,ParentID,ParentID,ParentID,System.Int32,ee314044b9024fb4b1bd060db3b14076 30 daa4f98b441348028bf48d0893dd2c16 dsObject MS SQL SELECT id, Name,ParentID FROM ObjectTitles WHERE IsHidden <>1 AND IsFolder <> 1 dsFactories ORIGINAL,ID,ID,ID,System.Int32,_x0031_bee6f5fc9ca43779f2d755da7a312c6 ORIGINAL,Name,Name,Name,System.String,dcca2ad2c48842a39b6fac6b6883db5f 30 c4af1d0e939b4cc39c290a1937812e3e dsFactories MS SQL SELECT ID, Name FROM Factories f dsObjectTitlesFolders ORIGINAL,Id,Id,Id,System.Int32,c07e9c3f2b4c44d185a13b1c8976ff30 ORIGINAL,Name,Name,Name,System.String,_x0033_2682374a0de4f3780420be40e0bfb0c 30 f31c445619a34379805528886cabff21 dsObjectTitlesFolders MS SQL SELECT ot.Id, ot.Name FROM ObjectTitles ot WHERE 1=1 and ot.IsFolder = 1 and ot.IsHidden = 0 dsOTFolderDefault ORIGINAL,Column1,Column1,Column1,System.Int32,f5a6df1e4ffc44de91bd4fba8356111b 30 75084a1ef297485ebd9c6b1c67fd5903 dsOTFolderDefault MS SQL SELECT MAX(ID) FROM ObjectTitles ot WHERE 1=1 and ot.IsFolder = 1 and ot.IsHidden = 0 MaterialStocks Id,System.Int32 FactoryId,System.Int32 WareId,System.Int32 Quantity,System.Decimal 30 3bd0ea8d5be44d038fcfae16a7516b81 MaterialStocks MS SQL select Id, FactoryId, WareId, Quantity from MaterialStocks Wares ID,System.Int32 Name,System.String FullName,System.String 30 e6f87656c0ad41f38303a6aca507142b Wares MS SQL select ID, Name, FullName from Wares <Площадка Ref="10" type="DataRelation" isKey="true"> Площадка FactoryId Площадка Связь2 ID <Номенклатура Ref="11" type="DataRelation" isKey="true"> Номенклатура WareId Номенклатура Связь3 ID <Наименование Ref="12" type="DataRelation" isKey="true"> Наименование ID Наименование Связь4 WareId <_x0032_2 Ref="13" type="DataRelation" isKey="true"> 22 ID 22 Связь FactoryId <_x0031_111 Ref="14" type="DataRelation" isKey="true"> 1111 ID 1111 Связь5 ИД площадка ,ObjectTitleFolder,Папка_x0020_титула,,Stimulsoft.Report.IntList,_x0033_396,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsObjectTitlesFolders.Id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsObjectTitlesFolders.Name_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,_x0039_d3bde702f684b8eaa5e7ca15d09f5f6 ,object1,Объект,,Stimulsoft.Report.IntList,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsObject.id_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsObject.Name_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x003E__x002C_ObjectTitleFolder_x002C_Папка_x005F_x0020_титула_x002C__x002C_Stimulsoft.Report.IntList_x002C__x005F_x0033_396_x002C_False_x002C_False_x002C_True_x002C_False_x002C__x005F_x003C__x005F_x003F_xml_x005F_x0020_version_x005F_x003D__x005F_x0022_1.0_x005F_x0022__x005F_x0020_encoding_x005F_x003D__x005F_x0022_utf-16_x005F_x0022__x005F_x0020_standalone_x005F_x003D__x005F_x0022_yes_x005F_x0022__x005F_x003F__x005F_x003E__x005F_x003C_StiSerializer_x005F_x0020_version_x005F_x003D__x005F_x0022_1.02_x005F_x0022__x005F_x0020_type_x005F_x003D__x005F_x0022_Net_x005F_x0022__x005F_x0020_application_x005F_x003D__x005F_x0022_State_x005F_x0022__x005F_x003E__x005F_x003C_ItemsInitializationType_x005F_x003E_Columns_x005F_x003C__x005F_x002F_ItemsInitializationType_x005F_x003E__x005F_x003C_KeysColumn_x005F_x003E_dsObjectTitlesFolders.Id_x005F_x003C__x005F_x002F_KeysColumn_x005F_x003E__x005F_x003C_ValuesColumn_x005F_x003E_dsObjectTitlesFolders.Name_x005F_x003C__x005F_x002F_ValuesColumn_x005F_x003E__x005F_x003C_BindingVariable_x005F_x0020_isNull_x005F_x003D__x005F_x0022_true_x005F_x0022__x005F_x0020__x005F_x002F__x005F_x003E__x005F_x003C_AllowUserValues_x005F_x003E_False_x005F_x003C__x005F_x002F_AllowUserValues_x005F_x003E__x005F_x003C_Keys_x005F_x0020_isList_x005F_x003D__x005F_x0022_true_x005F_x0022__x005F_x0020_count_x005F_x003D__x005F_x0022_0_x005F_x0022__x005F_x0020__x005F_x002F__x005F_x003E__x005F_x003C_Values_x005F_x0020_isList_x005F_x003D__x005F_x0022_true_x005F_x0022__x005F_x0020_count_x005F_x003D__x005F_x0022_0_x005F_x0022__x005F_x0020__x005F_x002F__x005F_x003E__x005F_x003C_ValuesBinding_x005F_x0020_isList_x005F_x003D__x005F_x0022_true_x005F_x0022__x005F_x0020_count_x005F_x003D__x005F_x0022_0_x005F_x0022__x005F_x0020__x005F_x002F__x005F_x003E__x005F_x003C__x005F_x002F_StiSerializer_x005F_x003E__x002C__x005F_x0039_d3bde702f684b8eaa5e7ca15d09f5f6_x003C__x002F_BindingVariable_x003E__x003C_BindingValuesColumn_x003E_dsObject.ParentID_x003C__x002F_BindingValuesColumn_x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_BindingValue_x003E_True_x003C__x002F_BindingValue_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,ea8a26c291ea4eefb7ac34e6caa212c3,False,First ,factories,Площадка,,Stimulsoft.Report.IntList,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_dsFactories.ID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_dsFactories.Name_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,_x0031_22ee31b89b742a69fe92f7dd24634bc ,ware,Номенклатура,,System.String,,False,False,True,False,,_x0039_a7c8d297f3048b7a9ee4340502bcee4,True ,CurrentUserID,CurrentUserID,,System.String,_x0030_,False,False,False,False,,_x0031_6b84aa316c34879a13727b3a3e97a84 EngineV2 7d4454a7a6b94dcca9ed6a1e78f515de None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,68,1.8 Transparent 0,0,14.6,1.8 All;Black;1;Solid;False;4;Black [84:141:212] True 0.1,0,10.7,1.8 Arial,12,Bold True Center 0,0,0,0 Text2 Номенклатура Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black [84:141:212] True 10.8,0,3.8,1.8 Arial,12,Bold True Center 0,0,0,0 Text3 Свободный остаток на базах Black ,,,,WordWrap=True,A=0 Expression Center CrossHeaderBand1 Transparent 14.6,0,4,1.8 All;Black;1;Solid;False;4;Black [84:141:212] True 0,0,4,1.8 Arial,12,Bold True Center 0,0,0,0 4,0 Text4 {dsFactories.Name} Black ,,,,WordWrap=True,A=0 DataColumn Center dsFactories CrossDataBand1 HeaderBand1 Transparent 0,3,68,0.8 Transparent 0,0,14.6,0.8 All;Black;1;Solid;False;4;Black [198:217:240] True 0,0,10.8,0.8 Arial,10 True f31727773d2f4263a037169369a7f53b Center 0,0,0,0 Text5 BasedOnTagMerge {dsMain.Quantity} {dsMain.Номенклатура} Black ,,,,WordWrap=True,A=0 Center All;Black;1;Solid;False;4;Black Yellow 10.8,0,3.8,0.8 Arial,10 44bb11912b574dba979c056c3681bb4f Center 0,0,0,0 Text6 BasedOnTagMerge {dsMain.Quantity} {dsMain.Quantity} Black Expression Center CrossHeaderBand2 Transparent 14.6,0,4,0.8 All;Black;1;Solid;False;4;Black [0:176:80] 0,0,4,0.8 Arial,10 486448bac1c44446a4f31407f8a7a9c5 Center 0,0,0,0 Text7 Black DataColumn Center All;Black;1;Solid;False;4;Black [0:176:80] 0,0,4,0.8 _x007B_dsMain.Площадка_x0021__x003D_dsFactories.Name_x007D_,Black,ForestGreen,Arial_x002C_8,False,False,,,None Arial,10 2f05abdf738a40058b8486e798663ffc Center 0,0,0,0 Text8 {dsMain.Остаток} Black Expression Center dsFactories CrossDataBand3 {dsMain.Номенклатура}{dsMain.Площадка} GroupHeaderBand2 Transparent 0,4.6,68,0 dsMain DataBand2 ASC Номенклатура 10241a4fe76d43e8b2aedfe5a5975541 1,1,1,1 Page1 Landscape 40 70 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,68,1.8 Transparent 0,0,14.6,1.8 All;Black;1;Solid;False;4;Black [84:141:212] True 0.1,0,10.7,1.8 Arial,12,Bold True Center 0,0,0,0 Text35 Номенклатура Black ,,,,WordWrap=True,A=0 Expression Center All;Black;1;Solid;False;4;Black [84:141:212] True 10.8,0,3.8,1.8 Arial,12,Bold True Center 0,0,0,0 Text40 Свободный остаток на базах Black ,,,,WordWrap=True,A=0 Expression Center CrossHeaderBand3 Transparent 14.6,0,4,1.8 All;Black;1;Solid;False;4;Black [84:141:212] True 0,0,4,1.8 Arial,12,Bold True Center 0,0,0,0 4,0 Text41 {dsFactories.Name} Black ,,,,WordWrap=True,A=0 DataColumn Center dsFactories CrossDataBand2 HeaderBand2 Transparent 0,3,68,0.8 Transparent 0,0,14.6,0.8 All;Black;1;Solid;False;4;Black [198:217:240] True 0,0,10.8,0.8 Arial,10 True f31727773d2f4263a037169369a7f53b Center 0,0,0,0 Text42 {dsMain.Номенклатура} Black ,,,,WordWrap=True,A=0 Center All;Black;1;Solid;False;4;Black [227:108:9] 10.8,0,3.8,0.8 Arial,10 44bb11912b574dba979c056c3681bb4f Center 0,0,0,0 Text46 {dsMain.Quantity} Black DataColumn Center CrossHeaderBand4 Transparent 14.6,0,4,0.8 All;Black;1;Solid;False;4;Black [0:176:80] 0,0,4,0.8 Arial,10 486448bac1c44446a4f31407f8a7a9c5 Center 0,0,0,0 Text1 Black DataColumn Center All;Black;1;Solid;False;4;Black [0:176:80] 0,0,4,0.8 _x007B_dsMain.Площадка_x0021__x003D_dsFactories.Name_x007D_,Black,ForestGreen,Arial_x002C_8,False,False,,,None Arial,10 2f05abdf738a40058b8486e798663ffc Center 0,0,0,0 Text47 {dsMain.Остаток} Black Expression Center dsFactories CrossDataBand5 dsMain DataBand1 ASC Номенклатура 733db016b61f4093b56a3b196252c032 1,1,1,1 Page3 Landscape 40 70 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 1/18/2022 6:17:52 PM 12/27/2021 12:17:35 PM C:\Users\Chekulaev\Desktop\v\удалить тест\TEST 2 ___5.ObjectsByWare_Granit (номенкл в разрезе титулов по всем базам).mrt 7434798535c54e499f891d8e6b40454e Report Centimeters 2019.4.2.0 CSharp