[导入]判断数据库中是否存在某一值

ALTER PROCEDURE [dbo].[Spe_ReagentUseInfo_IsHaveInfo]

 -- Add the parameters for the stored procedure here

 @Position nvarchar(20),

    @ReagentNO nvarchar(20)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

    -- Insert statements for procedure here

 IF exists(select 1 from Spe_ReagentUseInfo where ReagentNO=@ReagentNO AND Department=@Position)

       return 1

    else

       return 0

END

 

#region 判断是否存在某试剂的使用记录

        /// <summary>

        /// 判断是否存在某试剂的使用记录

        /// </summary>

        /// <param name="ReagentNO">试剂编号</param>

        /// <returns></returns>

        public bool IsHaveInfo(string Pos , string ReagentNO)

        {

            Database db = new Database();

            SqlParameter[] prams =

                                   {      

                                    db.MakeInParam("@Position" , SqlDbType.NVarChar , 20, Pos),

                                       db.MakeInParam("@ReagentNO" , SqlDbType.NVarChar , 20, ReagentNO)

                                    };

            try

            {

                if (db.RunProc("Spe_ReagentUseInfo_IsHaveInfo", prams) == 1)

                {

                    return true;

                }

                else

                {

                    return false;

                }

            }

            catch (Exception exc)

            {

                Error.Log(exc.ToString());

                return false;

            }

        }

#endregion IsHaveInfo

文章来源:http://blog.163.com/kwanchan@yeah/blog/static/8553861420086591649193