예제 #1
0
        public static void StoreInstr(Decimal no,String non_ASCII_chars, String eq_bytes,String instr01,Decimal num_instr,String uselessInstr, Decimal num_useless,String status )
        {
            //Decimal xno = 0;
            //xno = connectToDB.getSrno();
            //Insertion
            DataClasses1DataContext d = new DataClasses1DataContext(conn);
            Instr s1 = new Instr
            {
                srno = no,
               non_ASCII_chars=non_ASCII_chars ,
               eq_byte=eq_bytes,
               instr01=instr01 ,
               num_instr=num_instr ,
               useless_instr=uselessInstr,
               num_useless=num_useless,
               status =status
            };

            d.Instrs.InsertOnSubmit(s1);
            // Submit the change to the database.
            try
            {
                d.SubmitChanges();

            }
            catch (Exception e)
            {

                d.SubmitChanges();
            }
        }
예제 #2
0
        public static int getSrno()
        {
            //Selection
            DataClasses1DataContext d = new DataClasses1DataContext();

            var num = from u in d.request_infos orderby u.srno descending select u.srno;
            foreach (var a in num)
            {
                return Convert.ToInt32(a + 1);
            }
            return 0;
        }
예제 #3
0
        public static void StoreInDB(Decimal xno ,String xurl, DateTime DTime, String ConAscii)
        {
            //Insertion
               DataClasses1DataContext d = new DataClasses1DataContext(conn);
            request_info s1 = new request_info
            {
                srno = xno,
                url = xurl.ToString(),
                date_time = Convert.ToDateTime(DTime),
                contain_NON_ascii = ConAscii
            };

            d.request_infos.InsertOnSubmit(s1);
            // Submit the change to the database.
            try
            {
                d.SubmitChanges();

            }
            catch (Exception e)
            {
                d.SubmitChanges();
            }
        }