示例#1
0
        public List <Rcbp1> GetSpsList(List_Rcbp1 request)
        {
            List <Rcbp1> Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
                {
                    int    count    = int.Parse(request.RecordCount);
                    string strWhere = "";
                    if (!string.IsNullOrEmpty(request.BusinessPartyName))
                    {
                        strWhere = " Where PartyType='CL' And BusinessPartyName LIKE '" + request.BusinessPartyName + "%'";
                    }
                    string strSelect = "SELECT " +
                                       "r1.*, (Select Top 1 CountryName From Rccy1 Where CountryCode=r1.CountryCode) AS CountryName " +
                                       "FROM Rcbp1 r1," +
                                       "(SELECT TOP " + (count + 20) + " row_number() OVER (ORDER BY BusinessPartyName ASC) n, TrxNo FROM Rcbp1 " + strWhere + ") r2 " +
                                       "WHERE r1.TrxNo = r2.TrxNo AND r2.n > " + count;
                    string strOrderBy = " ORDER BY r2.n ASC";
                    string strSQL     = strSelect + strOrderBy;
                    Result = db.Select <Rcbp1>(strSQL);
                }
            }
            catch { throw; }
            return(Result);
        }
示例#2
0
        public List <Rcbp1> GetList(List_Rcbp1 request)
        {
            List <Rcbp1> Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
                {
                    if (!string.IsNullOrEmpty(request.BusinessPartyName))
                    {
                        string strSQL = "Select *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' And PartyType='CL' And BusinessPartyName LIKE '" + request.BusinessPartyName + "%' Order By BusinessPartyCode Asc";
                        Result = db.Select <Rcbp1>(strSQL);
                    }
                    else if (!string.IsNullOrEmpty(request.TrxNo))
                    {
                        string strSQL = "Select *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' And TrxNo=" + int.Parse(request.TrxNo);
                        Result = db.Select <Rcbp1>(strSQL);
                    }
                    else
                    {
                        string strSQL = "Select Top 20 *,(Select Top 1 CountryName From Rccy1 Where CountryCode=Rcbp1.CountryCode) AS CountryName From Rcbp1 Where IsNUll(StatusCode,'')<>'DEL' And PartyType='CL' Order By BusinessPartyName Asc";
                        Result = db.Select <Rcbp1>(strSQL);
                    }
                }
            }
            catch { throw; }
            return(Result);
        }