public static void DeleteMapDetail(MapDtl mapdtl)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "delete from gl_st_map_dtl where type_code='" + mapdtl.TypeCode + "' and sl_no=" + mapdtl.SlNo + " ";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void UpdateMapDetail(MapDtl mapdtl)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "update gl_st_map_dtl set gl_seg_code='" + mapdtl.GlSegCode + "', " +
" description='" + mapdtl.Description + "',add_less='" + mapdtl.AddLess + "',bal_from='" + mapdtl.BalFrom + "', " +
" cons_amt= convert(numeric,case '" + mapdtl.ConsAmt.Replace(",", "") + "' when '' then null else '" + mapdtl.ConsAmt.Replace(",", "") + "' end ) where type_code='" + mapdtl.TypeCode + "' and sl_no= convert (numeric, case '" + mapdtl.SlNo + "' when '' then null else '" + mapdtl.SlNo + "' end )";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateMapDetail(MapDtl mapdtl)
{
string connectionString = DataManager.OraConnString();
SqlConnection oracon = new SqlConnection(connectionString);
string query = "insert into gl_st_map_dtl (book_name,type_code,ver_no,sl_no,gl_seg_code,description,add_less,bal_from,cons_amt) " +
" values ('" + mapdtl.BookName + "','" + mapdtl.TypeCode + "','" + mapdtl.VerNo + "', convert (numeric, case '" + mapdtl.SlNo + "' when '' then null else '" + mapdtl.SlNo + "' end), " +
" '" + mapdtl.GlSegCode + "','" + mapdtl.Description + "','" + mapdtl.AddLess + "','" + mapdtl.BalFrom + "', convert(numeric, case '" + mapdtl.ConsAmt.Replace(",", "") + "' when '' then null else '" + mapdtl.ConsAmt.Replace(",", "") + "' end ))";
DataManager.ExecuteNonQuery(connectionString, query);
}
