在我的專案中，我正在插入一名員工，當我的員工被插入時，我的保存按鈕 HTML 變為更新，在后端我使用相同的插入功能來更新我剛剛插入的員工，我的插入功能運行良好，但是當我嘗試更新同一條記錄時，它會在資料庫中插入一條新記錄，而不是根據插入的 ID 更新資料，如何根據各自的 ID 更新現有或當前插入的用戶。
我不知道為什么我的更新不起作用以及為什么在插入用戶后我無法立即更新，每次我嘗試更新用戶時我最終都會再次插入用戶，以及我應該如何限制我的應用程式插入類似的資料一次又一次，插入和更新按鈕是相同的，正如我上面提到的，在插入用戶時，我正在將按鈕的內部 HTML 從保存更改為更新，并使用同一個按鈕進行更新
這是我的完整代碼，請告訴我如果我在代碼的任何部分犯了任何錯誤，我從你們那里得到的所有幫助都非常感謝
我的存盤程序代碼：
ALTER PROCEDURE [dbo].[InsEmpOfficialDetails]
(@EmpID int = NULL,
@UserName varchar(500) = NULL,
@pass varchar(500) = NULL,
@OfficialEmailAddress varchar(500) = NULL,
@Department varchar(500) = NULL,
@RoleID int = NULL,
@Role varchar(500) = NULL,
@IsAdmin bit = NULL,
@Designation varchar(500) = NULL,
@ReportToID int = NULL,
@ReportTo varchar(500) = NULL,
@JoiningDate datetime = NULL,
@IsPermanent bit = NULL,
@DateofPermanancy datetime = NULL,
@IsActive bit = NULL,
@HiredbyReference bit = NULL,
@HiredbyReferenceName varchar(500) = NULL,
@BasicSalary int = NULL,
@CurrentPicURL nvarchar(max) = NULL
-- @CreatedBy int,
-- @CreatedOn datetime,
-- @UpdatedOn datetime,
-- @UpdatedBy int
)
AS
BEGIN
IF EXISTS (SELECT 1 FROM Employee
WHERE UserName = @UserName
AND pass = @pass
AND OfficialEmailAddress = @OfficialEmailAddress
AND Department = @Department
AND RoleID = @RoleID
AND Role = @Role
AND IsAdmin = @IsAdmin
AND Designation = @Designation
AND ReportToID = @ReportToID
AND ReportTo = @ReportTo
AND JoiningDate = @JoiningDate
AND IsPermanent = @IsPermanent
AND DateofPermanancy = @DateofPermanancy
AND IsActive = @IsActive
AND HiredbyReference = @HiredbyReference
AND HiredbyReferenceName = HiredbyReferenceName
AND BasicSalary = @BasicSalary
AND CurrentPicURL = @CurrentPicURL)
BEGIN
UPDATE Employee
SET UserName = @UserName,
pass = @pass,
OfficialEmailAddress = @OfficialEmailAddress,
Department = @Department,
RoleID = @RoleID,
Role = @Role,
IsAdmin = @IsAdmin,
Designation = @Designation,
ReportToID = @ReportToID,
ReportTo = @ReportTo,
JoiningDate = @JoiningDate,
IsPermanent = @IsPermanent,
DateofPermanancy = @DateofPermanancy,
IsActive = @IsActive,
HiredbyReference = @HiredbyReference,
HiredbyReferenceName = HiredbyReferenceName,
BasicSalary = @BasicSalary,
CurrentPicURL = @CurrentPicURL
WHERE EmpID = @EmpID
END
ELSE
BEGIN
SET NOCOUNT ON;
INSERT INTO Employee(UserName, pass,
OfficialEmailAddress,Department,
RoleID, Role, IsAdmin, Designation,
ReportToID, ReportTo, JoiningDate,
IsPermanent, DateofPermanancy, IsActive,
HiredbyReference, HiredbyReferenceName,
BasicSalary, CurrentPicURL)
VALUES (@UserName, @pass, @OfficialEmailAddress, @Department,
@RoleID, @Role, @IsAdmin, @Designation,
@ReportToID, @ReportTo, @JoiningDate,
@IsPermanent, @DateofPermanancy, @IsActive,
@HiredbyReference, @HiredbyReferenceName,
@BasicSalary, @CurrentPicURL)
SELECT SCOPE_IDENTITY();
END
END
在我的輸入欄位頂部的 HTML 中，我將當前插入的用戶 ID 存盤在這樣的隱藏欄位中
<input type="hidden" class="HiddenID" />
我不知道如何在插入后立即使用此隱藏欄位 ID 更新用戶，因為正如我提到的，我的插入和更新功能都位于同一個按鈕上
我的ajax代碼：
$('.empOfficialDetails').click(function (ev) {
ev.preventDefault();
var data = new Object();
data.UserName = $('#username').val();
data.UPassword = $('#userpass').val();
data.OfficialEmailAddress = $('#officialemail').val();
data.Departments = $('#departments :selected').text();
data.Designation = $('#designation :selected').text();
data.RoleID = $('#role').val();
data.Role = $('#role :selected').text();
data.ReportToID = $('#reportToID').val();
data.ReportTo = $('#reportTo :selected').text();
data.JoiningDate = $('#joindate').val();
data.IsAdmin = $('#isAdmin :selected').val() ? 1 : 0;
data.IsActive = $('#isActive :selected').val() ? 1 : 0;
data.IsPermanent = $('#isPermanent :selected').val() ? 1 : 0;
data.DateofPermanancy = $('#permanantdate').val();
data.HiredbyReference = $('#hiredbyRef :selected').val() ? 1 : 0;
data.HiredbyReferenceName = $('#refePersonName').val();
data.BasicSalary = $('#basicSalary').val();
data.CurrentPicURL = $('.picture').val();
//data.CurrentPicURL = $('.picture')[0].files;
if (data.UserName && data.UPassword && data.OfficialEmailAddress && data.Departments && data.Designation && data.Role && data.IsAdmin && data.IsPermanent) {
$.ajax({
url: 'http://localhost:1089/api/Employee/EmpOfficialDetails',
type: "POST",
dataType: 'json',
contentType: "application/json",
data: JSON.stringify(data),
enctype: 'multipart/form-data',
beforeSend: function () {
$("#dvRoomsLoader").show();
},
complete: function () {
$("#dvRoomsLoader").hide();
},
success: function (data) {
var ID = parseInt(data);
if (ID > 0) {
//var id = data;
$(".HiddenID").val(data);
//var id = $(".HiddenID").val();
$('#official').css('display', 'block');
$('#official').html("Employees Official details added successfully...!");
$('#official').fadeOut(25000);
$("#dvRoomsLoader").show();
$('.empOfficialDetails').html("Update <i class='fa fa-angle-right rotate-icon'></i>");
}
else {
$('#official').find("alert alert-success").addClass("alert alert-danger").remove("alert alert-success");
}
},
error: function (ex) {
alert("There was an error while submitting employee data");
alert('Error' ex.responseXML);
alert('Error' ex.responseText);
alert('Error' ex.responseJSON);
alert('Error' ex.readyState);
alert('Error' ex.statusText);
}
});
}
return false;
});
我的控制器代碼：
public int Emp_OfficialDetails(Employee emp)
{
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AmanraHRMS"].ConnectionString);
var con = DB.getDatabaseConnection();
SqlCommand com = new SqlCommand("InsEmpOfficialDetails", con);
com.CommandType = CommandType.StoredProcedure;
#region Employee Official Details Insert Code block
com.Parameters.AddWithValue("@UserName", emp.UserName);
com.Parameters.AddWithValue("@pass", emp.UPassword);
com.Parameters.AddWithValue("@OfficialEmailAddress", emp.OfficialEmailAddress);
com.Parameters.AddWithValue("@Department", emp.Departments);
com.Parameters.AddWithValue("@Role", emp.Role);
com.Parameters.AddWithValue("@IsAdmin", Convert.ToBoolean(emp.IsAdmin));
com.Parameters.AddWithValue("@Designation", emp.Designation);
com.Parameters.AddWithValue("@ReportToID", emp.ReportToID);
com.Parameters.AddWithValue("@ReportTo", emp.ReportTo);
com.Parameters.AddWithValue("@JoiningDate", Convert.ToDateTime(emp.JoiningDate));
com.Parameters.AddWithValue("@IsPermanent", Convert.ToBoolean(emp.IsPermanent));
com.Parameters.AddWithValue("@DateofPermanancy", Convert.ToDateTime(emp.DateofPermanancy));
com.Parameters.AddWithValue("@IsActive", Convert.ToBoolean(emp.IsActive));
com.Parameters.AddWithValue("@HiredbyReference", Convert.ToBoolean(emp.HiredbyReference));
com.Parameters.AddWithValue("@HiredbyReferenceName", emp.HiredbyReferenceName);
com.Parameters.AddWithValue("@BasicSalary", emp.BasicSalary);
com.Parameters.AddWithValue("@CurrentPicURL", emp.CurrentPicURL);
#endregion
//var file = emp.CurrentPicURL;
//EmployeeImage(file);
var ID = com.ExecuteScalar();
com.Clone();
return Convert.ToInt32(ID);
}
//Ajax call hit this method from AddEmployee page
[Route("api/Employee/EmpOfficialDetails")]
[HttpPost]
public int? EmpOfficialDetails(Employee emp)
{
IHttpActionResult ret;
try
{
var id = Emp_OfficialDetails(emp);
return id;
}
catch (Exception ex)
{
ret = InternalServerError(ex);
}
return null;
}
uj5u.com熱心網友回復：
修復你的隱藏欄位
<input type="hidden" asp-for ="EmpID" id="empId" class="HiddenID" value="@Model.EmpID />
修復您的存盤程序。存在就足夠了 EmpID，太多的引數會給出錯誤的結果
BEGIN
IF EXISTS (SELECT 1 FROM Employee
WHERE EmpID = @EmpID)
BEGIN
UPDATE Employee
SET UserName = @UserName,
.....
最重要的將 EmpId 添加到 ajax
var data = new Object();
data.EmpID = $('#empId').val();
和行動命令
com.Parameters.AddWithValue("@EmpID", emp.EmpID);
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/415864.html
標籤：