مركز الدعم

كيف يمكننا مساعدتك ...

آخر تحديثات ارتق

أقرا المزيد

المواضيع الأكثر بحثآ

أقرا المزيد

الأسئله الشائعه

كيف لـ

name
تفاصيل المنتج غير متاحة
# Name Machine Category
No Data
DECLARE @product_id UniqueIdentifier = NULL
DECLARE @project_id UniqueIdentifier = NULL

SELECT
m.id AS [machine_id],
(SELECT id FROM [dbo].[indprjs_technical_processes] WHERE [machine_id]=m.id and [product_id]=@product_id) AS [id],
m.[ref_code],
CASE
WHEN
(
SELECT id FROM [dbo].[indprjs_technical_processes] WHERE [machine_id]=m.id and [product_id]=@product_id
) IS NULL THEN 0
ELSE 1
END AS [isactive],
CASE category_id
WHEN 1 THEN 'production'
WHEN 2 THEN 'recycle'
WHEN 3 THEN 'treatement'
WHEN 4 THEN 'packing'
WHEN 5 THEN 'funnel'
WHEN 6 THEN 'incinerator'

ELSE ''

END AS [category_name],
m.[name]
FROM
[indprjs_technical_machines] m
WHERE
m.[project_id] = @project_id
ORDER BY arrange ASC

_ertaqy//90//localhost//Invalid object name 'indprjs_technical_machines'.

at Ertaqy.Web.CSResponse.Error(ErrorTypes type, String msg, String errNo, String errRef) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web\App_Helpers\CSResponse.cs:line 104
at Ertaqy.Web.CSResponse.Error(ErrorTypes type, String msg) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web\App_Helpers\CSResponse.cs:line 95
at Ertaqy.Web.Data.Manager.DataBase_Manager.SelectDataReader(DataBaseCommand cmd, Boolean snapshot) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web.Static\DatabaseManager\Database_Manager.cs:line 81
at Ertaqy.BetterCms.Widgets.Helpers.QueryDataHelper.ExecuteReader(Var action, Dictionary`2 userData, Dictionary`2 modelOptions, Dictionary`2& queryData) in E:\_ertaqy\BetterCMS-Ertaqy\Ertaqy.BetterCms.Widgets\Helpers\QueryDataHelper.cs:line 1530
أقرا المزيد

دليل المستخدم

No Data DECLARE @project_id UniqueIdentifier = NULL SELECT m.[id], m.[name], m.[height], m.[length], m.[distance_before], m.[ref_code], m.[distance_after], m.[distance_left], m.[distance_right], CASE m.category_id WHEN 1 THEN 'production' WHEN 2 THEN 'recycle' WHEN 3 THEN 'treatement' WHEN 4 THEN 'packing' WHEN 5 THEN 'funnel' WHEN 6 THEN 'incinerator' ELSE '' END AS [category_name], m.[origin], CASE m.process_type_id WHEN 1 THEN 'Continuous' WHEN 2 THEN 'batch' ELSE '' END AS [process_type], un.[name] AS [dimension_unit_name], m.[dimension_unit_id], co.[name] AS [origin_name] FROM [indprjs_technical_machines] m LEFT JOIN [indprjs_units] un ON un.id=m.dimension_unit_id LEFT JOIN [indprjs_countries] co ON co.id=m.origin WHERE m.[project_id] = @project_id ORDER BY arrange ASC _ertaqy//90//localhost//Invalid object name 'indprjs_technical_machines'. at Ertaqy.Web.CSResponse.Error(ErrorTypes type, String msg, String errNo, String errRef) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web\App_Helpers\CSResponse.cs:line 104 at Ertaqy.Web.CSResponse.Error(ErrorTypes type, String msg) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web\App_Helpers\CSResponse.cs:line 95 at Ertaqy.Web.Data.Manager.DataBase_Manager.SelectDataReader(DataBaseCommand cmd, Boolean snapshot) in E:\_ertaqy\WebApps\_prjs\Ertaqy.Web.Static\DatabaseManager\Database_Manager.cs:line 81 at Ertaqy.BetterCms.Widgets.Helpers.QueryDataHelper.ExecuteReader(Var action, Dictionary`2 userData, Dictionary`2 modelOptions, Dictionary`2& queryData) in E:\_ertaqy\BetterCMS-Ertaqy\Ertaqy.BetterCms.Widgets\Helpers\QueryDataHelper.cs:line 1530 أقرا المزيد
لا يوجد