ALTER TABLE [dbo].[ZTestData]
ADD [UpdatedDate] DATETIME NOT NULL DEFAULT(GETDATE())
GO

ALTER PROCEDURE [dbo].[usp_ZTestData_UpdateBeiZhu]
@ID INT,
@BeiZhu NVARCHAR(30)
AS
BEGIN
    UPDATE [dbo].[ZTestData]
    SET
        [BeiZhu] = @BeiZhu,
        [UpdatedDate] = GETDATE()
    WHERE 
        [ID] = @ID
END
GO

ALTER PROCEDURE [dbo].[usp_ZTestData_SelectAll]
AS
BEGIN
    SELECT 
        [ID],
        [IMT_pz],
        [IMT_gx],
        [BeiZhu],
        [UpdatedDate]
    FROM [dbo].[ZTestData]
END
GO

<form id="form1" runat="server">
    <div>
        <table>
            <thead>
                <tr>
                    <td>ID</td>
                    <td>Remarks</td>
                    <td>Update Time</td>
                </tr>
            </thead>
            <tbody >
                <tr>
                    <td>
                        <%# Eval("ID") %>
                        <input id="HiddenID" type="hidden" value=' <%# Eval("ID") %>' />
                    </td>
                    <td>
                        <input id="TextBeiZhu" type="text" value='<%# Eval("BeiZhu") %>' onblur="update(event);" />
                    </td>
                    <td>
                        <%# Eval("UpdatedDate") %>
                    </td>
                </tr>
            </tbody>
            <tfoot>
            </tfoot>
        </table>
    </div>
    <asp:Button ID="ButtonRefreshData" runat="server" Text="RefreshData" Style="display:none" OnClick="ButtonRefreshData_Click" />
</form>

public object DataItem { get; set; }

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        Data_Binding();
    }

}

private void Data_Binding()
{
    ZTestDataEntity ztde = new ZTestDataEntity();
    DataView dv = ztde.Get_DataTable_GetData().DefaultView;
    dv.RowFilter = "ID = 2"; //指定记录主键，只是为了演示。
    DataItem = dv.ToTable().DefaultView[0];
    DataBind();
}

 <script src="Scripts/axios.min.js"></script>
 <script type="text/javascript">

     //onblur事件
     function update(event) {
         updateBeizhuByTextBox(event.target)
             .catch(console.warn);
     }

     function updateBeizhuByTextBox(txtboxElement) {
         return new Promise((resolve, reject) => {

             let url = '/api/MyTest/UpdateBeiZhu';
             var postData = {
                 ID: HiddenID.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(() => {
                     refreshData();
                 });
         });
     }

     function refreshData() {
         document.getElementById('<%= ButtonRefreshData.ClientID %>').click();
     }


 </script>

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        leo yeung
-- Create date: 2026-04-30
-- Description:    更新备注前验证是否有变化
-- =============================================
CREATE TRIGGER [dbo].[tri_ZTestData_UpdateBeiZhu]
ON  [dbo].[ZTestData]
INSTEAD OF UPDATE 
AS 
BEGIN    
    SET NOCOUNT ON;

    IF NOT EXISTS
    (
        SELECT 1 FROM inserted i 
        INNER JOIN deleted d ON (i.[ID] = d.[ID] AND i.[BeiZhu] = d.[BeiZhu]
    ))
    BEGIN        
        UPDATE target
        SET
            [IMT_pz] = i.[IMT_pz],
            [IMT_gx] = i.[IMT_gx],
            [BeiZhu] = i.[BeiZhu],
            [UpdatedDate] =i.[UpdatedDate]
        FROM [dbo].[ZTestData] target
        INNER JOIN inserted i ON target.[ID] = i.[ID];        
    END
    ELSE
    BEGIN
        RAISERROR(N'备注内容无任何变化，更新略过。',16,1)
    END
END
GO

ALTER PROCEDURE [dbo].[usp_ZTestData_UpdateBeiZhu]
    @ID INT,
    @BeiZhu NVARCHAR(30)
AS
BEGIN
    IF NOT EXISTS
    (
        SELECT 1 FROM [dbo].[ZTestData]
        WHERE 
            [ID] = @ID
            AND[BeiZhu] = @BeiZhu
    )
    BEGIN    
        UPDATE [dbo].[ZTestData]
        SET
            [BeiZhu] = @BeiZhu,
            [UpdatedDate] = GETDATE()
        WHERE 
            [ID] = @ID
    END
    ELSE
    BEGIN
        RAISERROR(N'备注内容无任何变化，更新略过。',16,1)
        RETURN
    END
END
GO

 window.lastSavedData = window.lastSavedData || new Map();

 function updateBeizhuByTextBox(txtboxElement) {
     return new Promise((resolve, reject) => {       

         var uniqueKey = txtboxElement.id + '_' + HiddenID.value.trim();                
         var newValue = txtboxElement.value.trim();

         // 检查是否与上次成功保存的值相同
         var lastValue = window.lastSavedData.get(uniqueKey);
         if (lastValue === newValue) {
             console.log("内容未改变，无需保存", uniqueKey, newValue);
             return resolve("内容未改变");
         }

         let url = '/api/IMT/UpdateBeiZhu';
         var postData = {
             ID: HiddenID.value,
             BeiZhu: newValue
         };

         axios.post(url, JSON.stringify(postData), {
             headers: { 'Content-Type': 'application/json; charset=utf-8' }
         })
             .then(response => {
                 if (response.data.Status !== true && response.data.Status !== "true") {
                     alert(response.data.Message);
                     reject(response.data.Message);
                 } else {
                     alert(response.data.Message);
                     window.lastSavedData.set(uniqueKey, newValue);
                     console.log("已记录", uniqueKey, newValue);
                     resolve(response.data);
                 }
             })
             .catch(error => {
                 console.error(error);
                 alert("保存失败，请重试！", true);
                 reject(error);
             })
             .finally(() => {
                 //
             });
     });
 }