Ejemplo n.º 1
0
        public static StationCashSr CreateFromDataRow(DataRow dr)
        {
            StationCashSr scs = new StationCashSr();

            scs.FillFromDataRow(dr);

            return(scs);
        }
Ejemplo n.º 2
0
        public static List <StationCashSr> GetStationCashListByQuery(string sQuery, List <IDbDataParameter> lParams)
        {
            List <StationCashSr> lResult = new List <StationCashSr>();

            using (DataTable dt = DataCopy.GetDataTableWithSqlParams(sQuery, lParams))
            {
                if (dt != null)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        StationCashSr tqs = StationCashSr.CreateFromDataRow(dr);

                        lResult.Add(tqs);
                    }
                }
            }

            return(lResult);
        }
Ejemplo n.º 3
0
        public static StationCashSr[] GetStartDates()
        {
            try
            {
                List <StationCashSr> lStationCash = StationCashSr.GetStationCashListByQuery("SELECT * FROM StationCash where StationCash.CashCheckPoint = 1 order by DateModified desc", new List <IDbDataParameter>());

                List <StationCashSr> cashin = StationCashSr.GetStationCashListByQuery("SELECT * FROM StationCash where StationCash.MoneyIn = 1 order by DateModified asc", new List <IDbDataParameter>());

                if (cashin.Count > 0)
                {
                    cashin[0].DateModified = cashin[0].DateModified.AddSeconds(-1);
                    lStationCash.Add(cashin[0]);
                }
                return(lStationCash.ToArray());
            }
            catch (Exception)
            {
            }
            return(null);
        }