Esempio n. 1
0
        //--------------------------------------------------------------
        public static string Static_GetDisplayString(int PriceList)
        {
            string     RetVal       = "";
            PriceLists m_PriceLists = new PriceLists();

            m_PriceLists.PriceList = PriceList;
            m_PriceLists           = m_PriceLists.Get();
            RetVal = m_PriceLists.PriceListName;
            return(RetVal);
        }
Esempio n. 2
0
        //-----------------------------------------------------------
        #region Method
        private List <PriceLists> Init(SqlCommand cmd)
        {
            SqlConnection con = db.getConnection();

            cmd.Connection = con;
            List <PriceLists> l_PriceLists = new List <PriceLists>();

            try
            {
                con.Open();
                SqlDataReader   reader      = cmd.ExecuteReader();
                SmartDataReader smartReader = new SmartDataReader(reader);
                while (smartReader.Read())
                {
                    PriceLists m_PriceLists = new PriceLists();
                    m_PriceLists.PriceList       = smartReader.GetInt32("PriceList");
                    m_PriceLists.PriceListName   = smartReader.GetString("PriceListName");
                    m_PriceLists.PriceListDesc   = smartReader.GetString("PriceListDesc");
                    m_PriceLists.PriceListTypeId = smartReader.GetByte("PriceListTypeId");
                    m_PriceLists.IsDetail        = smartReader.GetByte("IsDetail");
                    m_PriceLists.StatusId        = smartReader.GetByte("StatusId");
                    m_PriceLists.DisplayOrder    = smartReader.GetInt32("DisplayOrder");
                    m_PriceLists.CrUserId        = smartReader.GetInt32("CrUserId");
                    m_PriceLists.UpdateUserId    = smartReader.GetInt32("UpdateUserId");
                    m_PriceLists.CrDateTime      = smartReader.GetDateTime("CrDateTime");
                    l_PriceLists.Add(m_PriceLists);
                }
                reader.Close();
                return(l_PriceLists);
            }
            catch (SqlException err)
            {
                throw new ApplicationException("Data error: " + err.Message);
            }
            finally
            {
                db.closeConnection(con);
            }
        }
Esempio n. 3
0
        //--------------------------------------------------------------
        public PriceLists Get()
        {
            PriceLists retVal     = new PriceLists();
            int        RowCount   = 0;
            string     DateFrom   = "";
            string     DateTo     = "";
            string     OrderBy    = "";
            int        PageSize   = 1;
            int        PageNumber = 0;

            try
            {
                List <PriceLists> list = GetPage(DateFrom, DateTo, OrderBy, PageSize, PageNumber, ref RowCount);
                if (list.Count > 0)
                {
                    retVal = list[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(retVal);
        }