示例#1
0
        /// <summary>
        /// select_register
        /// The Procedure which selects the Register from TLOG_HIST to Update with the Current Date
        /// </summary>
        public void select_register()
        {
            //#ifdef debuga
            // #debugb  Console.WriteLine("FLOW: select_register"
            //#endif

            TLOG_HIST TLOGHIST = db.TLOG_HISTs.FirstOrDefault(i => i.DA_TIMESTMP_CRE == currentdate0).OrderBy(i => i.STORE_NO, i.REGISTER_NO).OrderByDescending();

            int tloghist_store_no    = Convert.ToInt32(TLOGHIST.STORE_NO.Trim());
            var tloghist_register_no = TLOGHIST.REGISTER_NO.Trim();

            update_register();

            return;
        }
示例#2
0
        /// <summary>
        /// create_tlog_history
        /// This procedure inserts a row in the TLOG_HIST Record.
        /// </summary>
        public void create_tlog_history(TLOG_HIST data)
        {
            //#debugc Console.WriteLine("#tlog_obj_cd is " #tlog_obj_cd
            TLOG_HIST tlog = new TLOG_HIST();

            tlog.STORE_NO           = data.STORE_NO;
            tlog.TRANSACTION_DATE   = data.TRANSACTION_DATE;
            tlog.TRANSACTION_NO     = data.TRANSACTION_NO;
            tlog.GIFT_CARD_NUMBER   = data.GIFT_CARD_NUMBER;
            tlog.AUTHORIZATION_CODE = data.AUTHORIZATION_CODE;
            tlog.REGISTER_NO        = data.REGISTER_NO;
            tlog.POS_CARD_AUTH_TYPE = data.POS_CARD_AUTH_TYPE;
            tlog.POS_GIFT_CARD_FLAG = 6;
            tlog.GROSS_LINE_AMOUNT  = data.GROSS_LINE_AMOUNT;
            tlog.REMAING_CARD_BAL   = data.REMAING_CARD_BAL;
            tlog.LINE_OBJECT_TYPE   = data.LINE_OBJECT_TYPE;
            tlog.PROMO_CODE         = data.PROMO_CODE;
            tlog.PROMO_CODE_SUB     = data.PROMO_CODE_SUB;
            tlog.DA_TIMESTMP_CRE    = data.DA_TIMESTMP_CRE;
            db.TLOG_HIST.InsertOnSubmit(tlog);
            db.SubmitChanges();

            return;
        }