-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    数据表ZTestData
-- =============================================
CREATE TABLE [dbo].[ZTestData]
(
    [ID] INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    [IMT_pz] NVARCHAR(30) NOT NULL,
    [IMT_gx] NVARCHAR(30) NOT NULL,
    [BeiZhu] NVARCHAR(30) NULL
)
GO

-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    数据表添加一些示例临时数据
-- =============================================
INSERT INTO [dbo].[ZTestData]
(
    [IMT_pz],
    [IMT_gx]
)
VALUES
(
    N'f043',
    N'P10'
)
,(
    N'l52',
    N'P10'
)
,(
    N'j71',
    N'P30'
)
,(
    N'v11',
    N'P20'
)
,(
    N'U33',
    N'P20'
)
GO

-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    存储过程，获取所有数据
-- =============================================
CREATE PROCEDURE [dbo].[usp_ZTestData_SelectAll]
AS
BEGIN
    SELECT [ID],
    [IMT_pz],
    [IMT_gx],
    [BeiZhu]
    FROM [dbo].[ZTestData]
END
GO

-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    更新存储过程
-- =============================================
CREATE PROCEDURE [dbo].[usp_ZTestData_UpdateBeiZhu]
@ID INT,
@BeiZhu NVARCHAR(30)
AS
BEGIN
    UPDATE [dbo].[ZTestData]
    SET
        [BeiZhu] = @BeiZhu
    WHERE 
        [ID] = @ID
END
GO

-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    创建一个表函，批量更新，作为存储过程传入的参数
-- =============================================
CREATE TYPE [dbo].[udtt_ZTestData_BZ] AS TABLE(
    [ID] [int] NOT NULL,    
    [BeiZhu] [nvarchar](30) NULL
)
GO

-- =============================================
-- Author:        Insus.NET
-- Create date: 2026-04-28
-- Description:    批理更新存储过程
-- =============================================
CREATE PROCEDURE [dbo].[usp_ZTestData_BatchUpdate]
    @BatchBeiZhu  [dbo].[udtt_ZTestData_BZ] READONLY
AS
BEGIN
    MERGE [dbo].[ZTestData] AS TARGET
    USING @BatchBeiZhu AS SOURCE        
    ON TARGET.[ID] = SOURCE.[ID]
    WHEN MATCHED THEN
        UPDATE SET        
        TARGET.[BeiZhu] = SOURCE.[BeiZhu]
    ;
END
GO

namespace Insus.NET
{
    public class ZTestData
    {
        public int ID { get; set; }

        public string IMT_pz { get; set; }

        public string IMT_gx { get; set; }

        public string BeiZhu { get; set; }

        public DataTable BatchBeiZhu { get; set; }
    }
}

namespace Insus.NET
{
    /// <summary>
    /// ZTestDataEntity 的摘要说明
    /// </summary>
    
    public class ZTestDataEntity
    {
        BusinessBase objBusinessBase = new BusinessBase();

        public DataTable Get_DataTable_GetData()
        {
            return objBusinessBase.GetDataToDataSet("usp_ZTestData_SelectAll").Tables[0];
        }

        public void UpdateBeiZhu(ZTestData ztd)
        {
            Parameter[] parameter = {
                                        new Parameter("@ID",SqlDbType.Int,4,ztd.ID),
                                        new Parameter("@BeiZhu",SqlDbType.NVarChar,-1,ztd.BeiZhu)
                                    };
            objBusinessBase.ExecuteProcedure("usp_ZTestData_UpdateBeiZhu", parameter);
        }

