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);
}
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);
}
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);
}