Пример #1
0
        public bool save(string connStr)
        {
            db db = new db(connStr);

            if (!db.dbOpen())
            {
                return(false);
            }

            string saveQuery = "";

            if (ID < 0)
            {
                saveQuery = getQuery("i");
            }
            else
            {
                saveQuery = getQuery("u");
            }

            if (!db.executeParamQuery(saveQuery,
                                      new DictionaryEntry("CTRLAREAID", CTRLAREAID),
                                      new DictionaryEntry("CARDID", CARDID),
                                      new DictionaryEntry("PERSONID", PERSONID),
                                      new DictionaryEntry("ADATETIME", ADATETIME),
                                      new DictionaryEntry("IS_ENTRANCE", IS_ENTRANCE),
                                      new DictionaryEntry("COMMENT", COMMENT)
                                      ))
            {
                db.dbClose(); return(false);
            }
            if (ID < 0)
            {
                // ID = Convert.ToInt32(db.executeScalar("SELECT LAST_INSERT_ID()"));
            }
            db.dbClose();

            return(true);
        }