Пример #1
0
            public bool TableQuestionnaireDeleteAllRecords(ref string sRtnMsg)
            {
                string sSQL;
                LocalDB DB = new LocalDB();

                if (DB.TableExists(sDocQuestionnaireTableName))
                {

                    sSQL = "delete from " + sDocQuestionnaireTableName;
                    return DB.ExecuteSQL(sSQL, ref sRtnMsg);
                }
                else
                {
                    return true;
                }
            }
Пример #2
0
            public bool TableITPDocumentSectionDeleteAllRecords(ref string sRtnMsg)
            {
                string sSQL;
                LocalDB DB = new LocalDB();

                if (DB.TableExists(sITPDocumentSectionTableName))
                {

                    sSQL = "delete from " + sITPDocumentSectionTableName;
                    return DB.ExecuteSQL(sSQL, ref sRtnMsg);
                }
                else
                {
                    return true;
                }
            }
Пример #3
0
            public bool TableHeaderDeleteAllRecords(string sId, ref string sRtnMsg)
            {
                string sSQL;
                LocalDB DB = new LocalDB();

                if (DB.TableExists(sDocHeaderTableName))
                {

                    sSQL = "delete from " + sDocHeaderTableName + " where ID = '" + sId + "'";
                    return DB.ExecuteSQL(sSQL, ref sRtnMsg);
                }
                else
                {
                    return true;
                }
            }
Пример #4
0
            public bool ITPProjectSectionDeleteAllSection10Items(string sId, ref string sRtnMsg)
            {
                string sSQL;
                LocalDB DB = new LocalDB();

                if (DB.TableExists(sITPSection10TableName))
                {

                    sSQL = "delete from " + sITPSection10TableName + " where ID = '" + sId + "'";
                    return DB.ExecuteSQL(sSQL, ref sRtnMsg);
                }
                else
                {
                    return true;
                }
            }