using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.util;
using Newtonsoft.Json;
using SqlSugar;
using System.Data;

namespace MES.Service.service.QC
{
    public class RetMatService
    {
        public List<dynamic> GetAllDocs()
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
                SELECT THL_NO 
                FROM MES_ITEM_THL 
               -- WHERE JY_BS = 0 AND THL012 = 1
            ";

            var table = db.Ado.GetDataTable(sql);
            return table.ToDynamic();
        }

        public List<dynamic> GetHeader(string docNo)
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
                SELECT 
                    a.THL001 AS moNo,
                    a.THL004 AS type,
                    s.ITEM_NO AS productCode,
                    d.DEPARTMENTNAME AS deptName,
                    TO_CHAR(a.THL011, 'yyyy-mm-dd hh24:mi:ss') AS createTime
                FROM MES_ITEM_THL a
                LEFT JOIN MES_ITEMS s ON a.ITEM_ID = s.ID
                LEFT JOIN WOMDAA a0 ON a.THL001 = a0.DAA001
                LEFT JOIN SYS_DEPARTMENT d ON a0.daa013 = d.ID
                WHERE a.THL_NO = :docNo
            ";

            var table = db.Ado.GetDataTable(sql, new SugarParameter("docNo", docNo));
            return table.ToDynamic();
        }

        public List<dynamic> GetDetailList(string docNo)
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
            SELECT 
                s.ITEM_NO AS material,
                s.ITEM_MODEL AS spec,
                a.THLD005 AS qty,
                a.THLD014 AS reason,
                s.ID AS itemId
            FROM MES_ITEM_THL_DETAIL a
            LEFT JOIN MES_ITEM_THL b ON a.THLMID = b.ID
            LEFT JOIN MES_ITEMS s ON a.ITEM_ID = s.ID
            WHERE b.THL_NO = :docNo
        ";

            return db.Ado.GetDataTable(sql, new SugarParameter("docNo", docNo)).ToDynamic();
        }

        public void UpdateHeader(string docNo, string user)
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
                UPDATE MES_ITEM_THL 
                SET JY_BS = 1, 
                    JY_USER = :user, 
                    JY_TIME = SYSDATE 
                WHERE THL_NO = :docNo
            ";

            db.Ado.ExecuteCommand(sql,
                new SugarParameter("docNo", docNo),
                new SugarParameter("user", user)
            );
        }

/*        public void SaveReviewItem(string docNo, string itemNo, string reason)
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
                UPDATE MES_ITEM_THL_DETAIL
                SET THLD014 = :reason
                WHERE THLMID = (
                    SELECT ID FROM MES_ITEM_THL WHERE THL_NO = :docNo
                )
                AND ITEM_ID = (
                    SELECT ID FROM MES_ITEMS WHERE ITEM_NO = :itemNo
                )
            ";

            db.Ado.ExecuteCommand(sql,
                new SugarParameter("docNo", docNo),
                new SugarParameter("itemNo", itemNo),
                new SugarParameter("reason", reason)
            );
        }*/

        public void SaveReview(string docNo, string user, List<ReviewItem> items)
        {
            var db = SqlSugarHelper.GetInstance();

            string json = JsonConvert.SerializeObject(items); // 序列化为 JSON 字符串

           

            foreach (ReviewItem item in items)
            {
                var parameters = new List<SugarParameter>
{
    new SugarParameter("pi_NO", docNo, System.Data.DbType.String),
    new SugarParameter("pi_user", user, System.Data.DbType.String),
    new SugarParameter("pi_item_ID", item.ItemId, System.Data.DbType.Decimal),  
    new SugarParameter("pi_reason", item.Reason, System.Data.DbType.String)
};


                db.Ado.UseStoredProcedure()
                .ExecuteCommand("PRC_RET_MAT_AUDIT_ALL", parameters);
            }

            
        }


        public void Reject(string docNo, string user)
        {
            var db = SqlSugarHelper.GetInstance();

            string sql = @"
        UPDATE MES_ITEM_THL 
        SET BH_TIME = SYSDATE,
            BH_USER = :pi_user,
            THL010 = '',
            THL011 = '',
            THL012 = 0 
        WHERE THL_NO = :pi_no
    ";

            db.Ado.ExecuteCommand(sql,
                new SugarParameter("pi_user", user),
                new SugarParameter("pi_no", docNo)
            );
        }

    }
}