        public void BatchUpdateBeiZhu(ZTestData ztd)
        {
            Parameter[] parameter = {
                                        new Parameter("@BatchBeiZhu",SqlDbType.Structured,-1,ztd.BatchBeiZhu)
                                    };
            objBusinessBase.ExecuteProcedure("usp_ZTestData_BatchUpdate", parameter);
        }
    }
}

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Data_Binding();
        }

    }

    private void Data_Binding()
    {
        ZTestDataEntity ztde = new ZTestDataEntity();
        this.GridViewZTestData.DataSource = ztde.Get_DataTable_GetData();
        this.GridViewZTestData.DataBind();
    }

    protected void GridViewZTestData_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType != DataControlRowType.DataRow) return;       

        Button btnUpdate = (Button)e.Row.FindControl("ButtonUpdate");
        if (btnUpdate != null)
        {
            btnUpdate.Click += BtnUpdate_Click;
        }
    }

    private void BtnUpdate_Click(object sender, EventArgs e)
    {
        Button button = (Button)sender;
        GridViewRow gvr = (GridViewRow)button.Parent.Parent;

        var textboxBeiZhu = (TextBox)gvr.FindControl("TextBoxBeiZhu");

        try
        {
            string keyVal = GridViewZTestData.DataKeys[gvr.RowIndex].Value.ToString();

            ZTestData ztd = new ZTestData();
            ztd.ID = Convert.ToInt32(keyVal);
            ztd.BeiZhu = textboxBeiZhu.Text.Trim();

            ZTestDataEntity ztde = new ZTestDataEntity();
            ztde.UpdateBeiZhu(ztd);
            //JsAlert("保存成功。");

        }
        catch (Exception ex)
        {
            //JsAlert(ex.Message);
            return;
        }
        finally
        {
            Data_Binding();
        }
    }

    protected void ButtonOneTimeUpdate_Click(object sender, EventArgs e)
    {
        DataTable _dt_bz = new DataTable();
        _dt_bz.Columns.Add("ID", typeof(int));
        _dt_bz.Columns.Add("BeiZhu", typeof(string));

        foreach (GridViewRow gvr in this.GridViewZTestData.Rows)
        {
            int keyID = Convert.ToInt32(this.GridViewZTestData.DataKeys[gvr.RowIndex].Value);
            string bz = ((TextBox)gvr.FindControl("TextBoxBeiZhu")).Text.Trim();
            _dt_bz.Rows.Add(keyID, bz);
        }

        try
        {
            ZTestData ztd = new ZTestData();
            ztd.BatchBeiZhu = _dt_bz;
            ZTestDataEntity ztde = new ZTestDataEntity();
            ztde.BatchUpdateBeiZhu(ztd);
            //JsAlert("数据已经保存。");
        }
        catch (Exception ex)
        {
            //JsAlert(ex.Message);
        }

    }
}

let isUpdating = false; //更新请求
let skipBlurOnce = false; //区分是否为blur事件

function updateBeizhuByTextBox(txtboxElement) {
    return new Promise((resolve, reject) => {
        if (isUpdating) return reject("已有请求进行中");

        var id = txtboxElement.id;
        var baseId = id.substring(0, id.lastIndexOf("_") + 1);
        var hiddenKey = document.getElementById(baseId + "HiddenFieldID");

        isUpdating = true;
        let url = '/api/MyTest/UpdateBeiZhu';
        var postData = {
            ID: hiddenKey.value,
            BeiZhu: txtboxElement.value.trim()
        };

        axios.post(url, JSON.stringify(postData), {
            headers: { 'Content-Type': 'application/json; charset=utf-8' }
        })
            .then(response => {
                if (!response.data.Status) {
                    alert(response.data.Message);
                    reject(response.data.Message);
                } else {
                    alert(response.data.Message);
                    resolve(response.data);
                }
            })
            .catch(error => {
                console.error(error);
                reject(error);
            })
            .finally(() => {
                isUpdating = false;
            });
    });
}

function UpdateBeiZhu(event) {
    if (skipBlurOnce) {
        skipBlurOnce = false;
        return;
    }

    updateBeizhuByTextBox(event.target)
        .catch(console.warn);   
}

document.addEventListener('keydown', function (e) {
    if (e.key === 'Enter' || e.keyCode === 13) {
        var activeEl = document.activeElement;
        if (activeEl && activeEl.getAttribute('data-bz') === 'gv-txtbox-beizhu') {
            e.preventDefault();
            skipBlurOnce = true;  // 阻止随后的 blur 触发  
            activeEl.blur();      //让按完回车后文框的focus焦点去除。
            updateBeizhuByTextBox(activeEl)
                .catch(console.warn)
                .finally(() => {
                    // 延迟重置标志，确保 blur 已被忽略
                    setTimeout(() => { skipBlurOnce = false; }, 300);
                });
        } else {
            // 如果其他元素按回车不想提交表单，可以阻止默认
            // e.preventDefault();  // 根据需求决定是否全局阻止
        }
    }
});