示例#1
0
        public static void UpdateLevelStatus(GlLevel glevel)
        {
            string        connectionString = DataManager.OraConnString();
            SqlConnection sqlCon           = new SqlConnection(connectionString);
            string        query            = "update gl_level_type set status='" + glevel.Status + "', autho_user='******',autho_date=convert(datetime,'" + glevel.AuthoDate + "',103) where lvl_code='" + glevel.LvlCode + "'";

            DataManager.ExecuteNonQuery(connectionString, query);
        }
示例#2
0
        public static void InsertLevel(GlLevel glevel)
        {
            string        connectionString = DataManager.OraConnString();
            SqlConnection sqlCon           = new SqlConnection(connectionString);
            string        query            = "insert into gl_level_type (lvl_code, lvl_desc,lvl_max_size,lvl_enabled,lvl_order,lvl_seg_type,book_name,status,entry_user,entry_date) values ('" + glevel.LvlCode + "', '" + glevel.LvlDesc + "', '" + glevel.LvlMaxSize + "', " +
                                             " '" + glevel.LvlEnabled + "', convert(numeric,case '" + glevel.LvlOrder + "' when '' then null else '" + glevel.LvlOrder + "' end), '" + glevel.LvlSegType + "', '" + glevel.BookName + "','" + glevel.Status + "','" + glevel.EntryUser + "',convert(datetime,'" + glevel.EntryDate + "',103) )";

            DataManager.ExecuteNonQuery(connectionString, query);
        }
示例#3
0
        public static void UpdateLevel(GlLevel glevel)
        {
            string        connectionString = DataManager.OraConnString();
            SqlConnection sqlCon           = new SqlConnection(connectionString);
            string        query            = "update gl_level_type set lvl_desc='" + glevel.LvlDesc + "',lvl_max_size='" + glevel.LvlMaxSize + "', " +
                                             " lvl_enabled='" + glevel.LvlEnabled + "', lvl_seg_type='" + glevel.LvlSegType + "', lvl_order=convert(numeric,case '" + glevel.LvlOrder + "' when '' then null else '" + glevel.LvlOrder + "' end) " +
                                             " where lvl_code='" + glevel.LvlCode + "'";

            DataManager.ExecuteNonQuery(connectionString, query);
        }