using Global;
using System;
using System.Collections.Generic;
using System.Data;
using static DtWebApiDT.DataAccess;
//using static SqlManage.ExecSql;

/// <summary>
/// 
/// </summary>
namespace DTTest
{
    /// <summary>
    /// 对于数据库的操作
    /// </summary>
   public partial class SqlOperation
    {

        /// <summary>
        /// 工序的操作
        /// </summary>
        public partial class SqlProcess
        {
            public static DataTable SelectCraftTreeByModelCode(string modelCode,string PP_ProjectCode)
            {
                string sql =
                    @" DECLARE @ModelCode NVARCHAR(50) = '" + modelCode + "'" +
                    @" DECLARE @ProjectCode NVARCHAR(50) = '" + PP_ProjectCode + "'" +
                    @" SELECT [CraftCode],[CraftTypeCode],[Varieties],[CraftName],[CraftDeviceTypeCode] FROM [OperationTree]" +

                    @" WHERE [ModelCode] = @ModelCode" + " AND [ProjectCode] = @ProjectCode" +
                    @" ORDER BY [CraftTypeCode],[SequenceNo]";
                ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);
                DataTable dt = new DataTable();
                if (ds.Tables.Count > 0)
                {
                    dt = ds.Tables[0];
                }
                return dt;
            }

            public static DataTable Select_CraftProcessByCraftCode(string craftCode,string PP_ProjectCode)
            {
                string sql =
                    @" DECLARE @CraftCode NVARCHAR(50) = '" + craftCode + "'" +
                    @" DECLARE @ProjectCode NVARCHAR(50) = '" + PP_ProjectCode + "'" +
                    @" SELECT 
                         [ProcessCode]
                        ,[SequenceNo]
                        ,[ProcessName]
                        ,[UseTime]

                        ,ISNULL([X],0) AS 'X'
                        ,ISNULL([Y],0) AS 'Y'
                        ,ISNULL([Z],0) AS 'Z'
                        ,ISNULL([RX],0) AS 'RX'
                       , ISNULL([RY],0) AS 'RY'
                        ,ISNULL([RZ],0) AS 'RZ'" +

                    @" FROM  [ModelProcess] " +

                    @" WHERE [CraftCode] = @CraftCode" + " AND [ProjectCode]=@ProjectCode"+

                    @" ORDER BY [SequenceNo]";
                ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);
                DataTable dt = new DataTable();
                if (ds.Tables.Count > 0)
                {
                    dt = ds.Tables[0];
                }
                return dt;
            }
            public static void UpdateModelProcess_Change_UseTime(string processCode, string craftCode, int useTime, string PP_ProjectCode)
            {
                string sql =
                    @" DECLARE  @ProcessCode NVARCHAR(50) = '" + processCode + "'" +
                    @" DECLARE  @CraftCode NVARCHAR(50) = '" + craftCode + "'" +
                    @" DECLARE  @UseTime INT = " + useTime + "" +
                    @" DECLARE @ProjectCode NVARCHAR(50) = '" + PP_ProjectCode + "'" +

                    @" UPDATE [ModelProcess] SET" +

                    @" [UseTime] = @UseTime" +



                    @" WHERE [ProjectCode] = @ProjectCode AND [ProcessCode] = @ProcessCode" +

                    @" UPDATE [OperationTree] SET [KeepTime] = ( SELECT SUM([UseTime]) FROM [ModelProcess] WHERE [ProjectCode] = @ProjectCode AND [CraftCode] = @CraftCode AND [SequenceNo] <> 1)" +
                    @" WHERE [ProjectCode] = @ProjectCode AND [CraftCode] = @CraftCode";

                ExecuteDataset(sql, PP.ConnectionStr, out DataSet ds, out string errorMessage);

            }
        }

    }
}