public static void DeleteMapMaster(MapMst mapmst) { string connectionString = DataManager.OraConnString(); SqlConnection oracon = new SqlConnection(connectionString); string query = "delete from gl_st_map_mst where type_code='" + mapmst.TypeCode + "'"; DataManager.ExecuteNonQuery(connectionString, query); }
public static void UpdateMapMaster(MapMst mapmst) { string connectionString = DataManager.OraConnString(); SqlConnection oracon = new SqlConnection(connectionString); string query = "update gl_st_map_mst set ver_no='" + mapmst.VerNo + "',description='" + mapmst.Description + "', " + " ref_type_code='" + mapmst.RefTypeCode + "', ref_ver_no='" + mapmst.RefVerNo + "',active='" + mapmst.Active + "',autho_user='******',autho_date=convert(datetime,case '" + mapmst.AuthoDate + "' when '' then null else '" + mapmst.AuthoDate + "' end,103) where type_code='" + mapmst.TypeCode + "'"; DataManager.ExecuteNonQuery(connectionString, query); }
public static void CreateMapMaster(MapMst mapmst) { string connectionString = DataManager.OraConnString(); SqlConnection oracon = new SqlConnection(connectionString); string query = "insert into gl_st_map_mst (book_name,type_code,ver_no,description,ref_type_code,ref_ver_no,active,entry_user,entry_date) " + " values ('" + mapmst.BookName + "', '" + mapmst.TypeCode + "', '" + mapmst.VerNo + "', '" + mapmst.Description + "', " + " '" + mapmst.RefTypeCode + "', '" + mapmst.RefVerNo + "','" + mapmst.Active + "','" + mapmst.EntryUser + "',convert(datetime,'" + mapmst.EntryDate + "',103))"; DataManager.ExecuteNonQuery(connectionString, query); }