DAL添加数据，查询数据

DAL添加数据，查询数据：

  /// <summary>
        ///   //添加收货人信息
        /// </summary>      
        /// <returns></returns>
        /// 
        public bool insertGErenXINxi(string sheng, string shi, string dizhi, string shouji, string guhua, string youxiang, string youbian, string username, string shouhuoren)
        {
            bool flag = false;
            string cmdText = "US_insertGErenXINxi";
            SqlParameter[] paras = new SqlParameter[]{
            new SqlParameter("@sheng",sheng),
            new SqlParameter("@shi",shi),
            new SqlParameter("@dizhi",dizhi),
            new SqlParameter("@shouji",shouji),
            new SqlParameter("@guhua",guhua),
            new SqlParameter("@youxiang",youxiang),
            new SqlParameter("@youbian",youbian),
            new SqlParameter("@username",username),
            new SqlParameter("@shouhuoren",shouhuoren)    
             
           };

            int res = sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure);
            if (res > 0)
            {
                flag = true;

            }

            return flag;
        }

查询数据

        /// <summary>
        /// 根据UserName查找所有提交的订单分页
        /// </summary>      
        /// <returns></returns>

        public DataTable selectDingDanByUserNameFenYeG(string UserNAME, int StartRecordIndex, int EndRecordIndex)
        {
            DataTable dt = new DataTable();
            string cmdText = "SC_selectDingDanByUserNameFenYeG";
            SqlParameter[] para = new SqlParameter[]{
                 new SqlParameter("@UserNAME",UserNAME),       
                new SqlParameter("@startIndex",StartRecordIndex),
                new SqlParameter("@endindex",EndRecordIndex)
               
            };
            dt = sqlhelper.ExecuteQuery(cmdText, para, CommandType.StoredProcedure);

            return dt;
        }