/// <summary>
/// 判断用户是否存在
/// </summary>
/// <param name=P_Str_Name>会员登录名</param>
/// <param name=P_Str_Password>会员登录密码</param>
/// <returns></returns>
public int UserExists(string P_Str_Name string P_Str_Password) {
SqlConnection myConn = dbObjGetConnection()
SqlCommand myCmd = new SqlCommand(Pr_UserExists myConn)
myCmdCommandType = CommandTypeStoredProcedure;
//添加参数
SqlParameter Name = new SqlParameter(@Name SqlDbTypeVarChar )
NameValue = P_Str_Name;
myCmdParametersAdd(Name)
SqlParameter Password = new SqlParameter(@Password SqlDbTypeVarChar )
PasswordValue = P_Str_Password;
myCmdParametersAdd(Password)
SqlParameter returnValue = myCmdParametersAdd(returnValue
SqlDbTypeInt )
returnValueDirection = ParameterDirectionReturnValue;
//执行过程
myConnOpen()
try {
myCmdExecuteNonQuery()
}
catch (Exception ex) {
throw (ex)
}
finally {
myCmdDispose()
myConnClose()
}
int P_Int_returnValue = ConvertToInt(returnValueValueToString())
return P_Int_returnValue;
}