public static void UpdateMapBreak(MapBreak mapbrk)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "update gl_st_break_dtl set sl_no='" + mapbrk.SlNo + "', gl_seg_code='" + mapbrk.GlSegCode + "' where type_code= '" + mapbrk.TypeCode + "' ";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateMapBreak(MapBreak mapbrk)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "insert into gl_st_break_dtl (book_name,type_code,ver_no,ref_sl_no,sl_no,gl_seg_code) " +
" values ('" + mapbrk.BookName + "','" + mapbrk.TypeCode + "','" + mapbrk.VerNo + "', convert (numeric, case '" + mapbrk.RefSlNo + "' when '' then null else '" + mapbrk.RefSlNo + "' end) , " +
" convert (numeric, case '" + mapbrk.SlNo + "' when '' then null else '" + mapbrk.SlNo + "' end),'" + mapbrk.GlSegCode + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
