Beispiel #1
0
        public bool Updateit1() //update insert field of database in autbazrasservice for bazrasservicereport
        {
            ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase();
            try
            {
                DB.setQuery(@"
                    update AUTBazRasService Set InsertDate=getdate()
                    where code=" + Code + "");
                DB.Query_Execute();
            }
            finally
            {
                DB.Dispose();
            }
            JBazRasServiceTable BST = new JBazRasServiceTable();

            BST.SetValueProperty(this);
            return(BST.Update());
        }
Beispiel #2
0
        public bool Update(bool RefershAgain)
        {
            if (RefershAgain)
            {
                ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase();
                try
                {
                    DB.setQuery(@"delete from AutBusServices where ISOK = 11 and EzamBeCode = " + Code);
                    // exec[SP_UpdateBazrasService] '" + MoveDate.ToString("yyyy-MM-dd") + "'");
                    DB.Query_Execute(true);
                }
                catch
                {
                }
                finally
                {
                    // DB.Dispose();
                }
            }
            else
            {
                ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase();
                try
                {
                    DB.setQuery(@"delete from AutBusServices where ISOK = 11 and  EzamBeCode = " + Code);
                    DB.Query_Execute(true);
                }
                catch
                {
                }
                finally
                {
                    // DB.Dispose();
                }
            }
            JBazRasServiceTable BST = new JBazRasServiceTable();

            BST.SetValueProperty(this);
            return(BST.Update());
        }