C# DataLayer.GetQuery方法代码示例

 public DataSet getComments(Comments commentObj, string connectionString)
 {
     SqlParameter pCommentId = new SqlParameter("@CommentId", SqlDbType.Int, 0);
     pCommentId.Value = commentObj.CommentId;
     SqlCommand cmd = new SqlCommand();
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.CommandText = "usp_GetCommentInfo";
     cmd.Parameters.Add(pCommentId);
     DataSet ds = new DataSet();
     DataLayer dataLayerObj = new DataLayer();
     ds = dataLayerObj.GetQuery(cmd, connectionString);
     return ds;
 }

 public DataSet getAdvice(int QueryId, string connectionString)
 {
     SqlParameter paramQueryId = new SqlParameter("@QueryId", SqlDbType.Int);
     paramQueryId.Value = QueryId;
     SqlCommand cmd = new SqlCommand();
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.CommandText = "usp_GetAdviceByQueryId";
     cmd.Parameters.Add(paramQueryId);
     DataSet ds = new DataSet();
     DataLayer dataLayerObj = new DataLayer();
     ds = dataLayerObj.GetQuery(cmd, connectionString);
     return ds;
 }

        private DataSet GetUserData(AuthTable user, string connString)
        {
            SqlParameter pUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
            pUsername.Value = user.Username;

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_SelectUserByUsername";
            cmdSQL.Parameters.Add(pUsername);

            DataLayer dataLayerObj = new DataLayer();
            DataSet ds = dataLayerObj.GetQuery(cmdSQL, connString);
            return ds;
        }

        public DataSet getDoctor(string connectionString)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "usp_getDoctor";
            DataLayer dataLayerObj = new DataLayer();
            DataSet dsDoctor = new DataSet();

            dsDoctor = dataLayerObj.GetQuery(cmd, connectionString);
            return dsDoctor;
        }

        public DataSet SelectTopTenAdvice(Query queryObj, string connString)
        {
            DataSet dsTopAdvice = new DataSet();
            SqlParameter pAreaOfInterest = new SqlParameter("@QueryAreaOfInterest", SqlDbType.NVarChar, 100);
            pAreaOfInterest.Value = queryObj.QueryAreaOfInterest;

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_GetTopTenAdvice";
            cmdSQL.Parameters.Add(pAreaOfInterest);
            DataLayer dataLayerObj = new DataLayer();
            dsTopAdvice = dataLayerObj.GetQuery(cmdSQL, connString);
            return dsTopAdvice;
        }

        public DataSet SelectQuery(Query queryObj, string connString)
        {
            DataSet dsQuery = new DataSet();
            SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.Int, 0);
            pQueryId.Value = queryObj.QueryId;

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_GetQueryDetails";
            cmdSQL.Parameters.Add(pQueryId);
            DataLayer datalayerObj = new DataLayer();
            dsQuery = datalayerObj.GetQuery(cmdSQL, connString);
            return dsQuery;
        }

        public DataSet SelectComment(Comments commentObj, string connString)
        {
            DataSet dsComment = new DataSet();
            SqlParameter pAdviceId = new SqlParameter("@AdviceId", SqlDbType.Int, 0);
            pAdviceId.Value = commentObj.AdviceId;

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_GetCommentDetails";
            cmdSQL.Parameters.Add(pAdviceId);
            DataLayer datalayerObj = new DataLayer();
            dsComment = datalayerObj.GetQuery(cmdSQL, connString);
            return dsComment;
        }

        public DataSet SelectAdvice(Advice adviceObj, string connString)
        {
            DataSet dsAdvice = new DataSet();
            SqlParameter pAdviceId = new SqlParameter("@AdviceId", SqlDbType.Int, 0);
            pAdviceId.Value = adviceObj.AdviceId;

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_GetAdvice";
            cmdSQL.Parameters.Add(pAdviceId);
            DataLayer datalayerObj = new DataLayer();
            dsAdvice = datalayerObj.GetQuery(cmdSQL, connString);
            return dsAdvice;
        }

 public DataSet getWorkList(bool isAttendedTo, Doctor doc, string connectionString)
 {
     SqlParameter paramIsAttendedTo = new SqlParameter("@IsAttendedTo", SqlDbType.Bit);
     SqlParameter paramUserName = new SqlParameter("@UserName", SqlDbType.VarChar);
     paramUserName.Value = doc.Username;
     paramIsAttendedTo.Value = isAttendedTo;
     SqlCommand cmd = new SqlCommand();
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.CommandText = "usp_GetQueryByIsAttended";
     cmd.Parameters.Add(paramIsAttendedTo);
     cmd.Parameters.Add(paramUserName);
     DataSet ds = new DataSet();
     DataLayer dataLayerObj = new DataLayer();
     ds = dataLayerObj.GetQuery(cmd, connectionString);
     return ds;
 }

        public DataSet GetQueryWithFurtherUserDetails(Query queryObj, string connString)
        {
            DataSet dsQuery = new DataSet();
            SqlParameter pQueryUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
            SqlParameter pQueryStatus = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
            pQueryUsername.Value = queryObj.Username;
            pQueryStatus.Value = "Needs More Info";

            SqlCommand cmdSQL = new SqlCommand();
            cmdSQL.CommandType = CommandType.StoredProcedure;
            cmdSQL.CommandText = "usp_GetQueryWithFurtherUserDetail";
            cmdSQL.Parameters.Add(pQueryUsername);
            cmdSQL.Parameters.Add(pQueryStatus);
            DataLayer datalayerObj = new DataLayer();
            dsQuery = datalayerObj.GetQuery(cmdSQL, connString);
            return dsQuery;
        }

        public DataSet GetQuery(int queryId, string connString)
        {
            SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.Int);

            pQueryId.Value = queryId;

            SqlCommand cmdSql = new SqlCommand();
            cmdSql.CommandType = CommandType.StoredProcedure;
            cmdSql.CommandText = "usp_GetQueryById";

            cmdSql.Parameters.Add(pQueryId);

            DataLayer dataLayerObj = new DataLayer();
            DataSet ds = new DataSet();
            ds = dataLayerObj.GetQuery(cmdSql, connString);

            return ds;
        }

        public DataSet getQuerryBySymptoms(string Symptoms, string connectionString)
        {
            SqlParameter paramSymptoms = new SqlParameter("@Symptoms", SqlDbType.NVarChar);
            paramSymptoms.Value = Symptoms;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "usp_GetQueryBySymptoms";
            cmd.Parameters.Add(paramSymptoms);
            DataLayer dataLayerObj = new DataLayer();
            DataSet ds = new DataSet();

            ds = dataLayerObj.GetQuery(cmd, connectionString);
            return ds;
        }

        public DataSet getQuerryByMedicine(string medicine, string connectionString)
        {
            SqlParameter paramdisease = new SqlParameter("@MedicineName", SqlDbType.VarChar);
            paramdisease.Value = medicine;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "usp_SearchQueryByMedicine";
            cmd.Parameters.Add(paramdisease);
            DataLayer dataLayerObj = new DataLayer();
            DataSet ds = new DataSet();

            ds = dataLayerObj.GetQuery(cmd, connectionString);
            return ds;
        }

        public DataSet getQuerryByDoctor(string doctor, string connectionString)
        {
            SqlParameter paramdoc = new SqlParameter("@DocName", SqlDbType.NVarChar);
            paramdoc.Value = doctor;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "usp_GetQueryByDocId";
            cmd.Parameters.Add(paramdoc);
            DataLayer dataLayerObj = new DataLayer();
            DataSet ds = new DataSet();

            ds = dataLayerObj.GetQuery(cmd, connectionString);
            return ds;
        }