更新与标签消息对应的下拉列表的问题。 [英] Update issue with dropdown corresponding to label message.

问题描述

我有一个标签（即更新状态在此标签中），两个下拉列表一个是开发人员，另一个是测试人员。



当我分配两者时，它工作正常，如果我只分配/选择开发人员，它工作正常。但是当我在没有选择任何开发人员的情况下单独选择测试人员时，如果某些其他问题的状态变为状态= 2（即已分配），则其他问题标签状态也会自动更改。



我用过的程序

Hi ,

I have one label(ie updated status comes in this label) and two dropdown list one is developer and another is tester.

When I assign both it is working fine and if am assigning/selecting only developer it is working fine . But when i select only tester individually without selecting any developer then the other issues label status also gets changed automatically if some other issues have different status for the timing it gets changed to status=2(ie , assigned ) .

I have used procedure

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
)
as
begin 
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end

status = 2是因为如果我选择并分配状态标签应该更新为已分配。



希望你有问题。



谢谢

This status =2 is because if am selecting and assigning the status label should get updated to assigned .

Hope you got the issue.

Thanks

推荐答案

ALTER程序[dbo]。[usp_assignedto]

（

@employeeid int，

@issuetrackerid int，

@testerid int

- @ status int

）

as

开始

设置nocount



if（status！= 1）或（状态！= 2）

开始

更新issuesdetails set assignedto = @employeeid，testerassign = @ testerid where issuetrackerid = @ issuetrackerid

结束

开始

更新issuesdetails set assignedto = @ employeeid，status = 2，testerassign = @ testerid where issuetrackerid = @ issuetrackerid

end < br $> b $ b



结束



首先，如果（状态！= 1）或（状态！= 2）这个条件不起作用，如果我传递参数@status It有效，但我没有从前端传递任何参数，所以我不能通过这个参数。所以也请替换它。



我尝试使用这个，上一期更新所有问题的状态标签问题已经解决，但现在我无法更新状态，点击提交点击不会发生变化。



请尽快给我一些解决方案

ALTER procedure [dbo].[usp_assignedto]
(
@employeeid int,
@issuetrackerid int,
@testerid int
--@status int
)
as
begin
set nocount on

if (status !=1) or (status !=2)
begin
update issuesdetails set assignedto = @employeeid , testerassign=@testerid where issuetrackerid=@issuetrackerid
end
begin
update issuesdetails set assignedto=@employeeid,status =2 , testerassign=@testerid where issuetrackerid=@issuetrackerid
end


end

First of all the "if (status !=1) or (status !=2)" this condition is not working , if i pass the parameter @status It works but I am not passing any parametr from front end so I cant pass this parameter . So Please give substitute for this also .

I tried using this , the previous issue of updating the status label for all the issue is resolved but now I cant update the status , On submit click no change occur.

Please give me some solution asap

这里提供了答案：更新存储过程查询 [ ^ ]

Answer has been provided here: Update query for stored procedure[^]

这篇关于更新与标签消息对应的下拉列表的问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！