不存在同一部门的指定 [英] designation with same department does not exist
本文介绍了不存在同一部门的指定的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿嘿
i有一个adim用户..当管理员添加adim主管并将指定主管和部门设置为计算机科学时...然后再次管理添加帐户并尝试添加管理员并设置他的指定主管和部门计算机科学然后在这里我想显示错误
code
protected void Btn_SignUp_Click( object sender,EventArgs e)
{
public void SignUp( string 用户名,字符串密码, int UserTypeID, int DepID, int desigid, string emailaddress, string PhoneNumber)
{
db.ExecuteScalar( spadminreg, new object [] {Username,Password,UserTypeID,DepID, desigid,emailaddress,PhoneNumber});
}
解决方案
在发布的代码中稍作修改。
ALTER procedure [dbo]。 [spadminreg]
@ UserName nvarchar ( 50 ),
@ Password nvarchar ( 50 ),
@ UserTypeID int ,
< span class =code-sdkkeyword> @ DepID int ,
@DesigID int ,
@ emailaddress nvarchar ( 50 ),
@ PhoneNumber nvarchar ( 50 ),
@ action nvarchar ( 50 )
AS
BEGIN
if (@ action = ' CheckDuplicate')
BEGIN
选择 count(*)来自用户 where UserTypeID = @ UserTypeID AND DepID = @DepID 和 DesigID = @ DesigID;
END
if (@ action = ' 插入')
BEGIN
插入 进入 [Userss](UserName,Password,UserTypeID,DepID,CreateDate,DesigID,Email,PhoneNumber)
values
( @ UserName , @ Password , @ UserTypeID , @ DepID ,GETDATE(), @DesigID , @ emailaddress , @ PhoneNumber )
END
end
GO
&在c#代码..
public void AdminSignUp( string 用户名,字符串密码, int UserTypeID, int DepID, int desigid, string emailaddress, string PhoneNumber)
{
try {
// - 在使用此部件之前,请检查执行标量元数据的正确返回类型。然后尝试将其转换为int,以便您可以获得重复行的数量
int count = Convert.toInt32(db.ExecuteScalar(< span class =code-string> spadminreg, new object [] {Username,Password,UserTypeID,DepID,desigid,emailaddress,PhoneNumber, CheckDuplicate跨度>}));
if (count> 0)
{
// 存在重复条目
}
else
{
// 插入数据库。
}
}
catch (例外)
{
}
}
HEY
i have a adim users.. when once adim supervisor added by admin and set designation supervisor and department as computer science .. then when again admin add account and try to add admin and set his designation supervisor and department computer science then here i want to show error
code
protected void Btn_SignUp_Click(object sender, EventArgs e)
{
public void SignUp(string Username, string Password, int UserTypeID, int DepID, int desigid, string emailaddress, string PhoneNumber)
{
db.ExecuteScalar("spadminreg", new object[] { Username, Password, UserTypeID, DepID, desigid, emailaddress, PhoneNumber });
}
解决方案
Make little bit change in your posted code.
ALTER procedure [dbo].[spadminreg] @UserName nvarchar(50), @Password nvarchar(50), @UserTypeID int, @DepID int, @DesigID int, @emailaddress nvarchar(50), @PhoneNumber nvarchar(50), @action nvarchar(50) AS BEGIN if(@action='CheckDuplicate') BEGIN Select count(*) from Userss where UserTypeID=@UserTypeID AND DepID=@DepID And DesigID=@DesigID; END if(@action='Insert') BEGIN insert into [Userss](UserName,Password,UserTypeID,DepID,CreateDate,DesigID,Email ,PhoneNumber) values (@UserName,@Password,@UserTypeID,@DepID,GETDATE(),@DesigID,@emailaddress,@PhoneNumber) END end GO
& in c# code ..
public void AdminSignUp(string Username, string Password, int UserTypeID, int DepID, int desigid, string emailaddress, string PhoneNumber) { try{ //--before using this part check proper return type for your execute scalar metod & then try to convert it to int so that you can get count of duplicate rows int count= Convert.toInt32( db.ExecuteScalar("spadminreg", new object[] { Username, Password, UserTypeID, DepID, desigid, emailaddress, PhoneNumber ,"CheckDuplicate"})); if(count>0) { // Duplicate entries are present } else { //Insert into data base. } } catch(Exception) { } }
这篇关于不存在同一部门的指定的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文