日青頻道

  DECLARE @CursorEmployeePositionContent CURSOR DECLARE @CursorMovementPositionContent CURSOR DECLARE @EmployeePositionId INT DECLARE @MovementType2EmployeeId INT DECLARE @MovementType2PositionId  INT DECLARE @MovementType2IsPrimaryPosition  INT DECLARE @MovementType2JobCodeId  INT --Update movementType 1 SET @CursorEmployeePositionContent = CURSOR FORWARD_ONLY READ_ONLY FOR  select EmployeePositionId from EmployeePosition where 1=1  and exists (select 1 from MovementPosition  where MovementPosition.EmployeeId = EmployeePosition.EmployeeId and MovementPosition.PositionId = EmployeePosition.PositionId  and MovementPosition.MovementType = 1 and MovementPosition.EmployeeId = 18449 and MovementPosition.movementId = 7) OPEN @CursorEmployeePositionContent FETCH NEXT FROM @CursorEmployeePositionContent INTO  @EmployeePositionId   WHILE @@FETCH_STATUS = 0  BEGIN  Update EmployeePosition ...

    var param = new SqlParameter[] {                         new SqlParameter() {                             ParameterName = "@ORTHNumber",                             SqlDbType =  System.Data.SqlDbType.VarChar,                             Size = 100,                             Direction = System.Data.ParameterDirection.Input,                             Value = ""                         },                         new SqlParameter() {     ...

     <script src="https://malsup.github.io/jquery.blockUI.js"></script> Uncaught ReferenceError: Loading is not defined Solved -> '#loadingIcon' is missing   <div id="loadingIcon" style="display:none" class="lds-ripple"><div></div><div></div></div> function Loading(obj) {     $.blockUI({ message: $('#loadingIcon'), css: { "background-color": "transparent", border: 0 } });     if (obj != null)         obj.hide(); } function Loaded(obj) {     $.unblockUI();     if (obj != null)         obj.fadeIn(150); }