Пример #1
0
        /// <summary>
        /// 로컬저장소 스키마 유효성 검사
        /// </summary>
        private void CheckSchema()
        {
            //계정 테이블 유효성 검사
            var e = OperateQueryHandler.DoQuery(CreateTableQuery.T_SETTER);

            if (e != null)
            {
                Console.Out.WriteLineAsync(string.Format("{0}", e.ToString()));
            }
        }
Пример #2
0
 public override void UPDATE(SetterDTO dto)
 {
     var query = new OperateQueryHandler(SharedPreference.Instance.DBM.Conn)
     {
         // Query = $@"UPDATE T_CUSTOMER SET DURATION_OF_WORKING = '{dto.DURATION_OF_WORKING}' WHERE USER_ID ='{dto.USER_ID}'"
         Query = $@"UPDATE T_SETTER SET 
                     DURATION_PER_WORKING = '{ dto.DURATION_PER_WORKING }', 
                     DURATION_PER_SHORT_BREAK = '{ dto.DURATION_PER_SHORT_BREAK }', 
                     DURATION_PER_LONG_BREAK = '{ dto.DURATION_PER_LONG_BREAK }', 
                     INTERVAL_OF_LONG_BREAK ='{ dto.INTERVAL_OF_LONG_BREAK }', 
                     IS_PLAY_BEEP ='{dto.IS_PLAY_BEEP}'"
     };
     var e = query.DoQuery();
 }